[gentoo-server] mysql not restarting

[gentoo-server] mysql not restarting

[Darko Luketic]

Hello,

i upgraded mysql a few months ago.
i remember that this upgrade was that one that added the file server-running to /etc/init.d/mysql
i've been running mysql 4 since 08/2005, 1st install.
current installed version is 4.1.21. in this version the check for the server-running file was removed.
the problem appeared 2 upgrades ago. (4.0.x) last version was 4.0.27 , previous 4.0.26 .
when i upgraded to 4.1.21 from 4.0.27 i created a db dump, but not from 4.0.26->4.0.27.
i'm using a nptl-enabled compilation.

problem is i can't start the mysql server through the init script.
i set debug to max possible, but the output is just a counter to 40 and starting mysql failed.
when i'm starting the mysql server by hand with the parameters in the init script,
it runs fine, however as soon as i want to restart daemons depending upon mysql, the mysql server stops,
and i have to start it manually, which is annoying as e.g. i would like to restart apache or other daemons daily through cron.

i know a reboot would very likely solve the problem, but thats not an option. (366 days uptime ruined, nooo :) ).
it's not because of ibdata or similar files, it has to be something in the init script or in the content of some file that
drives the start-stop-daemon crazy.

any help appreciated

i hope my english wasn't too bad.

p.s.: does anyone know of a namebased virtualhosting module or similar for apache2 that doesn't require a graceful apache2 restart?

-- 
Darko Luketic
webmaster@power-forums.com
 
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql not restarting

[Christian Spoo]

