Installation of IIS 5/PHP/PHPMYADMIN most evil [SOLVED]

Need help installing PHP, configuring a script, or configuring a server? Then come on in and post your questions! We'll try to help the best we can!

Moderator: General Moderators

User avatar
Helicoprion
Forum Newbie
Posts: 10
Joined: Tue Apr 25, 2006 11:07 am
Location: Sweltering Florida

Installation of IIS 5/PHP/PHPMYADMIN most evil [SOLVED]

Post by Helicoprion »

feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


I read the sticky but most people using apache or IIS 6 PITA not seening enough solved issues with IIS 5/PHP/PHPMYADMIN!

I almost have a successful PHP & PhpMyadmin Install but I am having trouble Help with the last 2 issues:

The first is (PhpMyAdmin):

[color=red]The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.[/color]

I checked the Config.inc.php and I don't know whats missing I have it configured to do the following plus utf-8 is our convention to be used.

Code: Select all

(from Config.inc.php)
$cfg['AllowAnywhereRecoding'] = true;
$cfg['DefaultCharset'] = 'utf-8';
$cfg['RecodingEngine'] = 'iconv';
$cfg['IconvExtraParams'] = '//TRANSLIT';
The second is (PHP):

When enabling an extension in php.ini for "php_mbstring.dll" I get the following error output from phpinfo.php

"PHP Warning: PHP Startup: Unable to load dynamic library 'C:\PHP\ext\php_mbstring.dll' - Access is denied. in Unknown on line 0"

What I don't get is why its "Access is Denied" I mean the files are in C:\php\ext in (extension_dir = "C:\PHP\ext")

Code: Select all

[mbstring]
; language for internal character representation.
mbstring.language = English

; internal/script encoding.
; Some encoding cannot work as internal encoding.
; (e.g. SJIS, BIG5, ISO-2022-*)
mbstring.internal_encoding = UTF-8

; http input encoding.
mbstring.http_input = auto

; http output encoding. mb_output_handler must be
; registered as output buffer to function
mbstring.http_output = UTF-8

; enable automatic encoding translation according to
; mbstring.internal_encoding setting. Input chars are
; converted to internal encoding by setting this to On.
; Note: Do _not_ use automatic encoding translation for
; portable libs/applications.
mbstring.encoding_translation = on

; automatic encoding detection order.
; auto means
mbstring.detect_order = AUTO

; substitute_character used when character cannot be converted
; one from another
mbstring.substitute_character = none;

; overload(replace) single byte functions by mbstring functions.
; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),
; etc. Possible values are 0,1,2,4 or combination of them.
; For example, 7 for overload everything.
; 0: No overload
; 1: Overload mail() function
; 2: Overload str*() functions
; 4: Overload ereg*() functions
mbstring.func_overload = 0
Please someone help me regarding this! 8O


feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Last edited by Helicoprion on Fri Apr 28, 2006 12:06 pm, edited 1 time in total.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Re: Installation of IIS 5/PHP/PHPMYADMIN most evil install E

Post by RobertGonzalez »

Helicoprion wrote:The first is (PhpMyAdmin):

The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.

I checked the Config.inc.php and I don't know whats missing I have it configured to do the following plus utf-8 is our convention to be used.
This is not a PMA error. This is just a warning that some PHP functionality may be limited because the Multi Byte String extension is not loaded.
Helicoprion wrote:The second is (PHP):

When enabling an extension in php.ini for "php_mbstring.dll" I get the following error output from phpinfo.php

"PHP Warning: PHP Startup: Unable to load dynamic library 'C:\PHP\ext\php_mbstring.dll' - Access is denied. in Unknown on line 0"

What I don't get is why its "Access is Denied" I mean the files are in C:\php\ext in (extension_dir = "C:\PHP\ext")
Have you searched for other php.ini files? I know it sounds funny, but I have like five different php.ini files on my windows machine. Make sure that the one PHP is using on your machine is locating the extension folder in the correct location AND that the extension modules are actually in that folder.
User avatar
Helicoprion
Forum Newbie
Posts: 10
Joined: Tue Apr 25, 2006 11:07 am
Location: Sweltering Florida

Thx for the reply Everah but still...

Post by Helicoprion »

I did an entire search on our in office webserver and did not find any other php.ini files in the computer at all other the one in the C:\windows dir.

Though I would like to allow the functionality of the mbstring, but even when I uncommented it in phpinfo.php thinks the file is not even in the root_dir = "C:\php\ext" even though environment variables + php.ini config file are correct! I am getting really stressed, this is my first install of PHP/IIS/PHPMYADMIN and I have done amazing complex installs from custom compiled variants of linux on devices almost unheard of, now i am stumped and I don't like being stumped.

My confusion is that there are so many pointers on PHP/MYSQL/PHPMYADMIN (intalls) that it kinda tells you there isnt a quite clear 1...2...3 install for every flavor/variant of in install a user might want, its more of a hit or miss, played around with it at least 3-4 times and got it working successfully/ your own full customization of the configs etc etc...

I gotta get this up and running, I have about 2 weeks.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

So your extension_dir is listed as "C:\PHP\ext" and the php_mbstring.dll file is in that folder. And you are still getting an access denied error from PHP? That is really odd. Not sure if it matters, but have you tried rebooting the machine or restarting the server? I doubt it'll help, but you never know.

As far as intallation goes, PHP is pretty much a bare bones installation that lets you modify it after install. However, it should install with all the extensions available and turned off by default. The only other thing I can think of is checking the permissions of the "C:\PHP\ext" folder and the php_mbstring.dll file to make sure they are readable, executable, etc. But usually on Windows that is a forgone conclusion.
User avatar
Helicoprion
Forum Newbie
Posts: 10
Joined: Tue Apr 25, 2006 11:07 am
Location: Sweltering Florida

