MySql on SlugOS

[gaojian858]

Hi, I want setup Asterisk to use MySQL DB so I start to play it under
SlugOS. Here I got a problem: The MySQL won't start when the slug boot
up. So please help me out.

I did a fresh installation of SlugOS 4.8-beta Release. Then I
installed MySQL by issue command:
ipkg-opt install mysql
This installed MySql 4.1.22

The root password has been set. But after reboot MySQL won't start.

Here are few things I noticed:
1. issue command "/opt/etc/init.d/S70myslqd start" will start the
mysqld as root user.

  916 root        708 S   /bin/sh /opt/bin/mysqld_safe
--datadir=/opt/var/lib/mysql --pid-file=/opt/var/lib/mysql/SlugOSBE.pid
  949 root       3528 S   /opt/libexec/mysqld --basedir=/opt
--datadir=/opt/var/lib/mysql --user=root
--pid-file=/opt/var/lib/mysql/SlugOSBE.pid --skip-external-locking
--port=3306 --socket=/tmp/m
 

2. ls /opt/etc/init.d -l
root@SlugOSBE:/opt/var/lib/mysql/mysql$   ls /opt/etc/init.d -l
lrwxrwxrwx    1 root     root           30 Feb 18 11:26 K70mysqld ->
../../share/mysql/mysql.server
lrwxrwxrwx    1 root     root           30 Feb 18 11:26 S70mysqld ->
../../share/mysql/mysql.server

The K70 and S70 links point to the same /opt/share/mysql/mysql.server

So how can I fix this problem? Please help. Thanks.

Jian

[gaojian858]

found the answer myself.
http://www.nslu2-linux.org/wiki/OpenSlug/StartupOptProgram

:)


--- In nslu2-asterisk@..., "gaojian858" <gaojian858@...>
wrote:

>
> Hi, I want setup Asterisk to use MySQL DB so I start to play it under
> SlugOS. Here I got a problem: The MySQL won't start when the slug boot
> up. So please help me out.
>
> I did a fresh installation of SlugOS 4.8-beta Release. Then I
> installed MySQL by issue command:
> ipkg-opt install mysql
> This installed MySql 4.1.22
>
> The root password has been set. But after reboot MySQL won't start.
>
> Here are few things I noticed:
> 1. issue command "/opt/etc/init.d/S70myslqd start" will start the
> mysqld as root user.
>
>   916 root        708 S   /bin/sh /opt/bin/mysqld_safe
> --datadir=/opt/var/lib/mysql --pid-file=/opt/var/lib/mysql/SlugOSBE.pid
>   949 root       3528 S   /opt/libexec/mysqld --basedir=/opt
> --datadir=/opt/var/lib/mysql --user=root
> --pid-file=/opt/var/lib/mysql/SlugOSBE.pid --skip-external-locking
> --port=3306 --socket=/tmp/m
>  
>
> 2. ls /opt/etc/init.d -l
> root@SlugOSBE:/opt/var/lib/mysql/mysql$   ls /opt/etc/init.d -l
> lrwxrwxrwx    1 root     root           30 Feb 18 11:26 K70mysqld ->
> ../../share/mysql/mysql.server
> lrwxrwxrwx    1 root     root           30 Feb 18 11:26 S70mysqld ->
> ../../share/mysql/mysql.server
>
> The K70 and S70 links point to the same /opt/share/mysql/mysql.server
>
> So how can I fix this problem? Please help. Thanks.
>
> Jian
>

[gaojian858]

Now I am having another problem......

MySQL is running on socket. I need get it connected at port 3306. How
can I open the port?

I googled but can't find the solution.

So far, I tried edit my.cnf file, comment out skip-networking, no
help! Run netstat and there is nothing on port 3306.

I don't have iptables so it is not a firewall issue.

Please help. Thanks.

Jian






--- In nslu2-asterisk@..., "gaojian858" <gaojian858@...>
wrote:

>
> found the answer myself.
> http://www.nslu2-linux.org/wiki/OpenSlug/StartupOptProgram
>
> :)
>
>
> --- In nslu2-asterisk@..., "gaojian858" <gaojian858@>
> wrote:
> >
> > Hi, I want setup Asterisk to use MySQL DB so I start to play it under
> > SlugOS. Here I got a problem: The MySQL won't start when the slug boot
> > up. So please help me out.
> >
> > I did a fresh installation of SlugOS 4.8-beta Release. Then I
> > installed MySQL by issue command:
> > ipkg-opt install mysql
> > This installed MySql 4.1.22
> >
> > The root password has been set. But after reboot MySQL won't start.
> >
> > Here are few things I noticed:
> > 1. issue command "/opt/etc/init.d/S70myslqd start" will start the
> > mysqld as root user.
> >
> >   916 root        708 S   /bin/sh /opt/bin/mysqld_safe
> > --datadir=/opt/var/lib/mysql

--pid-file=/opt/var/lib/mysql/SlugOSBE.pid

> >   949 root       3528 S   /opt/libexec/mysqld --basedir=/opt
> > --datadir=/opt/var/lib/mysql --user=root
> > --pid-file=/opt/var/lib/mysql/SlugOSBE.pid --skip-external-locking
> > --port=3306 --socket=/tmp/m
> >  
> >
> > 2. ls /opt/etc/init.d -l
> > root@SlugOSBE:/opt/var/lib/mysql/mysql$   ls /opt/etc/init.d -l
> > lrwxrwxrwx    1 root     root           30 Feb 18 11:26 K70mysqld ->
> > ../../share/mysql/mysql.server
> > lrwxrwxrwx    1 root     root           30 Feb 18 11:26 S70mysqld ->
> > ../../share/mysql/mysql.server
> >
> > The K70 and S70 links point to the same /opt/share/mysql/mysql.server
> >
> > So how can I fix this problem? Please help. Thanks.
> >
> > Jian
> >
>