Topic: MySQL update problem

[william_syd]

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.

[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

[CharlieBrady]

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.

[william_syd]

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.

[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.

[william_syd]

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.