|
From: Dick M. <di...@li...> - 2008-04-05 20:29:52
|
Hi, Playing with 1.3.4-2008-03-10-i686 I have a little trouble with mysql. For some reason it doesn't start at boot time - i.e when run from rc3.d/ but it starts OK with /etc/init.d/mysqld. At boot time it prints "Starting MYSQL server [OK]", it initializes the data directory if needed but then stops. I see no errors in syslog or mysql.log. It starts manually no bother. Any thoughts about that? Dick |
|
From: Heiko Z. <he...@zu...> - 2008-04-06 13:07:43
|
I have the same problem and always thought it's my installation which must have something wrong. I researched it too and couldn't find anything. Maybe there's something missing which we need to start first. I'm not sure when I'll have time to look at this, so if anybody else got time and wants to attack this issue... -- Regards Heiko Zuerker http://www.devil-linux.org Quoting Dick Middleton <di...@li...>: > Hi, > > Playing with 1.3.4-2008-03-10-i686 > > I have a little trouble with mysql. For some reason it doesn't start at boot > time - i.e when run from rc3.d/ but it starts OK with /etc/init.d/mysqld. > > At boot time it prints "Starting MYSQL server [OK]", it initializes the data > directory if needed but then stops. I see no errors in syslog or > mysql.log. It > starts manually no bother. > > Any thoughts about that? > > Dick > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Register now and save $200. Hurry, offer ends at 11:59 p.m., > Monday, April 7! Use priority code J8TLD2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > Devil-linux-discuss mailing list > Dev...@li... > https://lists.sourceforge.net/lists/listinfo/devil-linux-discuss > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. |
|
From: Bruce S. <bw...@ar...> - 2008-04-06 23:30:11
|
Does the problem occur only when it has to initialize the database? Or only after the database has been initialized? Or both? - BS > Playing with 1.3.4-2008-03-10-i686 > > I have a little trouble with mysql. For some reason it doesn't start at boot > time - i.e when run from rc3.d/ but it starts OK with /etc/init.d/mysqld. > > At boot time it prints "Starting MYSQL server [OK]", it initializes the data > directory if needed but then stops. I see no errors in syslog or mysql.log. It > starts manually no bother. > > Any thoughts about that? > > Dick |
|
From: Dick M. <di...@li...> - 2008-04-07 08:10:29
|
Bruce Smith wrote: > Does the problem occur only when it has to initialize the database? > Or only after the database has been initialized? Or both? Both. Dick |
|
From: Bruce S. <bw...@ar...> - 2008-04-08 21:25:40
|
> > Does the problem occur only when it has to initialize the database? > > Or only after the database has been initialized? Or both? > > Both. This problem may be related. I'm testing this in VMware server 3i. I noticed that BIND (named) is also starting weird. This is a secondary name server, and only one zone (of many) is being xfered/loaded on boot. If I restart named after boot, then it loads all zones fine. I first stuck a 'sleep 30' in the /etc/init.d/named before the start, and that didn't help at all. Then I noticed that vmware was starting after named, so I moved vmware to start before named and syslog, and named seems to start fine on boot. (with above 'sleep 30' removed) My new start order: rc3.d/S05network rc3.d/S06firewall rc3.d/S08nut rc3.d/S08shorewall rc3.d/S08vmware rc3.d/S09syslog rc3.d/S11adsl rc3.d/S11blankscreen rc3.d/S11cron rc3.d/S11dnsmasq rc3.d/S11domino rc3.d/S11hotplug rc3.d/S11mdadm_monitor rc3.d/S11named ... Is starting vmware before syslog correct? Anything else out of order? Shall I commit these changes? - BS |
|
From: Bruce S. <bw...@ar...> - 2008-04-09 19:26:47
|
> I don't have a problem with putting it into the my.cnf. > I know you can do the addition with awk, maybe you can find the code > somewhere via google. Yeah, I can figure out how to insert the line in the file - that's not a problem. The tricky part is putting it line in the file at the correct location - also doable. What worries me is what happens if the default my.cnf file changes in a newer release ... (I guess it'll break, and we'll have to fix it :) - BS |
|
From: Dick M. <di...@li...> - 2008-04-09 19:53:07
|
Bruce Smith wrote: >> I don't have a problem with putting it into the my.cnf. > What worries me is what happens if the default my.cnf file changes in a > newer release ... (I guess it'll break, and we'll have to fix it :) Sounds like a bug in mysql which will be fixed next release. You then have the problem of how to remove your change. You can only reliably do it in the default config but that still leaves those who copy my.cfg from older systems. No choice really but a release note or README IMHO. Dick |
|
From: Heiko Z. <he...@zu...> - 2008-04-09 12:21:36
|
Actually wouldn't it make sense starting vmware before the network (or right after), since it provides some base system functionality? -- Regards Heiko Zuerker http://www.devil-linux.org Quoting Bruce Smith <bw...@ar...>: >> > Does the problem occur only when it has to initialize the database? >> > Or only after the database has been initialized? Or both? >> >> Both. > > This problem may be related. I'm testing this in VMware server 3i. > > I noticed that BIND (named) is also starting weird. This is a secondary > name server, and only one zone (of many) is being xfered/loaded on boot. > If I restart named after boot, then it loads all zones fine. > > I first stuck a 'sleep 30' in the /etc/init.d/named before the start, > and that didn't help at all. > > Then I noticed that vmware was starting after named, so I moved vmware > to start before named and syslog, and named seems to start fine on boot. > (with above 'sleep 30' removed) > > My new start order: > > rc3.d/S05network > rc3.d/S06firewall > rc3.d/S08nut > rc3.d/S08shorewall > rc3.d/S08vmware > rc3.d/S09syslog > rc3.d/S11adsl > rc3.d/S11blankscreen > rc3.d/S11cron > rc3.d/S11dnsmasq > rc3.d/S11domino > rc3.d/S11hotplug > rc3.d/S11mdadm_monitor > rc3.d/S11named > ... > > Is starting vmware before syslog correct? Anything else out of order? > Shall I commit these changes? > > - BS > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Register now and save $200. Hurry, offer ends at 11:59 p.m., > Monday, April 7! Use priority code J8TLD2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > Devil-linux-discuss mailing list > Dev...@li... > https://lists.sourceforge.net/lists/listinfo/devil-linux-discuss > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. |
|
From: Bruce S. <bw...@ar...> - 2008-04-09 12:55:50
|
> Actually wouldn't it make sense starting vmware before the network (or > right after), since it provides some base system functionality? I can do that! :-) - BS |
|
From: John J. <jo...@jo...> - 2008-04-09 13:00:19
|
Hi all, I moved the vmware script to 05? I think, sorry I don't have it in front of me, this because I got a lot of errors when the VM only had VLAN, guest tagging, enabled, and the vmware driver is needed for this functionality. The adapter "morphes" from amd32 to vmxnet when the driver is loaded, and if network is started without the vmxnet, no network cards are available. This is only a problem when using only VLAN guest tagging. Regards, John Jore ________________________________________ From: dev...@li... [dev...@li...] On Behalf Of Heiko Zuerker [he...@zu...] Sent: 09 April 2008 13:21 To: dev...@li... Subject: Re: [Devil-Linux-discuss] 1.3.4 starting mysql Actually wouldn't it make sense starting vmware before the network (or right after), since it provides some base system functionality? -- Regards Heiko Zuerker http://www.devil-linux.org Quoting Bruce Smith <bw...@ar...>: >> > Does the problem occur only when it has to initialize the database? >> > Or only after the database has been initialized? Or both? >> >> Both. > > This problem may be related. I'm testing this in VMware server 3i. > > I noticed that BIND (named) is also starting weird. This is a secondary > name server, and only one zone (of many) is being xfered/loaded on boot. > If I restart named after boot, then it loads all zones fine. > > I first stuck a 'sleep 30' in the /etc/init.d/named before the start, > and that didn't help at all. > > Then I noticed that vmware was starting after named, so I moved vmware > to start before named and syslog, and named seems to start fine on boot. > (with above 'sleep 30' removed) > > My new start order: > > rc3.d/S05network > rc3.d/S06firewall > rc3.d/S08nut > rc3.d/S08shorewall > rc3.d/S08vmware > rc3.d/S09syslog > rc3.d/S11adsl > rc3.d/S11blankscreen > rc3.d/S11cron > rc3.d/S11dnsmasq > rc3.d/S11domino > rc3.d/S11hotplug > rc3.d/S11mdadm_monitor > rc3.d/S11named > ... > > Is starting vmware before syslog correct? Anything else out of order? > Shall I commit these changes? > > - BS > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Register now and save $200. Hurry, offer ends at 11:59 p.m., > Monday, April 7! Use priority code J8TLD2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > Devil-linux-discuss mailing list > Dev...@li... > https://lists.sourceforge.net/lists/listinfo/devil-linux-discuss > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Devil-linux-discuss mailing list Dev...@li... https://lists.sourceforge.net/lists/listinfo/devil-linux-discuss |
|
From: Bruce S. <bw...@ar...> - 2008-04-09 13:03:50
|
I just committed changes to move vmware to start right before network. This seems to solve the problem I was having with 'named'. I'll take a look at mysql to see if it solves that problem too. - BS > Hi all, > I moved the vmware script to 05? I think, sorry I don't have it in > front of me, this because I got a lot of errors when the VM only had > VLAN, guest tagging, enabled, and the vmware driver is needed for this > functionality. > > The adapter "morphes" from amd32 to vmxnet when the driver is loaded, > and if network is started without the vmxnet, no network cards are > available. This is only a problem when using only VLAN guest tagging. > >> > Does the problem occur only when it has to initialize the database? > >> > Or only after the database has been initialized? Or both? > >> > >> Both. > > > > This problem may be related. I'm testing this in VMware server 3i. > > > > I noticed that BIND (named) is also starting weird. This is a secondary > > name server, and only one zone (of many) is being xfered/loaded on boot. > > If I restart named after boot, then it loads all zones fine. > > > > I first stuck a 'sleep 30' in the /etc/init.d/named before the start, > > and that didn't help at all. > > > > Then I noticed that vmware was starting after named, so I moved vmware > > to start before named and syslog, and named seems to start fine on boot. > > (with above 'sleep 30' removed) > > > > My new start order: > > > > rc3.d/S05network > > rc3.d/S06firewall > > rc3.d/S08nut > > rc3.d/S08shorewall > > rc3.d/S08vmware > > rc3.d/S09syslog > > rc3.d/S11adsl > > rc3.d/S11blankscreen > > rc3.d/S11cron > > rc3.d/S11dnsmasq > > rc3.d/S11domino > > rc3.d/S11hotplug > > rc3.d/S11mdadm_monitor > > rc3.d/S11named > > ... > > > > Is starting vmware before syslog correct? Anything else out of order? > > Shall I commit these changes? > > > > - BS |
|
From: Riaan S. <ri...@pr...> - 2008-04-09 13:08:17
|
Hi all, I need to setup a DMZ Server Firewall that I can also use to do NAT Statements on. I have web and certificate servers on the one side and workstations, mail and database servers on the other. Any suggestions? |
|
From: Bruce S. <bw...@ar...> - 2008-04-09 15:13:00
|
> I'll take a look at mysql to see if it solves that problem too. No, that didn't solve the problem, but I did figure out the cause. For some reason "--user=mysql" is not working on the command line in the init.d script during boot. /var/mysql/dns2.err: ======================================================================== 080409 10:38:44 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! 080409 10:38:44 [ERROR] Aborting ======================================================================== If I add "user = mysql" in /etc/my.cnf (under the [mysqld] section), then mysql starts fine upon boot. Very weird ... Since we are copying the my.cnf file from the mysql tmp source: cp $TMPDIR/usr/share/mysql/my-small.cnf $ETCDIR/etc/my.cnf I'm not sure the best way to add the line to the file, or IF we should add it to the file (since it overrides the config parameters). Heiko? I've also tried starting mysqld_safe with "su - mysql -c ..." in the init.d script, but I haven't gotten that to work either (parameters are not passing to the script). But then again, hardcoding the user id in the init.d script overrides the MYSQL_PARM --user=mysql parameter in /etc/sysconfig/config. - BS |
|
From: Heiko Z. <he...@zu...> - 2008-04-09 18:03:02
|
I don't have a problem with putting it into the my.cnf. I know you can do the addition with awk, maybe you can find the code somewhere via google. -- Regards Heiko Zuerker http://www.devil-linux.org Quoting Bruce Smith <bw...@ar...>: >> I'll take a look at mysql to see if it solves that problem too. > > No, that didn't solve the problem, but I did figure out the cause. > > For some reason "--user=mysql" is not working on the command line in the > init.d script during boot. > > /var/mysql/dns2.err: > ======================================================================== > 080409 10:38:44 [ERROR] Fatal error: Please read "Security" section > of the manual to find out how to run mysqld as root! > 080409 10:38:44 [ERROR] Aborting > ======================================================================== > > If I add "user = mysql" in /etc/my.cnf (under the [mysqld] section), > then mysql starts fine upon boot. Very weird ... > > Since we are copying the my.cnf file from the mysql tmp source: > > cp $TMPDIR/usr/share/mysql/my-small.cnf $ETCDIR/etc/my.cnf > > I'm not sure the best way to add the line to the file, or IF we should > add it to the file (since it overrides the config parameters). Heiko? > > I've also tried starting mysqld_safe with "su - mysql -c ..." in the > init.d script, but I haven't gotten that to work either (parameters are > not passing to the script). But then again, hardcoding the user id in > the init.d script overrides the MYSQL_PARM --user=mysql parameter > in /etc/sysconfig/config. > > - BS > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > Devil-linux-discuss mailing list > Dev...@li... > https://lists.sourceforge.net/lists/listinfo/devil-linux-discuss > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. |
|
From: Bruce S. <bw...@ar...> - 2008-04-09 19:38:10
|
> I know you can do the addition with awk, maybe you can find the code > somewhere via google. I hate awk (not because it's difficult, but because of all the overhead, and quite often people make things a lot more complicated by using awk) In this case, it's easy to do with sed, i.e.: sed 's/^\[mysqld\]$/&\nuser\t\t= mysql/' /etc/my.cnf Doesn't that look much easier!?!? ;-) (only took me a couple minutes to come up with that! :) - BS |