Transaction Summary

Ed Morrison wrote:

mouss wrote:

...

...

But there isn't a my.cnf file in /etc/

if you want one, you need to create it. the package installs example file that you can use.

In all my other mysql installs there has always been an /etc/my.cnf after the installation but you are correct this can be created easily enough but I think this represents a bigger problem.

...

...

Nor are there any files in: [root@ftp ~]# ls /var/lib/mysql/ mysql test [root@ftp ~]# ls /var/lib/mysql/mysql/

looks ok. at some time, you'll need to do some post-install tasks to secure the server (mainly, set a password for the root user). see mysql site or google...

The same directories on another mysql installation. These files are there by "default". It appears to me this installation is not including all the files it should

# yum install mysql mysql-server php-mysql .... # ls -a /var/lib/mysql . .. # rpm -qf /etc/my.cnf mysql-libs-5.0.54-1.el4.centos # service mysqld start Initializing MySQL database: [ OK ] Starting MySQL: [ OK ] [root@sushi lib]# ls mysql ibdata1 ib_logfile0 ib_logfile1 mysql mysql.sock test

what I don't see in your setup is mysql-libs.

[root@postman ~]# ls /var/lib/mysql ibdata1 ib_logfile0 ib_logfile1 mysql mysql.sock test

[root@postman ~]# ls /var/lib/mysql/mysql columns_priv.frm help_category.frm help_topic.frm time_zone.frm time_zone_transition.frm columns_priv.MYD help_category.MYD help_topic.MYD time_zone_leap_second.frm time_zone_transition.MYD columns_priv.MYI help_category.MYI help_topic.MYI time_zone_leap_second.MYD time_zone_transition.MYI db.frm help_keyword.frm host.frm time_zone_leap_second.MYI time_zone_transition_type.frm db.MYD help_keyword.MYD host.MYD time_zone.MYD time_zone_transition_type.MYD db.MYI help_keyword.MYI host.MYI time_zone.MYI time_zone_transition_type.MYI func.frm help_relation.frm tables_priv.frm time_zone_name.frm user.frm func.MYD help_relation.MYD tables_priv.MYD time_zone_name.MYD user.MYD func.MYI help_relation.MYI tables_priv.MYI time_zone_name.MYI user.MYI

...

...

An rpm query shows everything should be installed: [root@ftp ~]# rpm -qa mysql mysql-5.0.54-1.el4.centos [root@ftp ~]# rpm -qa mysql* mysqlclient14-4.1.22-1.el4s1.1 mysqlclient10-devel-3.23.58-9.2.c4 mysql-5.0.54-1.el4.centos mysqlclient10-3.23.58-4.RHEL4.1 mysql-server-5.0.54-1.el4.centos mysqlclient10-3.23.58-9.2.c4 mysql-libs-5.0.54-1.el4.centos

Trying to start mysql results in: [root@ftp ~]# service mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED]

Thoughts?

is selinux enabled on your system? check /var/log/messages.

No selinux is not enabled:

# This file controls the state of SELinux on the system. # SELINUX= can take one of these three values: # enforcing - SELinux security policy is enforced. # permissive - SELinux prints warnings instead of enforcing. # disabled - SELinux is fully disabled. SELINUX=disabled # SELINUXTYPE= type of policy in use. Possible values are: # targeted - Only targeted network daemons are protected. # strict - Full SELinux protection. SELINUXTYPE=targeted

---

CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

Ed Morrison wrote:

mouss wrote:

...

# yum install mysql mysql-server php-mysql .... # ls -a /var/lib/mysql . .. # rpm -qf /etc/my.cnf mysql-libs-5.0.54-1.el4.centos # service mysqld start Initializing MySQL database: [ OK ] Starting MySQL: [ OK ] [root@sushi lib]# ls mysql ibdata1 ib_logfile0 ib_logfile1 mysql mysql.sock test

what I don't see in your setup is mysql-libs.

Hi Mouss. It is there:

[root@ftp ~]# rpm -qa mysql-libs mysql-libs-5.0.54-1.el4.centos

# rpm -q mysql-libs mysql-libs-5.0.54-1.el4.centos

