Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: william_syd on March 12, 2005, 11:02:19 AM

Title: MySQL update problem
Post by: william_syd on March 12, 2005, 11:02:19 AM

Updated MySQL to 4.0.22 following this howto - http://forums.contribs.org/index.php?topic=18597.0

Now webmail fails and I have the following messages..

Code: [Select]

Mar 12 20:56:45 teddy HORDE[3911]: [imp] DB Error: extension not found: mysql, localhost, horde, gaWxJBpy, horde, horde_prefs [on line 108 of "/home/httpd/html/horde/lib/Prefs/sql.php"]

Code: [Select]

Mar 12 20:56:25 teddy httpd: PHP Warning:  Unable to load dynamic library '/usr/lib/php4/mysql.so' - libmysqlclient.so.10: cannot open shared object file: No such file or directory in Unknown on line 0

What have I done wrong or needs to be done ?

I'm using SME Server 6.0.1-01.

Regards,
William.

Title: MySQL update problem
Post by: ergozd on March 12, 2005, 03:41:57 PM

Do you have MySQL-shared-compat RPM installed? libmysqlclient.so.10 is included in that RPM...

Code: [Select]

[root@XXXXXXX root]# rpm -q --provides MySQL-shared-compat
MySQL-shared
libmysqlclient.so.10
libmysqlclient.so.12
libmysqlclient_r.so.10
libmysqlclient_r.so.12
MySQL-shared-compat


Best rgds, Ergin

PS : You might want to try an upgrade script, there are many options
http://mirror.contribs.org/smeserver/contribs/ergozd/scripts/MySQL-4_0_22.sh
http://mirror.contribs.org/smeserver/contribs/ergozd/scripts/MySQL-4_0_23.sh
http://no.longer.valid/phpwiki/index.php/SME6.5UpdateScripts

Title: Re: MySQL update problem
Post by: CharlieBrady on March 12, 2005, 11:29:56 PM

Quote from: "william_syd"

Updated MySQL to 4.0.22 following this howto - http://forums.contribs.org/index.php?topic=18597.0

Now webmail fails ...

My advice would be if you don't use mysql for anything other than webmail - don't upgrade it. Or, in your case, downgrade it back to the version which works. Assuming that the upgrade is reversible, that is.

Title: MySQL update problem
Post by: william_syd on March 13, 2005, 05:55:49 AM

Quote from: "ergozd"

Do you have MySQL-shared-compat RPM installed? libmysqlclient.so.10 is included in that RPM...

Code: [Select]

[root@XXXXXXX root]# rpm -q --provides MySQL-shared-compat
MySQL-shared
libmysqlclient.so.10
libmysqlclient.so.12
libmysqlclient_r.so.10
libmysqlclient_r.so.12
MySQL-shared-compat


Best rgds, Ergin

PS : You might want to try an upgrade script, there are many options
http://mirror.contribs.org/smeserver/contribs/ergozd/scripts/MySQL-4_0_22.sh
http://mirror.contribs.org/smeserver/contribs/ergozd/scripts/MySQL-4_0_23.sh
http://no.longer.valid/phpwiki/index.php/SME6.5UpdateScripts

The answer must be no.

Code: [Select]


[root@teddy root]# package MySQL-shared-compat is not installed
bash: package: command not found
[root@teddy root]#


Regards,
William.

Title: Re: MySQL update problem
Post by: william_syd on March 13, 2005, 05:58:27 AM

Quote from: "CharlieBrady"

Quote from: "william_syd"

Updated MySQL to 4.0.22 following this howto - http://forums.contribs.org/index.php?topic=18597.0

Now webmail fails ...

My advice would be if you don't use mysql for anything other than webmail - don't upgrade it. Or, in your case, downgrade it back to the version which works. Assuming that the upgrade is reversible, that is.

My host for another site uses that version and I wanted the same version here on SME for compatibility with some forum mods.


Regards,
William.

Title: MySQL update problem
Post by: william_syd on March 13, 2005, 06:53:24 AM

Quote from: "ergozd"

Do you have MySQL-shared-compat RPM installed? libmysqlclient.so.10 is included in that RPM...

Code: [Select]

[root@XXXXXXX root]# rpm -q --provides MySQL-shared-compat
MySQL-shared
libmysqlclient.so.10
libmysqlclient.so.12
libmysqlclient_r.so.10
libmysqlclient_r.so.12
MySQL-shared-compat


Best rgds, Ergin

PS : You might want to try an upgrade script, there are many options
http://mirror.contribs.org/smeserver/contribs/ergozd/scripts/MySQL-4_0_22.sh
http://mirror.contribs.org/smeserver/contribs/ergozd/scripts/MySQL-4_0_23.sh
http://no.longer.valid/phpwiki/index.php/SME6.5UpdateScripts

Thank you very much.

It was a silly mistake by me.

I installed MySQL-shared-4.0.22-0.i386.rpm intead of  MySQL-shared-compat-4.0.22-0.i386.rpm .

All is well now.




regards,
William.