Mailing List Archive

Config install script hanging (Wits End)
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
Re: Config install script hanging (Wits End) [ In reply to ]
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)
Re: Config install script hanging (Wits End) [ In reply to ]
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
Re: Config install script hanging (Wits End) [ In reply to ]
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
Re: Config install script hanging (Wits End) [ In reply to ]
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'

--
tsca * Tomasz Sienicki
Re: Re: Config install script hanging (Wits End) [ In reply to ]
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'
Re: Re: Config install script hanging (Wits End) [ In reply to ]
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)
Re: Re: Config install script hanging (Wits End) [ In reply to ]
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
>
Re: Re: Config install script hanging (Wits End) [ In reply to ]
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'
>
>
>
Re: Re: Config install script hanging (Wits End) [ In reply to ]
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