Topic: 5.6 seems to have broken mysql

[Steve]

I had a windows vb6 myoledb app connecting to mysql on 5.5 - upgrade to 5.6 unsupported seems to have broken this. I also cant connect with mysql GUI client from the mysql site. php web apps on the localhost seem ok.

Any ideas ?

[ted]

I know its no help my myODBC doesn't seem to work with mysql in 5.6 either. I'm trying to use the open office 1.0.1 spreadsheet with a mysql database. It worked before on 5.5. I even did a fresh install of 5.6.

The server-manager is broken too. The fix in the published bug report didn't work.

[Paul Isaacs]

Agreed.

I have also tried to remotely access mySql. No joy. I have used a local console to set permissions etc. but get the message:
2013: Lost connection to MySQL server during query.

Any help/ideas would be greatly appreciated.

regards

Paul

[Paul Isaacs]

Hi,
Further investigation shows that the mysqld appears to be hanging.
I have reported this to bugs@e-smith

=====================================================================
030120 09:04:58 mysqld started
/usr/libexec/mysqld: ready for connections
Number of processes running now: 1
mysqld process hanging, pid 2067 - killed
030120 09:08:32 mysqld restarted
/usr/libexec/mysqld: ready for connections
030120 9:09:51 /usr/libexec/mysqld: Normal shutdown
030120 9:09:51 /usr/libexec/mysqld: Shutdown Complete
030120 09:09:51 mysqld ended
030120 09:12:14 mysqld started
/usr/libexec/mysqld: ready for connections
Number of processes running now: 1
mysqld process hanging, pid 1513 - killed
030120 09:29:16 mysqld restarted
/usr/libexec/mysqld: ready for connections
Number of processes running now: 1
mysqld process hanging, pid 2285 - killed
030120 09:43:07 mysqld restarted
/usr/libexec/mysqld: ready for connections
=======================
regards

Paul

[Steve]

I am also having the same problem after the upgrade and am unable to connect to the database remotely.

[Beeckmans Olivier]

I've the same trouble on a Fresh Installation, I've try on other computer and with a different lan address the problems still present !

regards Olivier

[Charlie Brady]

Paul Isaacs wrote:

> Further investigation shows that the mysqld appears to be
> hanging.

RedHat's bugzilla suggests that upgrading to RH7.3 latest glibc and glibc-common (version 2.2.5-42) will fix that problem. That seemed to do the trick for me.

Charlie

[boris]

It does indeed fixes it. Thanks for advice Charlie,
Boris.

[Steve]

What options did you us eto install ? I am having no joy

[Beeckmans Olivier]

I've made a Fresh Install. SME 5.6 unsupported developer release

English
be-latin1
more options
install Software Raid - DUAL IDE
install

Install phpmyadmin
Creation of a new user with all priviliges from anywhere

Try on 3 other Computer's, with other lan setting

MySQL unjoinable throug MyODBC-3.51 or LibMySQL

But running in local mode (PHP)

Olivier

[Beeckmans Olivier]

Can you write a procedure please with package link ?

Thanks a Lot

Beeckmans Olivier

[Beeckmans Olivier]

Solution (Thanks To Charlie Brady)

Create a directory

Download those 2 files in this directory

wget ftp://rpmfind.net/linux/redhat/updates/7.3/en/os/i386/glibc-common-2.2.5-42.i386.rpm

Size 11,186,583 bits

Wget ftp://rpmfind.net/linux/redhat/updates/7.3/en/os/i386/glibc-2.2.5-42.i386.rpm

Size 3,119,006 bits

rpm -Uvh *.rpm

After Update, MySQL is joinable without reboot or other action

Thanks and enjoy

[Steve]

Thanks Charlie

[Steve]

I can confirm that connecting externally  via myoledb/vb is once again possible, however once working code is unable to actually insert data.

[Charlie Brady]

Beeckmans Olivier wrote:

> Create a directory

Or better, don't create a directory. Just do:

R=ftp://rpmfind.net/linux/redhat/updates/7.3/en/os/i386
rpm -Uhv $R/glibc-common-2.2.5-42.i386.rpm   \
  $R/glibc-2.2.5-42.i386.rpm

> After Update, MySQL is joinable without reboot or other action
>
> Thanks and enjoy

Charlie