Real time stats MySql error?

New Member Joined: Aug 31, 2003 Posts: 7

I get the following error in the block window when I try to use that very nifty Real time stat.
The reason behind the error may be the very very simple one that it is not compatible with Nuke 6.7 which I use. If so, sorry. But if anybody has made it run under 6.7, please help me get rid of this:

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/heyde/public_html/modules/realtime-stats/index.php on line 46

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/heyde/public_html/modules/realtime-stats/index.php on line 46

Warning: MySQL: A link to the server could not be established in /home/heyde/public_html/modules/realtime-stats/index.php on line 46

Warning: Cannot add header information - headers already sent by (output started at /home/heyde/public_html/modules/realtime-stats/index.php:46) in /home/heyde/public_html/modules/realtime-stats/index.php on line 48
Registered
Teacher(Site-Admin)

Last Forum Post
Anonymous
2003-08-30 16:30:31

(60 sec. refresh)

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Something else is happening because it is release independent. That is a connection error not a script error, per se. the headers message means you need to activate output buffering. If you host it you need to adjust your php.ini setting for output_buffering to

output_buffering = On

If someone else hosts it then you need to add this line to your .htaccess file and put the .htaccess file in the root web directory

PHP_FLAG output_buffering On

Posted: Sun Aug 31, 2003 11:35 am

Thanks - I'd be so sad if it just wasn't 6.7 compatible.

Now, I only got all this php-nuke, phpMyAdmin, etc. sorted the other day, so just to make sure I got it right:
My employer is running the servers that I have been given a space on for my website. All I did was install php-nuke.
So, I have to talk to my local IT people about the output_buffering, right?

Posted: Sun Aug 31, 2003 11:39 am

Not necessarily. They need to turn output_buffering on, but you can override it with a .htaccess file. Use a text editor and create an empty file and name it .htaccess . If you just use notepad or wordpad windows will insist on adding a .txt to it. Don't woory about that right now. Add this line to the .htaccess file
PHP_FLAG output_buffering On

Then ftp that to the same directory that your nuke config.php file is located. Then, rename it on your server to .htaccess. That should take care of the headers message.

Posted: Sun Aug 31, 2003 11:53 am

Oops!
Did that - and now I have an 'internal server error' and can't access anything at my site.
Any ideas - before the IT people track me down?

Posted: Sun Aug 31, 2003 11:55 am

They don't allow you to override. Just delete your .htaccess file.

Posted: Sun Aug 31, 2003 1:14 pm

I am afraid it's disappeared in my directory. It disappeared the moment I changed its name after I ULed via FTP. Hmmm. Isn't that odd, or is it my FTP settings?
Ah well, at least I'll have something to keep me busy tomorrow at work! Confused

Posted: Sun Aug 31, 2003 1:34 pm

Your ftp client doesn't display it by default. Can you either telnet of ssh in? If so, it is there. yYou can then delete it.

Posted: Sun Aug 31, 2003 1:49 pm

Maybe.
Never tried that. I'll have a go - and be back with news.

Posted: Mon Sep 01, 2003 10:56 am

Okay, a day passed by.
I could not access the file, nothing worked. So the IT people had a laugh and deleted it, and the site was back on.
They say - until further notice - I will just have to live with that error. they don't have the time to look into otherwise okay servers, ini files, etc.
d***!

Posted: Mon Sep 01, 2003 11:06 am

Well, w/o output_buffering on in the php.ini file, Nuke will not function correctly. It's a 2 second change and restart the web server.

Posted: Mon Sep 01, 2003 1:53 pm

I think they are not so much concerned with the time it'll take to make a change, but security. Will output buffering ON affect anything else on a server?

Posted: Mon Sep 01, 2003 2:21 pm

All it does is allow you to assemble your browser output prior to sending it to the browser. It enables you to send headers out of order. No security issue at all. It's a processing issue.