MySQL failed

[totalufo]

I'm having trouble getting MySQL to work. Here's the message I get when I try to restart MySQL


mysql status root 23318 0.3 0.2 2220 1028 ? S 17:33 0:00 /bin/sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid



mysql has failed, please contact the sysadmin.

The weird thing is, under service status, I get a green light under MySQL.

Also, when I tail the error logs, and messages, I get no errors. Any ideas?

Thanks

 

[feanor]

permissions on the directories are probably hosted

what does /usr/lib/mysql look like for user and groups? And everything within?
should be mysql.mysql or mysql.root on the top level and throughout all subdirectories/files

I would also make sure you have the latest cpanel-support mysql RPM (/scripts/sysup)

then restart mysql

 

[totalufo]

Here's what is in
/usr/lib/mysql

./ libdbug.a* libmerge.a* libmyisammrg.a* libmysqlclient.la* libmysys.a* mysqld-max.sym*
../ libheap.a* libmyisam.a* libmysqlclient.a* libmystrings.a* libnisam.a* mysqld.sym*

 

[feanor]

I meant /var/lib/mysql

come on and kick me....

 

[totalufo]

ok, Here's what is there. You should know that all of the accounts you seel below were transfered from another server.

./ coleiras_pchat1/ hostmidi_modelo/ novolar_novolar/
../ comproco_loja/ hostmidi_pchat1/ orbitec_lojavirtual/
aez_aez/ connectw_loja/ imerco_lojavirtual/ paineis_paineis/
aezcom_loja/ decorale_deco/ imerco_pchat1/ paintba_loja/
aezcom_pchat1/ deisi2_loja/ infocliq_lojavirtual/ papelari_admin/
agitoweb_cartoes/ demo_pchat3/ infocliq_pchat3/ papelari_loja/
aidiint1_loja/ demo_test/ iremar_mouse/ patio_patio/
aidiinte_loja/ diabete_loja/ jampa_loja/ pcflorip_loja/
aidirojo_loja/ dibianch_lojavirtual/ jampa_pchat1/ portofel_nuke/
aidisabo_pchat1/ digital_loja/ kama_kb/ potatus_xmb1/
aidisabo_xmb2/ digital_pchat1/ kar0919_pchat1/ premierc_pchat1/
alba_loja/ digitals_teste/ lazio_agbook1/ protec_loja/
alba_pchat1/ dvdsolut_portal/ lazio_xmb1/ prsnet_cadastro/
anime_lojavirtual/ editorar_loja/ lhpolito_politobd/ prsnet_loja/
antonioa_agbook1/ egshard_lojavirtual/ livjur_loja/ quality_loja/
antonioa_agbook2/ egshard_xmb2/ localhost.localdomain.err rangel_dbRangel/
artesana_loja/ existo_loja/ localhost.localdomain.pid riber_loja/
bembolad_loja/ existo_teste/ lojanatu_lojavirtual/ rickmarx_enquete/
bocadafo_4p/ express_loja/ louvores_pchat1/ rickmarx_sqlsql/
bocadafo_pchat1/ fuj_pchat1/ mail/ rogercom_rogercom/
brabra10_brasilplanet/ fuj_xmb1/ mapanet_busca/ rogercom_xmb1/
brabra10_xmb1/ gfw_geral/ mapanet_noticias/ rs1_loja/
bras2_finance/ gnomo_loja/ medical_loja/ rsracing_loja/
bras2_pchat1/ golemco_golem/ milanez_cdshop/ ruana_xmb1/
buckup_loja/ golemco_nuke/ milanez_visio/ sbr_/
buiasbr_agbook1/ guiaimob_guiaimob/ mjronlin_loja/ senior_loja/
buiasbr_loja/ guiaimob_pchat1/ monea_lojacrm/ sobrie_pchat1/
buiasbr_pchat2/ guilherm_lojavirtual/ monte_loja/ sobrie_pchat2/
bycodeb_loja/ hardking_loja/ movequip_lojavirtual/ softvixc_vendas/
camarabr_webos/ hardware_loja/ muzi_loja/ test/
cdsmil_portal/ hibris_webos/ mysql/ tigrenet_portal/
claudio_pchat1/ hospede_mouse/ mysql.sock= tios_agbook1/
cofscom_teste/ hospede_site/ ncviagem_loja_nc/ vavre_contatos/
[email protected] [/var/lib/mysql]#

 

[feanor]

See the main point here though, is WHICH user and group owns /var/lib/mysql ?

Do this in /var/lib
ls -la | grep mysql

What do you get?

 

[totalufo]

Here's what I get.

drwxr-xr-x 129 mysql root 4096 Mar 7 20:31 mysql/

is that 735?
What next?

By the way, Thank you so much for taking the time to help me out.

 

[bdraco]

[quote:99a66925db][i:99a66925db]Originally posted by totalufo[/i:99a66925db]

Here's what I get.

drwxr-xr-x 129 mysql root 4096 Mar 7 20:31 mysql/

is that 735?
What next?

By the way, Thank you so much for taking the time to help me out.[/quote:99a66925db]

chmod -R mysql:mysql -R /var/lib/mysql

 

[totalufo]

I copied and pasted that in and got this message

chmod: invalid mode string: `mysql:mysql'

What am I missing?

 

[feanor]

Try this instead

user period group .. i'm not sure where that colon spawned from.

then restart mysql (/etc/rc.d/init.d/mysql stop, and then start)


chown -R mysql.mysql -R /var/lib/mysql

 

[totalufo]

I get this message now

chmod: invalid mode string: `mysql.mysql'

what next?

Thanks in advance

 

[awsol]

lol just do this

chown mysql.mysql *

Make sure you do it in the right folder though. If you do it in the wrong folder you can spen endless hours fixing stuff.

 

[totalufo]

just in case. What folder should I do it in then?

 

[awsol]

/var/lib/mysql

 

[totalufo]

Thanks, unfortunatly, that did not fix it. what next? I feel like I've tried everything but I'm sure that is not the case.

 

[bdraco]

[quote:cd4667da22][i:cd4667da22]Originally posted by totalufo[/i:cd4667da22]

Thanks, unfortunatly, that did not fix it. what next? I feel like I've tried everything but I'm sure that is not the case.[/quote:cd4667da22]

chown mysql:mysql -R /var/lib/mysql
/sbin/server mysql start

 

[totalufo]

No luck. I'm trying a server reboot.

 

[totalufo]

Still down. Did I mentioned that all of these accounts were transfered over from another server?

 

[feanor]

Did you transfer the master mysql db from the previous server to? I'm assuming you took all of /var/lib/mysql (and absolutely everything within), from one server to the other.

Right?

And you have Mysql version 3.23.45 here, right?
(/scripts/sysup)

 

[totalufo]

This is my clients server actually. I'm not sure what he did. I'm not sure which version of MySQL this is.