Hi there,
Not that I expect this email to get anyone's attention or evoke a reply, but there isn't another option, is there?
I encountered the common problem of users who do not have MySQL root come onto, despite the fact that the config index says that its not neccessary so long as a user/pass to MySQL is given.
Checking environment...
* PHP 4.3.6 ok * PHP server API is cgi; using ugly URLs (index.php?title=Page_Title) * Have zlib support; enabling output compression. * Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads. * Installation directory: /homepages/22/d94944393/htdocs/yeago.net/wiki * Script URI path: /wiki * MySQL error 1045: Access denied for user: 'root@infong223.kundenserver.de' (Using password: YES)
---------------
I got around this, as others did, by simply changing 'root' in config/index.php to my username.
However, this causes a new problem.....
Checking environment...
* PHP 4.3.6 ok * PHP server API is cgi; using ugly URLs (index.php?title=Page_Title) * Have zlib support; enabling output compression. * Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads. * Installation directory: /homepages/22/d94944393/htdocs/yeago.net/wiki * Script URI path: /wiki
-----------------------
Yep, that's as far as it gets. It hangs and never spits out any local settings. But by using the "echo 'here'" method, I was able to trace the hanging to the return statement inside writeLocalSettings()
That is as far as I know how to follow this problem. If anyone has any insight, or if anyone is even reading this and could do me the great favor of pointing me in the direction of somewhere/someone who may yield some answers, please let me know.
-steve
Stephen Yeago wrote:
I encountered the common problem of users who do not have MySQL root come onto, despite the fact that the config index says that its not neccessary so long as a user/pass to MySQL is given.
[snip]
- MySQL error 1045: Access denied for user: 'root@infong223.kundenserver.de' (Using password: YES)
It would be really helpful to get some more details of your setup; for instance, is the username that you use to access MySQL 'root-equivalent' or nearly so? Do you have GRANT OPTION privileges (ie, the ability to create new usernames) or is that the only username you're allowed to use?
If it's the only one you can use, then you shouldn't be providing a root password; you should provide the username and password for "DB username" and "DB password". Can you confirm that this doesn't work, or that you do have GRANT OPTION privileges and can create the newly named user?
If you do have GRANT OPTION privileges and can do GRANT statements to create new user accounts, we'll try to accomodate this.
Checking environment...
- PHP 4.3.6 ok
- PHP server API is cgi; using ugly URLs (index.php?title=Page_Title)
- Have zlib support; enabling output compression.
- Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads.
- Installation directory: /homepages/22/d94944393/htdocs/yeago.net/wiki
- Script URI path: /wiki
Yep, that's as far as it gets. It hangs and never spits out any local settings. But by using the "echo 'here'" method, I was able to trace the hanging to the return statement inside writeLocalSettings()
Does it hang in an active state, or does it halt immediately at that point and cut off output? If active, does it eventually time out? Have you checked the timeout limit in PHP? Have you checked your PHP error log? Is PHP set to log errors? Does adding these lines near the top of config/index.php help:
error_reporting( E_ALL ); ini_set( "display_errors", true );
?
Can you confirm that it hangs prior to the return? If you change it to a variable set ($x = "blah..."; echo "still alive"; return $x) does it hang before or after that point? Is it right at the end of the function or is it in the eval() of the returned text which comes a couple lines after the function is called?
-- brion vibber (brion @ pobox.com)
Interspersed reply.
Brion Vibber wrote:
It would be really helpful to get some more details of your setup; for instance, is the username that you use to access MySQL 'root-equivalent' or nearly so? Do you have GRANT OPTION privileges (ie, the ability to create new usernames) or is that the only username you're allowed to use?
First, let me thank you for replying (!!). Yes, this is the only username I am allowed to use.
If it's the only one you can use, then you shouldn't be providing a root password; you should provide the username and password for "DB username" and "DB password". Can you confirm that this doesn't work, or that you do have GRANT OPTION privileges and can create the newly named user?
Yes, I roger. Entering administrative password in the actual script, and entering no password whatsoever evokes the same 'hanging' effect.
Does it hang in an active state, or does it halt immediately at that point and cut off output? If active, does it eventually time out? Have you checked the timeout limit in PHP? Have you checked your PHP error log? Is PHP set to log errors? Does adding these lines near the top of config/index.php help:
error_reporting( E_ALL );
ini_set( "display_errors", true );
It hangs as though a page load is occuring, and stops approx 20 seconds later (timeout?). No, I haven't checked timeout limit, nor do I know where my php error log is, nor do I know if php is set to log errors.
I did insert those lines at the top of index.php, and nothing different happens.
?
Can you confirm that it hangs prior to the return? If you change it to a variable set ($x = "blah..."; echo "still alive"; return $x) does it hang before or after that point? Is it right at the end of the function or is it in the eval() of the returned text which comes a couple lines after the function is called?
If echo is put before the return, echo is visible; afterwards--invisible. Subsequently, after the function is called ($blah = function()), echo doesn't launch.
-- brion vibber (brion @ pobox.com)
Thank you^10.
-steve
Stephen Yeago napisał(a):
It hangs as though a page load is occuring, and stops approx 20 seconds later (timeout?). No, I haven't checked timeout limit, nor do I know where my php error log is, nor do I know if php is set to log errors.
I did insert those lines at the top of index.php, and nothing different happens.
Looks exactly like mine (unanswered/unresolved) problem :-( except I've got root access to db - no difference...
rgrds., Konrad
Konrad Korzeniowski wrote:
Stephen Yeago napisał(a):
It hangs as though a page load is occuring, and stops approx 20 seconds later (timeout?). No, I haven't checked timeout limit, nor do I know where my php error log is, nor do I know if php is set to log errors.
I did insert those lines at the top of index.php, and nothing different happens.
Looks exactly like mine (unanswered/unresolved) problem :-( except I've got root access to db - no difference...
Perhaps it's too obvious to even mention, but the default value in php.ini (freshly installed php) is
memory_limit = 8M
which results in the quiet death of the install script you describe. If this is the case[*], changing this line to memory_limit = 16M should help.
[*] grep httpd error log for 'PHP Fatal Error'
Hi,
what about if we don't have access to php.ini - such as on another commercial host's machine?
Mark
On Sat, 2004-06-12 at 06:41, Tomasz Sienicki wrote:
Konrad Korzeniowski wrote:
Stephen Yeago napisał(a):
It hangs as though a page load is occuring, and stops approx 20 seconds later (timeout?). No, I haven't checked timeout limit, nor do I know where my php error log is, nor do I know if php is set to log errors.
I did insert those lines at the top of index.php, and nothing different happens.
Looks exactly like mine (unanswered/unresolved) problem :-( except I've got root access to db - no difference...
Perhaps it's too obvious to even mention, but the default value in php.ini (freshly installed php) is
memory_limit = 8M
which results in the quiet death of the install script you describe. If this is the case[*], changing this line to memory_limit = 16M should help.
[*] grep httpd error log for 'PHP Fatal Error'
Mark Saward wrote:
what about if we don't have access to php.ini - such as on another commercial host's machine?
You may be able to change it at runtime with something like: ini_set( "memory_limit", "16M" );
I'm not sure if this will work, but the PHP docs list it as an option that can be changed in scripts. Depending on your server's setup you might also be able to set it from a .htaccess file.
See: http://www.php.net/configuration.changes http://www.php.net/ini_set
-- brion vibber (brion @ pobox.com)
What do you make of this error log? I am familiar with PHP but I cannot tell which of these may be producing the bad result.
I did change the ini as you suggested, however the response was the same.
-Steve
Errorlog below:
"11 Jun 2004 22:59:37","/homepages/22/d94944393/htdocs/yeago.net/wiki/includes/DefaultSettings.php: 18","(Notice) Undefined variable: wgCommandLineMode"^M "11 Jun 2004 22:59:37","/homepages/22/d94944393/htdocs/yeago.net/wiki/install-utils.inc: 5","(Notice) ob_end_flush(): failed to delete and flush buffer. No buffer to delete or flush."^M "11 Jun 2004 22:59:37","/homepages/22/d94944393/htdocs/yeago.net/wiki/config/index.php: 691","(Notice) Undefined property: DBmysql4"^M "11 Jun 2004 22:59:38","/homepages/22/d94944393/htdocs/yeago.net/wiki/includes/Database.php: 101","(Warning) mysql_connect(): Access denied for user: 'root@infong223.kundenserver.de' (Using password: NO)"^M "11 Jun 2004 22:59:38","/homepages/22/d94944393/htdocs/yeago.net/wiki/config/index.php: 321","(Warning) mysql_get_server_info(): supplied argument is not a valid MySQL-Link resource"
Brion Vibber wrote:
Mark Saward wrote:
what about if we don't have access to php.ini - such as on another commercial host's machine?
You may be able to change it at runtime with something like: ini_set( "memory_limit", "16M" );
I'm not sure if this will work, but the PHP docs list it as an option that can be changed in scripts. Depending on your server's setup you might also be able to set it from a .htaccess file.
See: http://www.php.net/configuration.changes http://www.php.net/ini_set
Doubtful here...
from check_info.php....
memory_limit 40M 40M
Perhaps it's too obvious to even mention, but the default value in php.ini (freshly installed php) is
memory_limit = 8M
which results in the quiet death of the install script you describe. If this is the case[*], changing this line to memory_limit = 16M should help.
[*] grep httpd error log for 'PHP Fatal Error'
Tomasz Sienicki napisał(a):
Perhaps it's too obvious to even mention, but the default value in php.ini (freshly installed php) is
memory_limit = 8M
which results in the quiet death of the install script you describe. If this is the case[*], changing this line to memory_limit = 16M should help.
This worked for me! THX!
rgrds., Konrad
mediawiki-l@lists.wikimedia.org