[-- Attachment #1.1: Type: text/plain, Size: 768 bytes --]

> p.s.: does anyone know of a namebased virtualhosting module or similar for apache2 that doesn't require a graceful apache2 restart?

You could redirect all requests of a certain domain by using
<VirtualHost IP:80>
  ServerName *.domain.tld

 (other options needed for your vhost)
</VirtualHost>

Then you could easily determine which of your "virtual" vhosts is
requested by using PHP. The current domainname is stored in the special
variable $_SERVER['HTTP_HOST'] (something like "subdomain.domain.tld").

Now you can decide what page to display. But please note that this
solution requires a PHP call for every file you serve (including CSS and
images). This may cause a significant performance impact because Apache
won't able to cache anything.

[-- Attachment #1.2: mail.vcf --]
[-- Type: text/x-vcard, Size: 281 bytes --]

begin:vcard
fn:Christian Spoo
n:Spoo;Christian
adr;quoted-printable:;;Am Kaiser 26;W=C3=BCrselen;NRW;52146;Deutschland
email;internet:mail@christian-spoo.info
tel;fax:02405/475071
tel;home:02405/493466
tel;cell:0176/61055475
x-mozilla-html:FALSE
version:2.1
end:vcard


[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 888 bytes --]

Re: [gentoo-server] mysql not restarting

[Jonas Fietz]

>> p.s.: does anyone know of a namebased virtualhosting module or similar for apache2 that doesn't require a graceful apache2 restart?
If you do not need to configure things per vhost you could just use 
mod_rewrite to create some rules of how to create a path from the host 
asked for.

Jonas
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql not restarting

[Darko Luketic]

On Thu, 14 Sep 2006 02:35:47 +0200
Christian Spoo <mail@christian-spoo.info> wrote:

> > p.s.: does anyone know of a namebased virtualhosting module or similar for apache2 that doesn't require a graceful apache2 restart?
> 
> You could redirect all requests of a certain domain by using
> <VirtualHost IP:80>
>   ServerName *.domain.tld
> 
>  (other options needed for your vhost)
> </VirtualHost>
> 
> Then you could easily determine which of your "virtual" vhosts is
> requested by using PHP. The current domainname is stored in the special
> variable $_SERVER['HTTP_HOST'] (something like "subdomain.domain.tld").
> 
> Now you can decide what page to display. But please note that this
> solution requires a PHP call for every file you serve (including CSS and
> images). This may cause a significant performance impact because Apache
> won't able to cache anything.

yes, i learned about that like 2 months ago and i'm using it for another project.
but the current project is creating subdirs and linking the source dirs and files (by ln -s)
to that created dirs, the conf file in apache2's vhosts.d dir is created and a reloadme file, which
is checked by a compiled c binary for existence through cron, and does a graceful apache2 restart.
hmm, i've got an idea, thanks for reminding me :)

but apart from that , i've really searched alot and not found anything similar to
http://www.crazygreek.co.uk/content/mod_shapvh
for apache2 which could be used for different things , as described on the website in the above link.

-- 
Darko Luketic
webmaster@power-forums.com
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql not restarting

[Peter Abrahamsen]

Hello Darko,

Are you saying that turning up the debug puts nothing in the logs? I
don't use mysql, but something ought to be logged. If not, what I
often do is start the daemon manually, and if that isn't enough,
strace it.

As to the vhosts thing, please read the documentation here:
http://httpd.apache.org/docs/2.0/vhosts/mass.html

Good luck,
Peter

On 9/13/06, Darko Luketic <webmaster@power-forums.com> wrote:
> Hello,
>
> i upgraded mysql a few months ago.
> i remember that this upgrade was that one that added the file server-running to /etc/init.d/mysql
> i've been running mysql 4 since 08/2005, 1st install.
> current installed version is 4.1.21. in this version the check for the server-running file was removed.
> the problem appeared 2 upgrades ago. (4.0.x) last version was 4.0.27 , previous 4.0.26 .
> when i upgraded to 4.1.21 from 4.0.27 i created a db dump, but not from 4.0.26->4.0.27.
> i'm using a nptl-enabled compilation.
>
> problem is i can't start the mysql server through the init script.
> i set debug to max possible, but the output is just a counter to 40 and starting mysql failed.
> when i'm starting the mysql server by hand with the parameters in the init script,
> it runs fine, however as soon as i want to restart daemons depending upon mysql, the mysql server stops,
> and i have to start it manually, which is annoying as e.g. i would like to restart apache or other daemons daily through cron.
>
> i know a reboot would very likely solve the problem, but thats not an option. (366 days uptime ruined, nooo :) ).
> it's not because of ibdata or similar files, it has to be something in the init script or in the content of some file that
> drives the start-stop-daemon crazy.
>
> any help appreciated
>
> i hope my english wasn't too bad.
>
> p.s.: does anyone know of a namebased virtualhosting module or similar for apache2 that doesn't require a graceful apache2 restart?
>
> --
> Darko Luketic
> webmaster@power-forums.com
>
> --
> gentoo-server@gentoo.org mailing list
>
>
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql not restarting

[Darko Luketic]

Hi Peter, 

no , not one single line in any of the /var/log/mysql/* files, only when i start
mysql manually with the parameters in the init script i see
########
mysqld: ready for connections.
Version: '4.1.21-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Gentoo Linux mysql-4.1.21
060807 16:46:20 [Note] mysqld: Normal shutdown

060807 16:46:21 [Note] mysqld: Shutdown complete

mysqld: ready for connections.
Version: '4.1.21'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Gentoo Linux mysql-4.1.21
060823 14:09:54 [Note] mysqld: Normal shutdown

060823 14:09:54 [Note] mysqld: Shutdown complete

mysqld: ready for connections.
Version: '4.1.21'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Gentoo Linux mysql-4.1.21
060831  1:26:31 [Note] mysqld: Normal shutdown

060831  1:26:31 [Note] mysqld: Shutdown complete

mysqld: ready for connections.
Version: '4.1.21'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Gentoo Linux mysql-4.1.21
060905 15:18:15 [Note] mysqld: Normal shutdown

060905 15:18:16 [Note] mysqld: Shutdown complete

mysqld: ready for connections.
Version: '4.1.21'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Gentoo Linux mysql-4.1.21
#########

in /var/log/mysql/mysqld.err

mysql.err and mysql.log are empty

when i try the init script i get:
#####
# /etc/init.d/mysql start
dbg:  >>> start()
 *  ...
dbg:  >>> get_slot_config()
dbg:  srv                0
dbg:  srv_slot           0
dbg:  srv_num
dbg:  tmp_eval           mysql_slot_0[@]
dbg:  conf_d_parameters
dbg:  MY_SUFFIX
dbg:  chroot dir =>
dbg:  niceness   =>
dbg:  basedir    => /usr
dbg:  datadir    => /var/lib/mysql
dbg:  pidfile    => /var/run/mysqld/mysqld.pid
dbg:  socket     => /var/run/mysqld/mysqld.sock
dbg:  Unamanged  =>
dbg:  <<< get_slot_config() ok
dbg:  >>> checkconfig("/var/lib/mysql")
dbg:  <<< checkconfig() ok
 * Starting mysql (/etc/mysql/my.cnf)
dbg:  starting mysqld with: --defaults-file=/etc/mysql/my.cnf   --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
dbg:
49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0,dbg:
 * MySQL NOT started (0)
dbg:  <<< start()             
######

*shrug*

On Wed, 13 Sep 2006 18:51:44 -0700
"Peter Abrahamsen" <rainhead@gmail.com> wrote:

> Hello Darko,
> 
> Are you saying that turning up the debug puts nothing in the logs? I
> don't use mysql, but something ought to be logged. If not, what I
> often do is start the daemon manually, and if that isn't enough,
> strace it.
> 
> As to the vhosts thing, please read the documentation here:
> http://httpd.apache.org/docs/2.0/vhosts/mass.html
> 
> Good luck,
> Peter
> 
> On 9/13/06, Darko Luketic <webmaster@power-forums.com> wrote:
> > Hello,
> >
> > i upgraded mysql a few months ago.
> > i remember that this upgrade was that one that added the file server-running to /etc/init.d/mysql
> > i've been running mysql 4 since 08/2005, 1st install.
> > current installed version is 4.1.21. in this version the check for the server-running file was removed.
> > the problem appeared 2 upgrades ago. (4.0.x) last version was 4.0.27 , previous 4.0.26 .
> > when i upgraded to 4.1.21 from 4.0.27 i created a db dump, but not from 4.0.26->4.0.27.
> > i'm using a nptl-enabled compilation.
> >
> > problem is i can't start the mysql server through the init script.
> > i set debug to max possible, but the output is just a counter to 40 and starting mysql failed.
> > when i'm starting the mysql server by hand with the parameters in the init script,
> > it runs fine, however as soon as i want to restart daemons depending upon mysql, the mysql server stops,
> > and i have to start it manually, which is annoying as e.g. i would like to restart apache or other daemons daily through cron.
> >
> > i know a reboot would very likely solve the problem, but thats not an option. (366 days uptime ruined, nooo :) ).
> > it's not because of ibdata or similar files, it has to be something in the init script or in the content of some file that
> > drives the start-stop-daemon crazy.
> >
> > any help appreciated
> >
> > i hope my english wasn't too bad.
> >
> > p.s.: does anyone know of a namebased virtualhosting module or similar for apache2 that doesn't require a graceful apache2 restart?
> >
> > --
> > Darko Luketic
> > webmaster@power-forums.com
> >
> > --
> > gentoo-server@gentoo.org mailing list
> >
> >
> -- 
> gentoo-server@gentoo.org mailing list
> 


-- 
Darko Luketic
webmaster@power-forums.com
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql not restarting

[kashani]

Darko Luketic wrote:

> p.s.: does anyone know of a namebased virtualhosting module or
> similar for apache2 that doesn't require a graceful apache2 restart?
> 

I've used variations on this a long time ago. It worked fairly well.

http://httpd.apache.org/docs/1.3/mod/mod_vhost_alias.html

For simple name-based virtual hosts you might use the following 
directives in your server configuration file:

     UseCanonicalName    Off
     VirtualDocumentRoot /usr/local/apache/vhosts/%0

or if you'd like it all in Mysql

*  net-www/mod_vdbh
       Latest version available: 1.0.3-r1
       Latest version installed: [ Not Installed ]
       Size of files: 7 kB
       Homepage:      http://www.synthemesc.com/mod_vdbh/
       Description:   An Apache2 DSO for mass virtual hosting using a 
MySQL database
       License:       Apache-1.1

kashani
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql not restarting

[Darko Luketic]

On Thu, 14 Sep 2006 09:46:09 -0700
kashani <kashani-list@badapple.net> wrote:

> Darko Luketic wrote:
> 
> > p.s.: does anyone know of a namebased virtualhosting module or
> > similar for apache2 that doesn't require a graceful apache2 restart?
> > 
> 
> I've used variations on this a long time ago. It worked fairly well.
> 
> http://httpd.apache.org/docs/1.3/mod/mod_vhost_alias.html
> 
> For simple name-based virtual hosts you might use the following 
> directives in your server configuration file:
> 
>      UseCanonicalName    Off
>      VirtualDocumentRoot /usr/local/apache/vhosts/%0
> 
> or if you'd like it all in Mysql
> 
> *  net-www/mod_vdbh
>        Latest version available: 1.0.3-r1
>        Latest version installed: [ Not Installed ]
>        Size of files: 7 kB
>        Homepage:      http://www.synthemesc.com/mod_vdbh/
>        Description:   An Apache2 DSO for mass virtual hosting using a 
> MySQL database
>        License:       Apache-1.1
> 
> kashani
> -- 
> gentoo-server@gentoo.org mailing list
> 

very nice, thanks alot kashani

-- 
Darko Luketic
webmaster@power-forums.com
-- 
gentoo-server@gentoo.org mailing list