Chris Musty's picture

Hi all,

Having some strange issues with networking and cannot get any info from logs.

I might turn up the log level to see what happens but basically mysql appliance runs fine 90% of the time and then every now and then is unreachable through any port tested except 22 (Putty) and 5900 (VNC Console) (tested 80, 3306, 443). If I restart the network ie /etc/init.d/networking restart it all comes good!

My appliance is on proxmox and behind a firewall router but they do not seem to be an issue (as a simple reset of the network fixes the issue).

Any hints? its starting to give me the %$#@!

This database was restored from another machine (technically this is a migration)... stumped!

Forum: 
Chris Musty's picture

I have a feeling it was the TKLBAM restore/migration that caused the problem.

I noticed the status screen after logging in through putty said my ip address was the old address but it was working intermittantly through the new address. I manually checked the networking config files but with the exception of /etc/hosts it all seemed ok.

New install working flawlessly!

Chris Musty

Director

Specialised Technologies

Chris Musty's picture

OK as usual problem is back 18 hours later.... 

Must be something stupid like a cable or router - AGAIN!

Chris Musty

Director

Specialised Technologies

Chris Musty's picture

I have tracked down the issue but am not sure how to solve it.

It turns out that when I access phpmyadmin to modify something and forget to log out the error occurs.

Session is set for 1440 seconds (24 mins).

Is there a simple way around this ie when sessions time out they close the database properly?

Chris Musty

Director

Specialised Technologies

Add new comment