Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : MP3 not streaming in widget. I have an error log if it helps :)

[Beatplexity]

As you can probably tell from the thread title, im slightly a noob.

My mp3 files have stopped streaming in my widget, ive had a browse around and noticed a error log file, so i opened it up and these are the 2 messages i see a lot of.

Can anyone make any sense of it?

[29-May-2010 17:05:18] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User *********** already has more than 'max_user_connections' active connections in /home/**********/public_html/shared/php/v1/dbconnect.php on line 20

[06-Jun-2010 02:59:55] PHP Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/************/public_html/widget/popoutwidget.php on line 34

Example of the widget here - http://bit.ly/9MRfvL

as you can see when you click play its says it is buffering but it just stays at this stage and never plays.

Any help will be greatly appreciated.

Thanks

[BurakUeda]

You need to tweak your mysql settings.
Increase the number in max_user_connections directive in your my.cnf file.

[Beatplexity]

i dont appear to have a my.cnf file, i looked in home/etc/beatplexity.com/ and there was nothing there

am i looking in the correct place

[lonea]

my.cnf is usually located in /etc/

[Beatplexity]

ok so im changing settings to the entire server and not just my account within the server?

[BurakUeda]

Yes, that would be the entire server.

[Beatplexity]

ok, is there anyway to do this in WHM or something because i have no idea how to access it through putty

[BurakUeda]

putty is not that difficult.
put your ip, ssh port and connect.
enter your login details, most likely same with your WHM login

[Beatplexity]

oh logging in is fine, i can do that

but navigating to a folder and creating a file is something i have never done

[lonea]

nano /etc/my.cnf

Change the settings -> ctrl + o to save -> ctrl + x to exit

service mysql restart

[Beatplexity]

Originally Posted by lonea

nano /etc/my.cnf

Change the settings -> ctrl + o to save -> ctrl + x to exit

service mysql restart

ye you're gona have to go into more detail than that

what is nano?
how do i change the settings
what do i change the settings to?