totalufo

Well-Known Member
Jan 17, 2002
160
0
316
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

Well-Known Member
Aug 13, 2001
835
0
316
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

Well-Known Member
Jan 17, 2002
160
0
316
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

Well-Known Member
Aug 13, 2001
835
0
316
I meant /var/lib/mysql

come on and kick me....
 

totalufo

Well-Known Member
Jan 17, 2002
160
0
316
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/
root@localhost [/var/lib/mysql]#
 

feanor

Well-Known Member
Aug 13, 2001
835
0
316
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

Well-Known Member
Jan 17, 2002
160
0
316
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.
 
B

bdraco

Guest
[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

Well-Known Member
Jan 17, 2002
160
0
316
I copied and pasted that in and got this message

chmod: invalid mode string: `mysql:mysql'

What am I missing?
 

feanor

Well-Known Member
Aug 13, 2001
835
0
316
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

Well-Known Member
Jan 17, 2002
160
0
316
I get this message now

chmod: invalid mode string: `mysql.mysql'

what next?

Thanks in advance
 

awsol

Well-Known Member
Feb 8, 2002
578
0
316
Boston MA
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

Well-Known Member
Jan 17, 2002
160
0
316
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.
 
B

bdraco

Guest
[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

Well-Known Member
Jan 17, 2002
160
0
316
Still down. Did I mentioned that all of these accounts were transfered over from another server?
 

feanor

Well-Known Member
Aug 13, 2001
835
0
316
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

Well-Known Member
Jan 17, 2002
160
0
316
This is my clients server actually. I'm not sure what he did. I'm not sure which version of MySQL this is.