php/mysql errors??

[till]

Originally Posted by palkat

so what do you think is causing this type of problem with my server???

The problem is that ISPConfig is unable to connect to your mySQL database.

Is mySQL runing?
Have you updated mysql or the mysql client libraries?

[palkat]

I have not updated anything sense the build until 5 days ago after all this started. and then the only thing i updates was done via the apt-get update command you mentioned on another thread for system updates.

but again this happened before i did those updates.

As for if mysql was running when ispconfig and the websites could not connect to mysql i failed to do a netstat -tap next time i will but waiting for this to happen is just frustrating and is ticking off customers.

* don't know if this has anything to do with it all but i had a netgear 624 wireless router setup on my network as a WAP only not router and that unit cause random issues with even WIRED pcs on the network...yesterday the first problem of the FTP stoping i disconnected the netgear router from the network and am leaving it off because not only did the ftp server stop running on the linux server but i could not also surf to a web page on the linux server. once i disconnected the netgear 624 from the network and did a ispconfig restart i could surf on the linux server to web sites and the ftp server came back on...it wasnt till hours later that ispconfig could not talk to mysql...so i wonder if just MAYBE it was all (even delayed) part of a crash caused by that netgear router i took off and (and am LEAVING OFF) the network. guess time will tell on that also...just wanted to throw that out there as that netgear router has caused me all kinds of trouble*

[falko]

Originally Posted by palkat

* don't know if this has anything to do with it all but i had a netgear 624 wireless router setup on my network as a WAP only not router and that unit cause random issues with even WIRED pcs on the network...yesterday the first problem of the FTP stoping i disconnected the netgear router from the network and am leaving it off because not only did the ftp server stop running on the linux server but i could not also surf to a web page on the linux server. once i disconnected the netgear 624 from the network and did a ispconfig restart i could surf on the linux server to web sites and the ftp server came back on...it wasnt till hours later that ispconfig could not talk to mysql...so i wonder if just MAYBE it was all (even delayed) part of a crash caused by that netgear router i took off and (and am LEAVING OFF) the network. guess time will tell on that also...just wanted to throw that out there as that netgear router has caused me all kinds of trouble*

This has nothing to do with your problem. This WAP device might prevent you from accessing the Linux box, but it doesn't stop services on your Linux system (unless the WAP device knows a backdoor to your Linux system ).

[palkat]

thanks Falko and Till, i figured that about the WAP.

Is there anything i can do or check in the meantime to find out why the mysql did what it has been doing at random??? I would just like to try everything possible so i don't have to wait every few days for this problem to happen.

and in the event when my mysql problem happens again what should i do at the time to get info to help you help me???

thanks!

[falko]

Have a look at your log files. Usually they contain some hints why this or that happened.
Maybe you should also scan your system for rootkits: http://www.howtoforge.com/faq/1_38_en.html

[palkat]

thanks falko,

i didn't see anything really in the log file that hinted at sql error to me, but im so new at all this...

I did do chkrootkit and rkhunter neither one found a single thing. so back to wait and see i guess.

** is there a way to do a complete system virus scan with suse9.3?

[falko]

Originally Posted by palkat

** is there a way to do a complete system virus scan with suse9.3?

Have a look at ClamAV: www.clamav.net

[palkat]

Tonight just a minute ago when i was on a remote machine and went to login to ispconfig it locked the server and i was just on a website that is on the same server just before going into ispconfig. so had to reboot the server because the whole server was physically locked. This kinda seems like a viral only because this server was built 2 months ago and ran nonstop till about 2 weeks ago now.

I have spent a while on clamav.net and can not get the gui frontends to install on my suse9.3 for one reason or another.

I have finally got it running a CLAMSCAN -r / on the whole system drive...will see about the results.. if no viruses are found im really stumpped as to what can be causing these issues and why now when it all ran for 6 weeks perfectly.

[falko]

Originally Posted by palkat

Tonight just a minute ago when i was on a remote machine and went to login to ispconfig it locked the server and i was just on a website that is on the same server just before going into ispconfig. so had to reboot the server because the whole server was physically locked. This kinda seems like a viral only because this server was built 2 months ago and ran nonstop till about 2 weeks ago now.

Did you change something under Management -> Server -> Settings (maybe added a new IP address)?
What's the value of $go_info["server"]["network_config"] in /home/admispconfig/ispconfig/lib/config.inc.php?

[palkat]

Falko,

No you question on if i changed anything there no but will double check.

I just saw my clamav scan results:

----------- SCAN SUMMARY -----------
Known viruses: 47129
Engine version: 0.88
Scanned directories: 17723
Scanned files: 156215
Infected files: 9
Data scanned: 12258.74 MB
Time: 6628.330 sec (110 m 28 s)

so i feel better knowning maybe part of the problem is viral. Dumb question.. based on my results i pasted how do i know what CLAMAV did to those 9 infected files, did it repair or delete them??