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.
[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
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.
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.
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.
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.
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
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 .
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)
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.
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.
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:
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.
--
-- 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.
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]
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.
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.