[glux] Joomla & Mysql

gigiv gigiv2@gmail.com
Ven 29 Giu 2007 18:46:29 CEST


ciao
premesso che non ci capisco nulla di database

ho bisogno di installare su una macchina il CMS Joomla, che richede mysql
ho installato apt-get install mysql-server
ma c'e' qualcosa che non va, quando compilo la maschera dell'installazione
di  joomla sul DB mi dice sempre che ho inserito username o password errate

riporto ps, qualche test e syslog

qualche buon'anima mi da' una dritta?

grssie e buon week end

gg
--------------------------

#ps
root     32640  0.0  2.2   3536  1372 ?        S    Jun28   0:00 /bin/sh
/usr/bin/mysqld_safe
mysql      410  0.5 26.3 127536 16360 ?        Sl   00:22   5:58
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/m
ysqld/mysqld.pid --skip-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock
root       411  0.0  1.0   2632   640 ?        S    00:22   0:00 logger -p
daemon.err -t mysqld_safe -i -t mysqld



root@grop:~ # mysqlshow
mysqlshow: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
root@grop:~ # mysqltest
mysqltest: Could not open connection 'default': 2002 Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (111)
not ok

#quando riavvio mysql nel syslog trovo:

Jun 29 18:32:49 grop mysqld[1666]: 070629 18:32:49  InnoDB: Started; log
sequence number 0 43655
Jun 29 18:32:50 grop mysqld[1666]: 070629 18:32:50 [Note] /usr/sbin/mysqld:
ready for connections.
Jun 29 18:32:50 grop mysqld[1666]: Version: '5.0.24a-Debian_9ubuntu2-log'
socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Debian etch distribution
Jun 29 18:32:54 grop /etc/mysql/debian-start[1720]: Checking for crashed
MySQL tables.
Jun 29 18:32:55 grop /etc/mysql/debian-start[1728]: Upgrading MySQL tables
if necessary.
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: /usr/bin/mysqlcheck: Got
error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.
sock' (111) when trying to connect
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: This script updates all
the mysql privilege tables to be usable by
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: MySQL 4.0 and above.
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]:
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: This is needed if you
want to use the new GRANT functions,
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: CREATE AGGREGATE
FUNCTION, stored procedures, or
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: more secure passwords in
4.1
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]:
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]:
/usr/bin/mysql_fix_privilege_tables: line 190:  1756 Broken pipe
cat $sql_file
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]:       1757 Segmentation
fault      | $cmd >/dev/null 2>&1
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: Got a failure from
command:
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: cat
/usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql
--no-defaults --force --user=deb
ian-sys-maint --host=localhost --password=BStHgvGoV7TL1Gtj --database=mysql
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: Please check the above
output and try again.
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]:
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: Running the script with
the --verbose option may give you some information
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: of what went wrong.
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]:
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: If you get an 'Access
denied' error, you should run this script again and
Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: give the MySQL root user
password as an argument with the --password= option
-------------- parte successiva --------------
Un allegato HTML è stato rimosso...
URL: http://lists.linux.it/pipermail/glux/attachments/20070629/0110b8fc/attachment.htm 


Maggiori informazioni sulla lista glux