Topic: webmail error after update mysql4.0.21

[adireks]

I update MySql4.0.21 by script MySql-4.0.21.sh

Code: [Select]


Downloading files...

--15:17:49--  http://mysql.zawodny.com/Downloads/MySQL-4.0/MySQL-shared-compat-4.0.20-0.i386.rpm
           => MySQL-shared-compat-4.0.20-0.i386.rpm'
Resolving mysql.zawodny.com... done.
Connecting to mysql.zawodny.com[216.200.21.249]:80... connected.
HTTP request sent, awaiting response... 404 Not Found
15:17:49 ERROR 404: Not Found.

--15:17:49--  http://mysql.zawodny.com/Downloads/MySQL-4.0/MySQL-server-4.0.21-0.i386.rpm
           => MySQL-server-4.0.21-0.i386.rpm'
Resolving mysql.zawodny.com... done.
Connecting to mysql.zawodny.com[216.200.21.249]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 10,631,124 [application/x-redhat-package-manager]

100%[====================================>] 10,631,124     9.81K/s    ETA 00:00

15:35:28 (9.81 KB/s) - MySQL-server-4.0.21-0.i386.rpm' saved [10631124/10631124]

--15:35:28--  http://mysql.zawodny.com/Downloads/MySQL-4.0/MySQL-client-4.0.21-0.i386.rpm
           => MySQL-client-4.0.21-0.i386.rpm'
Resolving mysql.zawodny.com... done.
Connecting to mysql.zawodny.com[216.200.21.249]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2,723,455 [application/x-redhat-package-manager]

100%[====================================>] 2,723,455      9.45K/s    ETA 00:00

15:40:10 (9.45 KB/s) - MySQL-client-4.0.21-0.i386.rpm' saved [2723455/2723455]

--15:40:10--  http://mysql.zawodny.com/Downloads/MySQL-4.0/MySQL-devel-4.0.21-0.i386.rpm
           => MySQL-devel-4.0.21-0.i386.rpm'
Resolving mysql.zawodny.com... done.
Connecting to mysql.zawodny.com[216.200.21.249]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1,029,155 [application/x-redhat-package-manager]

100%[====================================>] 1,029,155     10.00K/s    ETA 00:00

15:41:51 (10.00 KB/s) - MySQL-devel-4.0.21-0.i386.rpm' saved [1029155/1029155]

Stopping MySQL:                                            [   OK   ]
Upgrading from mysql 3......
warning: /etc/my.cnf saved as /etc/my.cnf.rpmsave
Preparing...                ########################################### [100%]
   1:MySQL-client           ########################################### [ 33%]
   2:MySQL-devel            ########################################### [ 66%]
   3:MySQL-server           ########################################### [100%]
Installing all prepared tables
041205 15:42:09 Warning: Asked for 196608 thread stack, but got 126976
041205 15:42:09 /usr/sbin/mysqld: Shutdown Complete


PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h mail password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

Killing mysqld with pid 3914
Wait for mysqld to exit. done
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func tables to MySQL 3.22.14 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23

If you get 'Access denied' errors, you should run this script again
and give the MySQL root user password as an argument!
Converting all privilege tables to MyISAM format
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name'. You can safely ignore these!
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Adding columns needed by GRANT .. REQUIRE (openssl)
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Creating the new table and column privilege tables
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any Unknown column errors from this
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Fixing the func table
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Adding new fields used by MySQL 4.0.2 to the privilege tables
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Done.....
[root@mail root]# mysql --version
mysql  Ver 12.22 Distrib 4.0.21, for pc-linux (i686)
[root@mail root]# php -v
4.1.2

after i runnig webmail it not work

Code: [Select]


A fatal error has occurred:

DB Error: extension not found

[line 108 of /home/httpd/html/horde/lib/Prefs/sql.php]

Details have been logged for the administrator.


help me

[kruhm]

I think this has alread been answered somewhere.

Here, try this:

solution
type following exactly at root prompt:
/sbin/e-smith/config setprop horde DbPassword horde
/sbin/e-smith/signal-event post-upgrade
/sbin/e-smith/signal-event reboot

thanxs,
dak

[stefan24]

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I already asked the author of the script ergozd (sp?) to add a "sleep 10" before calling the fix_priv_tables statement.

This call is too fast right after starting the mysql daemon.

Try to start the part of the script beginning with
/usr/bin/mysql_fix_privilege_tables once again.

[ergozd]

Hi Stefan!

I already asked the author of the script ergozd (sp?) to add a "sleep 10" before calling the fix_priv_tables statement.

I've modified the script the 29th of November and uploaded to contribs-area.

Best rgds, Ergin