so it's the same version, but:

# rpm -ql mysql-libs|grep /etc /etc/ld.so.conf.d/mysql-i386.conf /etc/my.cnf

has /etc/my.cnf. here are the contents if that could help. # cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment # these lines and adjust the connectstring as needed. #ndbcluster #ndb-connectstring="nodeid=4;host=localhost:1186"

[mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

[ndbd] # If you are running a MySQL Cluster storage daemon (ndbd) on this machine, # adjust its connection to the management daemon here. # Note: ndbd init script requires this to include nodeid! connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm] # connection string for MySQL Cluster management tool connect-string="host=localhost:1186"

Ed Morrison wrote:

mouss wrote:

...

# rpm -q mysql-libs mysql-libs-5.0.54-1.el4.centos

so it's the same version, but:

# rpm -ql mysql-libs|grep /etc /etc/ld.so.conf.d/mysql-i386.conf /etc/my.cnf

has /etc/my.cnf. here are the contents if that could help. # cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment # these lines and adjust the connectstring as needed. #ndbcluster #ndb-connectstring="nodeid=4;host=localhost:1186"

[mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

[ndbd] # If you are running a MySQL Cluster storage daemon (ndbd) on this machine, # adjust its connection to the management daemon here. # Note: ndbd init script requires this to include nodeid! connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm] # connection string for MySQL Cluster management tool connect-string="host=localhost:1186"

I created the my.cnf for my system but still nada:

[root@ftp ~]# rpm -ql mysql-libs|grep /etc /etc/ld.so.conf.d/mysql-x86_64.conf /etc/my.cnf

[root@ftp ~]# vi /etc/my.cnf

[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). # old_passwords=1

[client] socket=/tmp/mysql.sock

[mysql.server] user=mysql basedir=/var/lib

[mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

[root@ftp ~]# service mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED]

Logs are less than helpfull: Feb 14 14:26:54 ftp mysqld: Starting MySQL: failed

anything in /var/log/mysqld.log?

This is interesting:

Locate shows this:

[root@ftp ~]# locate mysql | less <snip> /var/lib/mysql /var/lib/mysql/ib_logfile0 /var/lib/mysql/ibdata1 /var/lib/mysql/vpopmail /var/lib/mysql/vpopmail/db.opt /var/lib/mysql/ib_logfile1 /var/lib/mysql/mysql /var/lib/mysql/mysql/user.frm /var/lib/mysql/mysql/help_relation.frm /var/lib/mysql/mysql/time_zone_leap_second.MYD /var/lib/mysql/mysql/tables_priv.MYD /var/lib/mysql/mysql/help_relation.MYI /var/lib/mysql/mysql/db.frm /var/lib/mysql/mysql/columns_priv.MYD /var/lib/mysql/mysql/time_zone_transition.frm /var/lib/mysql/mysql/func.frm /var/lib/mysql/mysql/time_zone_name.MYD /var/lib/mysql/mysql/help_keyword.MYI /var/lib/mysql/mysql/db.MYD /var/lib/mysql/mysql/help_relation.MYD /var/lib/mysql/mysql/columns_priv.frm /var/lib/mysql/mysql/time_zone_leap_second.frm /var/lib/mysql/mysql/time_zone_transition_type.MYI /var/lib/mysql/mysql/help_category.frm /var/lib/mysql/mysql/time_zone.MYI /var/lib/mysql/mysql/time_zone_transition.MYD /var/lib/mysql/mysql/time_zone.MYD /var/lib/mysql/mysql/time_zone_transition.MYI /var/lib/mysql/mysql/help_topic.MYD /var/lib/mysql/mysql/host.frm /var/lib/mysql/mysql/help_topic.frm /var/lib/mysql/mysql/time_zone_transition_type.frm /var/lib/mysql/mysql/help_category.MYI /var/lib/mysql/mysql/time_zone_name.frm /var/lib/mysql/mysql/host.MYD /var/lib/mysql/mysql/host.MYI /var/lib/mysql/mysql/user.MYD /var/lib/mysql/mysql/func.MYI /var/lib/mysql/mysql/columns_priv.MYI /var/lib/mysql/mysql/tables_priv.MYI /var/lib/mysql/mysql/func.MYD /var/lib/mysql/mysql/user.MYI /var/lib/mysql/mysql/help_category.MYD /var/lib/mysql/mysql/help_keyword.MYD /var/lib/mysql/mysql/time_zone_name.MYI /var/lib/mysql/mysql/help_keyword.frm /var/lib/mysql/mysql/tables_priv.frm /var/lib/mysql/mysql/time_zone.frm /var/lib/mysql/mysql/db.MYI /var/lib/mysql/mysql/help_topic.MYI /var/lib/mysql/mysql/time_zone_transition_type.MYD /var/lib/mysql/mysql/time_zone_leap_second.MYI /var/lib/mysql/test /var/www/cgi-bin/extlib/Class/PObject/Driver/mysql.pm /var/run/mysqld

But listing the directories will not show the same files:

[root@ftp ~]# ls -al /var/lib/mysql/mysql total 8 drwx------ 2 mysql mysql 4096 Feb 14 11:44 . drwxr-xr-x 4 mysql mysql 4096 Dec 24 13:13 .. [root@ftp ~]# ls -al /var/lib/mysql/ total 20 drwxr-xr-x 4 mysql mysql 4096 Dec 24 13:13 . drwxr-xr-x 27 root root 4096 Feb 14 11:44 .. drwx------ 2 mysql mysql 4096 Feb 14 11:44 mysql drwx------ 2 mysql mysql 4096 Feb 14 11:44 test

On Thu, Feb 14, 2008 at 6:59 PM, Michael A. Peters mpeters@mac.com wrote:

Ed Morrison wrote:

...

This is interesting:

Locate shows this:

[root@ftp ~]# locate mysql | less

<snip>

...

But listing the directories will not show the same files:

[root@ftp ~]# ls -al /var/lib/mysql/mysql total 8 drwx------ 2 mysql mysql 4096 Feb 14 11:44 . drwxr-xr-x 4 mysql mysql 4096 Dec 24 13:13 .. [root@ftp ~]# ls -al /var/lib/mysql/ total 20 drwxr-xr-x 4 mysql mysql 4096 Dec 24 13:13 . drwxr-xr-x 27 root root 4096 Feb 14 11:44 .. drwx------ 2 mysql mysql 4096 Feb 14 11:44 mysql drwx------ 2 mysql mysql 4096 Feb 14 11:44 test

reboot and force fsck touch /forcefsck && shutdown -r now

The only time I have ever experienced files not being where they are suppose to be after a fresh install of a package is when the hard drive was going south.

Uhh... locate is not exactly real time. Depends on updatedb which is daily by cron if at all. Though it will warn if the database is over 8 days old...

When I try to add a new printer in the "configure - KDE control module" it throw the following error: Unable ro create printer. Error message received from manager: client-error-bad request

______________________________________________ LLama Gratis a cualquier PC del Mundo. Llamadas a fijos y móviles desde 1 céntimo por minuto. http://es.voice.yahoo.com

on 2/14/2008 7:26 PM neptuno spake the following:

When i try to add a printer using GUI configuration it throw the following error: Unable to create printer. Error message receibed from manager: client-error-bad-request

please anybody can help me?

regards Roilan

When I try to read list traffic, some new user always seems to hijack message threads. My new policy is to whine incessantly about it. It probably won't help, but I get to vent.

on 2/15/2008 10:41 AM Anne Wilson spake the following:

On Friday 15 February 2008 17:51:54 Scott Silva wrote:

...

on 2/14/2008 7:26 PM neptuno spake the following:

...

When i try to add a printer using GUI configuration it throw the following error: Unable to create printer. Error message receibed from manager: client-error-bad-request

please anybody can help me?

regards Roilan

When I try to read list traffic, some new user always seems to hijack message threads. My new policy is to whine incessantly about it. It probably won't help, but I get to vent.

While I agree in principle, I'd point out that you are doing exactly the same.

Anne

Isn't it ironic? Bordering on moronic. Maybe I need a drink until I'm catatonic!

I'm done.... A nice weekend to all!