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

[Paul Isaacs]

Hi Charlie,

Thanks for that. Works fine on my box, but took a while for me to ba able to set up another test box and confirm it.

It was the last thing standing in the way of updating our production server to 5.6.

regards

Paul

[Thomas Ihlebek]

I love you all, folks!!



Thanks in advance!
Thomas

[ChS]

today i used your infos, glibc and common are at version 43

might even improve ...

ChS

[Louis Aszod]

I was tearing my hair out over this.  Thanks Charlie, for the fix.  And yes, version is now 43.

Now if I can only figure out how to set up my privileges so that the control panel that's running on another machine can access the databases.....

Thanks again.  At least I can connect!

LJA

[Matt Brown]

Are the links for these updates correct?  I have not been able to find these files

[Jehu]

Try this.
Create a directory.
wget ftp://rpmfind.net/linux/redhat/updates/7.3/en/os/i386/glibc-common-2.2.5-43.i386.rpm


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

rpm -Uvh *.rpm

That should do it.

Cheers.

[Ruben Causyn]

Hi,
i'm still having problems connecting to mysql using mysqlcc, i did the things mentioned in these posts and after a second try i got:

package glibc-2.2.5-43 is already installed
package glibc-common-2.2.5-43 is already installed

so i think it's installed properly, but still I can't connect.
anyone who knows what the problem could be?

thanks in advance.

[dave]

I have installed upgrade 3 to my SME 5.6
and glibc-2.2.5-43.i386.rpm etc. and still get this error:
Apr 22 23:18:02 seaport mysql.init: Loading 20horde.mysql_update_privs.sql into mysql succeeded
Apr 22 23:18:02 seaport mysql: ERROR
Apr 22 23:18:02 seaport mysql:  1061 at line 74: Duplicate key name 'category_category_name_idx'
Apr 22 23:18:02 seaport mysql.init: Loading 30mysql.create.horde.sql into mysql failed
Apr 22 23:18:03 seaport mysql.init: Loading 30mysql_create_tables.sql into mysql succeeded
Apr 22 23:18:03 seaport mysql.init: Loading 40mysql.create.turba.sql into mysql succeeded
Is this part of this thread problem?
I also get a error that says:
The used command is not allowed with this MySQL version

[IDar]

I've updated both glibc-common and glibc to solve an MySql connection error and naw i can't log with my user neither by ssh nor by mail...
That's the error i get:
Error del servidor. Cuenta: 'admin@gaf.ruizlizondo.com', Servidor: 'gaf.ruizlizondo.com', Protocolo: POP3, Respuesta del servidor: 'Incorrectly built binary which accesses errno, h_errno or _res directly. Needs to be fixed.', Puerto: 995, Seguridad (SSL): Sí, Error de servidor: 0x800CCC90, Número de error: 0x800CCC90
I have no mail neither from pine...

I've been looking the logs and i've seen this error in the server startup:

May 30 14:25:35 idar rc: Starting autofs: succeeded
May 30 14:25:35 idar cvm-unix: Starting cvm-unix:
May 30 14:25:35 idar cvm-unix: Incorrectly built binary which accesses errno, h_errno or _res directly. Needs to be fixed.
May 30 14:25:37 idar cvm-unix: Starting cvm-unix succeeded


Anybody knows what to do?
Thanks in advance