MySQL not working as it should...

[herskegut]

Hi folks,

i am having a bit of a problem here, for my ending project at school, i have set my mind to develop a mobile measure station, complete with microcontroller, solar panels etc..

in the heart of the system the Asus wl-500gx rules the day, but.. i want to run mysql on it, and for the looks of it, the ipkg packed exist
http://ipkg.nslu2-linux.org/feeds/unslung/wl500g/

i installed it, along with php and so on.. but when i try to execute mysql_install_db it comes out with this :



[admin@skynet bin]$ mysql_install_db
/opt/bin/mysql_install_db: 151: /bin/hostname: not found
WARNING: The host '' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing all prepared tables
Bad system call


have anyone tried to play with mysql on the asus wl-500g ? i am useing the latest version of Oleg's firmware.

if there are any questions related to the setup, please be free to ask me :)


the basic of my entie setup, is looking something like this :

[oleo]

I've briefly checked mysql onece or twice. You can manualy edit mysql_install_db for proper setting and correct missing hostname.

When you will manage to get socket right. Post your changes here and I will change the package following your instructions.

[dayryad]

Firmware:WL500g-1.9.2.7-7c
ipkg install mysql - generates the following error

Downloading http://ipkg.nslu2-linux.org/feeds/unslung/wl500g/mysql_4.1.16-5_mipsel.ipk
Configuring mysql
/opt/etc/init.d/S70mysqld: 185: /bin/hostname: not found
Starting MySQL................................... ERROR!
Successfully terminated.

[oleo]

Edit the S70mysqld file and replace with IP name or `cat /proc/sys/kernel/hostname`

[dayryad]

PLs. can you be more specific?

1.in /proc/sys/kernel/hostname we have (none)
it can be modifyed in something like "localhost" ? how?

1. in S70mysqld : can you give an example?

Tks!

[oleo]

Looks like this is uClibc/libc/sysdeps/linux/common/getdents64.c
memory problem. No hope for now. Use other database!

[herskegut]

I got it working :) finally!

insteed of running it all from the firmware dist, i got a debian up and running, and now its running with apache/php/mysql and all other things needed for my project.

Thanks for the help guys :D