FUDforum: How To » Why is this error happening?

Home » FUDforum » How To » Why is this error happening?

Show: Today's Messages :: Polls :: Message Navigator

Why is this error happening? [message #19964]

Mon, 20 September 2004 18:19

WilliamBurns

Messages: 123
Registered: March 2004
Location: San Jose, CA

Karma: 0

Senior Member

My website hung up for almost 24 hours (over a weekend) because a variable called Maxclients reached the maximum allowable level. The logs showed the following issue occurring at about the same time (I am not saying that this error is the culprit... there were several errors in the error log.)

[Sun Sep 19 18:34:51 2004] [error] [client 65.48.116.173] File does not exist: /usr/local/etc/httpd/htdocs/favicon.ico
[Sun Sep 19 18:38:13 2004] [error] PHP Warning: mysql_connect(): Lost connection to MySQL server during query in /usr/local/etc/httpd/htdocs/wforum/index.php on line 61
[Sun Sep 19 18:38:13 2004] [error] PHP Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /usr/local/etc/httpd/htdocs/wforum/index.php on line 61
[Sun Sep 19 18:38:13 2004] [error] PHP Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /usr/local/etc/httpd/htdocs/wforum/index.php on line 61
[Sun Sep 19 18:38:13 2004] [error] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:wjb(at)rpinet(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in /usr/local/etc/httpd/htdocs/wforum/index.php on line 49

My sql error log show things like:
[Sun Sep 19 8:29:55 GMT 2004] KC91c3IvbG9jYWwvZXRjL2h0dHBkL2h0ZG9jcy93Zm9ydW0vaW5kZXgucGhwOjYxPGJyIC8+Cik gOiA8YnIgLz4KUXVlcnk6IEluaXRpYXRpbmcgbXlzcWxfY29ubmVjdDxiciAvPgpTZXJ2ZXIgVm Vyc2lvbjogVW5rbm93bjxiciAvPgo=
[Sun Sep 19 9:46:57 GMT 2004] KC91c3IvbG9jYWwvZXRjL2h0dHBkL2h0ZG9jcy93Zm9ydW0vaW5kZXgucGhwOjYxPGJyIC8+Cik gOiA8YnIgLz4KUXVlcnk6IEluaXRpYXRpbmcgbXlzcWxfY29ubmVjdDxiciAvPgpTZXJ2ZXIgVm Vyc2lvbjogVW5rbm93bjxiciAvPgo=
[Sun Sep 19 10:14:03 GMT 2004] KC91c3IvbG9jYWwvZXRjL2h0dHBkL2h0ZG9jcy93Zm9ydW0vaW5kZXgucGhwOjYxPGJyIC8+Cik gOiA8YnIgLz4KUXVlcnk6IEluaXRpYXRpbmcgbXlzcWxfY29ubmVjdDxiciAvPgpTZXJ2ZXIgVm Vyc2lvbjogVW5rbm93bjxiciAvPgo=
[
.................
which makes little sense to me.
Is this sort of thing a normal occurrance? How should I proceed to figure out what is going on?

Report message to a moderator

Re: Why is this error happening? [message #19970 is a reply to message #19964]

Mon, 20 September 2004 20:12

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

The forum could not connect to MySQL, the culprit was the mysql_connect() function that failed. It is possible that at the time MySQL server was down or was @ maximum allowed connections and was rejecting further connections.

FUDforum Core Developer

Report message to a moderator

Re: Why is this error happening? [message #19993 is a reply to message #19970]

Mon, 20 September 2004 21:52

WilliamBurns

Messages: 123
Registered: March 2004
Location: San Jose, CA

Karma: 0

Senior Member

Along the same lines, the following set or series of errors seems to be running wild. Am I doing something wrong? I had made a change in order to put a SSI text (site navigation) file alongside the forum. Now as I look into the error log, it appears to need some additional information.

[Mon Sep 20 20:35:59 2004] [error] PHP Warning: readfile(http://www.rpinet.com/wforum/pre.txt): failed to open stream: HTTP request failed! h?\xbf\xbfe\x8a\x14( in /usr/local/etc/httpd/htdocs/wforum/theme/default/index.php on line 392

[Mon Sep 20 20:35:59 2004] [error] PHP Warning: readfile(http://www.rpinet.com/wforum/pre.txt): failed to open stream: HTTP request failed! ttpd/htdocs/wforum in /usr/local/etc/httpd/htdocs/wforum/theme/default/help_index.php on line 95

[Mon Sep 20 20:36:00 2004] [error] PHP Warning: readfile(http://www.rpinet.com/wforum/pre.txt): failed to open stream: HTTP request failed! \x0e in /usr/local/etc/httpd/htdocs/wforum/theme/default/login.php on line 667

[Mon Sep 20 20:36:02 2004] [error] PHP Warning: readfile(http://www.rpinet.com/wforum/pre.txt): failed to open stream: HTTP request failed! \x18 in /usr/local/etc/httpd/htdocs/wforum/theme/default/mnav.php on line 551

[Mon Sep 20 20:36:02 2004] [error] PHP Warning: readfile(http://www.rpinet.com/wforum/pre.txt): failed to open stream: HTTP request failed! the terms of the GNU General Public License as published by the\n* Free Software Foundation; either version 2 of the License, or in /usr/local/etc/httpd/htdocs/wforum/theme/default/reset.php on line 560

[Mon Sep 20 20:36:03 2004] [error] PHP Warning: readfile(http://www.rpinet.com/wforum/pre.txt): failed to open stream: HTTP request failed! ttpd/htdocs/wforum in /usr/local/etc/httpd/htdocs/wforum/theme/default/help_index.php on line 95

[Mon Sep 20 20:37:03 2004] [error] PHP Warning: readfile(http://www.rpinet.com/wforum/pre.txt): failed to open stream: HTTP request failed! \x18D\x12\b\xa1i7(\xb4hb(\x0c in /usr/local/etc/httpd/htdocs/wforum/theme/default/msg.php on line 1235

[Mon Sep 20 20:37:58 2004] [error] PHP Warning: readfile(http://www.rpinet.com/wforum/pre.txt): failed to open stream: HTTP request failed! ttpd/htdocs/wforum in /usr/local/etc/httpd/htdocs/wforum/theme/default/help_index.php on line 95

etc....

Report message to a moderator

Re: Why is this error happening? [message #19996 is a reply to message #19993]

Mon, 20 September 2004 22:16

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

What you are seeing are actually PHP errors inside PHP function readfile, this is not a forum bug.

FUDforum Core Developer

Report message to a moderator

Re: Why is this error happening? [message #20039 is a reply to message #19996]

Wed, 22 September 2004 22:52

WilliamBurns

Messages: 123
Registered: March 2004
Location: San Jose, CA

Karma: 0

Senior Member

The hint was given that it (the PHP Warning) may be a permissions issue. I changed the forum folder from 755 to 775, and, perhaps coincidentally, the error seems to have stopped happening. Question: Am I ok to leave the forum folder at 775?

Report message to a moderator

Re: Why is this error happening? [message #20052 is a reply to message #20039]

Thu, 23 September 2004 18:32

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Porbably, what folder are we talking about.

FUDforum Core Developer

Report message to a moderator

Re: Why is this error happening? [message #20069 is a reply to message #20052]

Fri, 24 September 2004 00:51

WilliamBurns

Messages: 123
Registered: March 2004
Location: San Jose, CA

Karma: 0

Senior Member

It is the main forum folder, the one that contains index.php. But I may have answered my own question in that I left it at 775 overnight, and I still got a slew of readfile messages the next morning. Now I am wondering if it can be related to my traffic limit of ten processes.

[Updated on: Fri, 24 September 2004 00:54]

Report message to a moderator

Re: Why is this error happening? [message #20080 is a reply to message #20069]

Fri, 24 September 2004 14:22

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

that is a very likely reason, if you are requesting files from a web server which is limited to just 10 processes you can easily reach the limit of apache processes.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	user info sometimes doesn't work
Next Topic:	fudforum into phpgroupware: coder wanted

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 18:50:55 GMT 2024

Total time taken to generate the page: 0.02389 seconds