not sticky: mysql

[wpte]

the sticky post up here in the forums, I dunno, but it's just not working for me.
I installed my router from the beginning with the "better" uclibc and ipkg, also, I'm already using root as user! I just did that because I really want mysql to work

[root@(none) root]$ ipkg install mysql
Installing mysql (4.1.20-2) to /opt/...
Downloading http://ipkg.nslu2-linux.org/feeds/op...0-2_mipsel.ipk
Configuring mysql
Starting MySQL................................... ERROR!
Successfully terminated.
[root@(none) root]$ rm /opt/var/lib/mysql/mysql/*.*
[root@(none) root]$ rmdir /opt/var/lib/mysql/mysql
[root@(none) root]$ /opt/bin/mysql_install_db
WARNING: The host '(none)' 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
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/bin/mysqladmin -u root password 'new-password'
/opt/bin/mysqladmin -u root -h (none) password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /opt ; /opt/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /opt/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
[root@(none) root]$
[root@(none) root]$ cd /opt ; /opt/bin/mysqld_safe &
[root@(none) /opt]$ Starting mysqld daemon with databases from /opt/var/lib/mysql
/opt/bin/mysqld_safe: eval: 1: Syntax error: "(" unexpected

[1] + Done(2) /opt/bin/mysqld_safe
[root@(none) /opt]$ chown -R root:root /opt/var/lib/mysql
[root@(none) /opt]$ /opt/etc/init.d/S70mysqld start
Starting MySQL................................... ERROR!

as you can see I tried the tutorial, and read everything about it, every post.
I just can't get it to start...
the weird thing is, that no single log reports any errors they are just empty

I managed to start it once "Starting MySQL SUCCES!" guess what... it wasnt there, because the mysql admin (to change the password) said that no server was available on local host to connect to

what is this... I really can't figure it out on my own anymore

btw.. I'm running a WL-500W, but that one is totally the same with the gP(only the wireless chip is not).

thanks

[raas]

Hi,

I've had problems with installing MySQL too when following the tutorial you mentioned.

However.. to install it, I used the following tutorial: http://www.macsat.com/macsat/content/view/73/29/ which is basically the same as the one you mentioned, but with this one I got it to work.

HTH.

[Kolandr]

wpte,

[root@(none) root]$ ipkg install mysql

your host is (none), try to change it to another name, such as asus, router, etc
there: web interface - IP Config - WAN & LAN - LAN IP Setting - Host Name.
i had same problem with

Syntax error: "(" unexpected

[wpte]

aaah thanks, I got it working now
you made my day mate

the sql server is still not visible to the outside world.. I like MySQL CC to manage all the tables, also a bit safer than php myadmin.
Any way I can put it on? I know it's an option, but I have no idea how to turn it on on the router (I can do it in windows tough :P)

[raas]

Hi,

is Mysql CC a 'web-application' ? (usign php) if so , you should be able to put it in the webroot.. (assuming that you have php installed.. )


phpmyadmin runs, although a bit slow, but it runs.

[wpte]

Hi,

is Mysql CC a 'web-application' ? (usign php) if so , you should be able to put it in the webroot.. (assuming that you have php installed.. )


phpmyadmin runs, although a bit slow, but it runs.

no it's a windows app for managing mysql servers. http://sourceforge.net/projects/mysqlcc/

I prefer this one above the php myadmin because this one isn't visible on the web.
However, in this case I have to allow remote clients to connect, this is an option, and I only want this for my intranet


--
I also see you got lighttpd working, I just can't get it started... I'm now using the php-thttpd package, you know a good tutorial for the light version?
Are you able to run in on port 80 for internet users to view your site? because I'm curious about that ;-)