Discuss September 2005

discuss@lists.centos.org

243 participants
335 discussions

Blew away MySQL
by Todd Cary 05 Sep '05

05 Sep '05

Unfortunately, I blew MySQL away by replacing the MySQL control tables with others and not making a copy of the folder. My data is backed up, so that is not a problem, but I cannot reinstall MySQL and create the mysql directory with the control tables (e.g. user, db, host). I have run "yum remove mysql" and "yum install mysql" and "yum install mysql-server" and the control files are not recreated. Any suggestions? Todd -- Ariste Software 200 D Street Ext Petaluma, CA 94952 (707) 773-4523

4 5

Re: [CentOS] OT clamav-milter
by Marko A. Jennings 05 Sep '05

05 Sep '05

On Sun, September 4, 2005 7:00 pm, Craig White said: > I OT'd this since it is supplied by dag and not centos but running on centos 3.5 > > # service clamav-milter start > Starting Clamav Milter Daemon: clamav-milter: --timeout must not be given if --external is not given > > I updated last week and didn't have any problems. I did restart the system today and for some reason cannot get clamav-milter to start > > ;-( > > Any hints - afaik - nothing changed... > > # cat /etc/sysconfig/clamav-milter > ### Simple config file for clamav-milter, you should > ### read the documentation and tweak it as you wish. > > CLAMAV_FLAGS=" > --config-file=/etc/clamd.conf > --max-children=10 > --force-scan > --quiet > --dont-log-clean > --noreject > -obl local:/var/run/clamav/clamav-milter.sock > If I remember correctly, I added --timeout=0 to CLAMAV_FLAGS in /etc/sysconfig/clamav-milter to rectify this. Marko

3 2

Raid / dual Opteron power issues
by Evan Bursey 05 Sep '05

05 Sep '05

Hi All, I've just started caring for a dual Opteron machine. It has a 3Ware 9500S-12 RAID controller, a Tyan S2882G3NR motherboard, 10 IBM 400GB disk drives, and a 650 watt power supply. It has been behaving itself quite nicely until recently. The poor behavior started when I upgraded the OS from CentOS 4.1 (32 bit) to Centos 4.1 (x86_64). When running in uniprocessor mode, the system appears to work properly. However, when running in SMP mode I get a lot of SCSI disk errors in /var/log/messages. I've upgraded the 3w_9xxx driver and firmware, but no joy (actually, I did get some joy out of recompiling the kernel. Its been several years since I last compiled a kernel and the process has changed for the better). I've been in contact with 3Ware. From the error logs I supplied to them, it looks like the issue is an insufficient power supply. Their rule of thumb is 300W for the motherboard and 35 W for each disk drive. That means that I would need (at a theoretical minimum) a 650 W power supply - which I have. I only notice the problem in SMP mode, not in uniprocessor mode. That suggests to me that (1) I have a boarderline-sufficient power supply that can support one but not two CPUs or (2) there is a problem with the combination of Opteron/3Ware 9500S-12 hardware and the x86_64 SMP kernel. I suppose there are even worse possibilities, but I'd rather not think about those right now. What do you think? Does anyone have any experience with this sort of hardware on x86_64 kernels? Does the 3w_9xxx driver work well on a x86_64 machine? Does anyone have a suggestion as to what capacity power supply I should have? Thank you, Evan

4 4

OT clamav-milter
by Craig White 05 Sep '05

05 Sep '05

I OT'd this since it is supplied by dag and not centos but running on centos 3.5 # service clamav-milter start Starting Clamav Milter Daemon: clamav-milter: --timeout must not be given if --external is not given I updated last week and didn't have any problems. I did restart the system today and for some reason cannot get clamav-milter to start ;-( Any hints - afaik - nothing changed... # cat /etc/sysconfig/clamav-milter ### Simple config file for clamav-milter, you should ### read the documentation and tweak it as you wish. CLAMAV_FLAGS=" --config-file=/etc/clamd.conf --max-children=10 --force-scan --quiet --dont-log-clean --noreject -obl local:/var/run/clamav/clamav-milter.sock " Craig

2 1

booting from a +2TB disk
by Akop Pogosian 05 Sep '05

05 Sep '05

I have been trying to install CentOS 4.1 on a new server today. The installation went fine but the system doesn't boot. It doesn't even get to the Grub screen. The system has a 3ware 9500 series controller and 12 250GB SATA disks which are configured for RAID5 with one hot spare. I searched on the web and noticed that this is a Grub (and Lilo) limitation. Is there any way around it other than setting up a smaller RAID device? -akop

8 15

Re: [CentOS] mysql
by Ed Morrison 04 Sep '05

04 Sep '05

chris hammond wrote: > You need to install mysql-server. Sounds like mysql is installed > which is the client but not the server. > Well, now that I'm totally embarressed I would like to crawl back under the rock I just came out from under. Could I be more newbie in my ignorance...... Thank you all for your help. Ed

1 0

Re: [CentOS] mysql
by Ed Morrison 04 Sep '05

04 Sep '05

chris hammond wrote: > Look in /etc/init.d and see if mysqld exists. If it does, try to > start it with > /etc/init.d/mysqld start > > Until mysqld is started, mysql will not be able to talk to it. > Hi Chris, Thanks for your help. Apparently mysqld does not exist on the system. Not sure why this is. Has anyone else run into this issue? [root@helpdesk sbin]# locate mysqld /usr/share/doc/mysql-3.23.58/mysqld_error.txt /usr/share/man/man1/mysqld.1.gz /usr/share/man/man1/mysqld_multi.1.gz /usr/share/man/man1/mysqldump.1.gz /usr/share/man/man1/safe_mysqld.1.gz /usr/bin/mysqld_multi /usr/bin/mysqldumpslow /usr/bin/mysqldump /usr/include/mysql/mysqld_error.h [root@helpdesk sbin]# /usr/bin/mysqld_multi Couldn't find the mysqld binary! Tried: /usr/libexec/mysqld Couldn't find the mysqladmin binary! Tried: /usr/bin/mysqladmin Error with an option, see mysqld_multi --help for more info! Thanks, Ed

3 2

Re: [CentOS] mysql
by chris hammond 04 Sep '05

04 Sep '05

You need to install mysql-server. Sounds like mysql is installed which is the client but not the server. Chris >>>edward.morrison(a)gmail.com 09/04/05 5:18 pm >>> chris hammond wrote: >Look in /etc/init.d and see if mysqld exists. If it does, try to >start it with >/etc/init.d/mysqld start > >Until mysqld is started, mysql will not be able to talk to it. > Hi Chris, Thanks for your help. Apparently mysqld does not exist on the system. Not sure why this is. Has anyone else run into this issue? [root@helpdesk sbin]# locate mysqld /usr/share/doc/mysql-3.23.58/mysqld_error.txt /usr/share/man/man1/mysqld.1.gz /usr/share/man/man1/mysqld_multi.1.gz /usr/share/man/man1/mysqldump.1.gz /usr/share/man/man1/safe_mysqld.1.gz /usr/bin/mysqld_multi /usr/bin/mysqldumpslow /usr/bin/mysqldump /usr/include/mysql/mysqld_error.h [root@helpdesk sbin]# /usr/bin/mysqld_multi Couldn't find the mysqld binary! Tried: /usr/libexec/mysqld Couldn't find the mysqladmin binary! Tried: /usr/bin/mysqladmin Error with an option, see mysqld_multi --help for more info! Thanks, Ed CentOS mailing list CentOS(a)centos.org http://lists.centos.org/mailman/listinfo/centos

1 0

Re: [CentOS] mysql
by chris hammond 04 Sep '05

04 Sep '05

Look in /etc/init.d and see if mysqld exists. If it does, try to start it with /etc/init.d/mysqld start Until mysqld is started, mysql will not be able to talk to it. Chris >>>edward.morrison(a)gmail.com 09/04/05 5:02 pm >>> I just installed CentOS 3.5. Included in the install was mysql. When trying to start it using: service mysqld start. The system responds with mysqld not recpognized as a service. When trying to use /usr/bin/mysql I receive this error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2). A search of the system does not reveal mysql.sock. Anyone have any ideas? Thanks for any assistance. Ed CentOS mailing list CentOS(a)centos.org http://lists.centos.org/mailman/listinfo/centos

1 0

mysql
by Ed Morrison 04 Sep '05

04 Sep '05

I just installed CentOS 3.5. Included in the install was mysql. When trying to start it using: service mysqld start. The system responds with mysqld not recpognized as a service. When trying to use /usr/bin/mysql I receive this error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2). A search of the system does not reveal mysql.sock. Anyone have any ideas? Thanks for any assistance. Ed

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Discuss September 2005