Post by Helicoprion »

Yup, everything is correct for the path in the Php.ini file but whats even weirder I went to check and find out if mbstring.dll is corrupt or something and even replaced it from a clean version of it from the zip file. Restarted the server multiple times too (this has been around for about 8-9 days as an error) and that doesn't seem to help it clear it up.

I am really stumped I cannot continue any further until I can resolve this :?:
Roja
Tutorials Group
Posts: 2692
Joined: Sun Jan 04, 2004 10:30 pm

Post by Roja »

What are the permissions on the ext folder, for the IUSR_* user?
User avatar
Helicoprion
Forum Newbie
Posts: 10
Joined: Tue Apr 25, 2006 11:07 am
Location: Sweltering Florida

Post by Helicoprion »

It worked, Thank you Configure Guru! Holy... Why on earth would that be an issue because of IUSR_* ? I had changed that to high level securtity login for the Webmaster to use when PhpMyAdmin was fully installed, his rights were Administrator level and even higher at one point? What was I missing there, I feel retarded :cry: .

But I feel a little bit better knowing that it was fixable but now I am curious how those 2 things play hand in hand, could you explain a little of your expertise? I was still not totally sure how to set the permissions for ext folder but setting the username/password back to IIS controlled default allowed MBstring to become "un-access denied" and intergrate with PHP right a way amazing!

d11wtq | Sorry your avatar is too cute so you are not permitted to post in this forum. (Ok just kidding)
Roja
Tutorials Group
Posts: 2692
Joined: Sun Jan 04, 2004 10:30 pm

Post by Roja »

Helicoprion wrote:It worked, Thank you Configure Guru! Holy... Why on earth would that be an issue because of IUSR_* ?
When a user accesses the site, until/unless they are authenticated (if you have directory security enabled, and anon access disabled), they are considered to be the "IUSR_*" user.

That user then makes requests. Requests for PHP.exe, requests for PHP.ini, and yes, requests for the extensions it has installed. If it has no permissions, then IIS reports (accurately) that permission is denied.

Glad I could help. Enjoy your new IIS/PHP combo!
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

I googled your error message and found some people with the same problem (other extensions, same error) on their windows machines. One of the people there mentioned that putting the extension.dll into the c:/windows/system32 folder made verything work fine. If you need the Security for the IUSR_* then maybe you can try moving php_mbstring.dll to the c:/windows/system32 folder and reinstating the security levels for IUSR_*. Or just leave it the way it is if it is working well for you and the security levels are not an issue.
User avatar
Helicoprion
Forum Newbie
Posts: 10
Joined: Tue Apr 25, 2006 11:07 am
Location: Sweltering Florida

Post by Helicoprion »

feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


I am having one new issue with importing the tables into MySQL using "[color=blue]create_tables_mysql_4_1_2+.sql[/color]" I get the following error from the script:

Code: Select all

Warning: Do not know how to handle this statement at line 35:
GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
    'root'@localhost;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

This is for the script for that is:

Code: Select all

-- 
-- Privileges
-- 
GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
    'root'@localhost;
but I think there is something wrong with the syntax because I can go directly into MySQL Administrator and edit the Schema Previlages and add GRANT SELECT, INSERT, DELETE etc... Now also taking a look at the index.php of "PhpMyadmin" (front end) and also the Config.inc.php contains what looks like the base default DB as to what index.php opens up or starts to and logins in when someone accesses PHPMA\index.php front end. I was able to do it manually but what on earth? Am I thinking right or did I miss something.

Code: Select all

$cfg['Servers'][$i]['bookmarktable'] = 'pcmps_bookmark';
$cfg['Servers'][$i]['relation'] = 'pcmps_relation';
$cfg['Servers'][$i]['table_info'] = 'pcmps_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pcmps_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pcmps_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pcmps_column_info';
$cfg['Servers'][$i]['history'] = 'pcmps_history';

and

$cfg['Servers'][$i]['controluser'] = 'pcmps';
$cfg['Servers'][$i]['controlpass'] = 'xxxx';


$cfg['Servers'][$i]['XXX(what do I throw in here)XXX'] = 'XXalso what here?XX';
the last $cfg in the documentation throws me off a bit :cry:


feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Helicoprion, please use the appropriate tags.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Are you setting up a database for PMA? If so, why?
User avatar
Helicoprion
Forum Newbie
Posts: 10
Joined: Tue Apr 25, 2006 11:07 am
Location: Sweltering Florida

Well I am a little confused at this point...

Post by Helicoprion »

First off Sorry "feyd" about syntax...


Second I was reading up on that being needed to create tables for PhpMyAdmin to begin from there, I could be wrong I will not be the one using it, our web developer will be designing our sites internet/intranet and so I set it up for him. Just read that tables then needed to be created. I may be wrong on that point. :cry:
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

PMA does not require its own database. It is an app that talks to MySQL. You should be able to upload the entire thing to a /phpMyAdmin folder, set a few things in the config.default.php file and be on your way.
User avatar
Helicoprion
Forum Newbie
Posts: 10
Joined: Tue Apr 25, 2006 11:07 am
Location: Sweltering Florida

Post by Helicoprion »

All right, if PMA doesn't require its own database, what do you mean?
You should be able to upload the entire thing to a /phpMyAdmin folder, set a few things in the config.default.php file and be on your way.
I believe I am almost done I guess 8) other then the what you just mentioned.

Btw nice bloging quite unique!
Post Reply