TurnKey Linux Virtual Appliance Library

Networking issues with MySQL Appliance

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!

Chris Musty's picture

I just re-installed it and issue went away

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

ugh - its back

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

If anyone is interested

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

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)