Atomicorp

Seems message has resolved itself after I did some repairs on the bayes mysql database and optimized the tables and upgraded the tables to the 5.1.48 version.

What a headache this upgrade to mysql has been..

Jun 26 19:23:23 gz X-Qmail-Scanner-2.08st: [gz.galacticzero.net127759782279020577] spamd not returning valid content - try again

Is there anything to worry about? If so, how do I fix?

Solution was simple... Since the yum upgrade mysql put all the new mysql files into /var/lib/mysql/mysql I just had to copy all the files in that dir up one level so they all live in /var/lib/mysql. Once that was done databases started working again and I can get into plesk. Good thing this server d...

Ok, someone over at the mysql forums said to change the datadir from /var/lib/mysql to /var/lib/mysql/mysql and in doing so, I was able to start mysqld however... None of my databases are getting picked up now.

Gonna try an experiment... or maybe not...

Scott or anyone, any gotcha's on removing mysql and reinstalling? would yum erase work? I'd probably need to force the removal but forgot which switch does that. This is very frustrating as I can't use any mysql program, even the plesk cp.

argh!!!

I've posted over at mysql.com to see if they might have an answer, if you're interested in what they might have to say here is the link to the thread: http://forums.mysql.com/read.php?11,373 ... msg-373216

Hopefully someone comes up with an answer other than remove and reinstall.

Aye, it lives in /var/lib/mysql/mysql and is owned by mysql and has permissions of 0660 as are the rest of the files in that dir....

This is what is so puzzling about this... Everything looks right just won't work. If I had any hair, I'd be pulling it out right about now.

Here is the tail of my yum log. Jun 19 01:31:22 Updated: glibc-common-2.5-49.el5_5.2.i386 Jun 19 01:31:45 Updated: glibc-2.5-49.el5_5.2.i686 Jun 19 01:32:12 Updated: 4:perl-5.8.8-32.el5_5.1.i386 Jun 19 01:32:14 Installed: mysqlclient15-5.0.90-1.el5.art.i386 Jun 19 01:32:17 Updated: mysql-libs-5.1.48...

Ok, this is driving me bonkers... where should host.frm reside? var/lib/mysql or var/lib/mysql/mysql? I've triple checked the permissions on files and dirs, I've used both the my.cnf.rpmnew and the one posted by Kalimari. I just can't imagine what broke when I did the upgrade to 5.1.48. So, I'm thin...

Alright, everything I've researched says it permissions, but I'm stumped as to which files are not setup correctly.

Anyone have some fresh eyes to look at this please?

ok, my fatal error is it can't find host.frm.

100621 19:29:00 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysq
l/host.frm' (errno: 13)

-rw-rw---- 1 mysql mysql 9416 May 30 17:25 host.frm

located in ./var/lib/mysql/mysql

they should be mysql:root and 0755 for the dir and mysql:mysql 0655 for the contents, yes?

As I'm thinking about it, here is the output of my.cnf, anyone see anything wrong? This was working until I upgraded. [root@gz lib]# more /etc/my.cnf [mysqld] # set-variable=local-infile=0 # variable-local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old passwo...

Here is the latest tail after I tried to start mysqld with service mysqld start. 100620 12:14:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 100620 12:14:10 [Note] Plugin 'ndbcluster' is disabled. /usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 100620...

I'll try that, had The Planet looking at this also, and one message they see is permissions on host.frm. File exists and all taht jazz. Here is what they had to say: Basically, from what was found, as a higher level technician had to assist me with this, the core issue is that MySQL is trying to ope...