Koozali.org: home of the SME Server
Legacy Forums => General Discussion (Legacy) => Topic started by: Steve on January 18, 2003, 01:59:08 AM
-
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 ?
-
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.
-
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
-
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
-
I am also having the same problem after the upgrade and am unable to connect to the database remotely.
-
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
-
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
-
It does indeed fixes it. Thanks for advice Charlie,
Boris.
-
What options did you us eto install ? I am having no joy
-
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
-
Can you write a procedure please with package link ?
Thanks a Lot
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
-
Thanks Charlie
-
I can confirm that connecting externally via myoledb/vb is once again possible, however once working code is unable to actually insert data.
-
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
-
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
-
I love you all, folks!!
;-)
Thanks in advance!
Thomas
-
today i used your infos, glibc and common are at version 43
might even improve ...
ChS
-
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
-
Are the links for these updates correct? I have not been able to find these files
-
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.
-
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.
-
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
-
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