DSM-G600, DNS-3xx and NSA-220 Hack Forum

Just tried to install mysql. Had an extra drive lying around so installed 0.5 to see If I could get it to work....

I got the following after installing and starting mysql:

~/HD_a2/ffp/start # sh mysqld.sh start
$Initializing MySQL database: /ffp/var/mysql/mysql
Installing MySQL system tables...
080323 21:22:14 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
/ffp/sbin/mysqld: can't resolve symbol '__floatunsidf'

Installation of system tables failed!  Examine the logs in
/ffp/var/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /ffp/sbin/mysqld --skip-grant &

and use the command line tool /ffp/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /ffp/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /ffp/var/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com/.  Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Any idea what I have to do?

Last edited by pwvandeursen (2008-03-23 22:41:27)

I got this when trying to start PHPMyAdmin:

1.20 I receive the error "cannot load MySQL extension, please check PHP Configuration".

To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.

Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar.

That would be great!

Optware has php and php-fcgi ipkg (cross) compiled with mysql support, and many more.

See http://www.nslu2-linux.org/wiki/Optware/Dns323 for setup.

i got the same error as post #27. does anyone have this fun plug working? and if so how did you do it

I too get the same message as #27, and would like to have mysql up and running.
Maybe in also slimserver, which depends on a valid mysql.

No usable Google hints - and the error comes when trying to create standard databases.

looks like i'm stuck with trying to learn sqlite for the moment. i guess i'll have to try and find some resource material, all the books and stuff i have where for php & mysql.

FYI, it was reported that mysql (version 4.1.22) package in optware works now.

I have just tried to install forre's mysql - and it works like a charm!!

Here are my commands - the warnings when building the database are OK, just warnings:

~/HD_a2 # mkdir additional_packages
~/HD_a2 # cd additional_packages/
~/HD_a2/additional_packages # wget http://81.216.140.39/dns-323/mysql_and_php/my
sql-5.1.23-rc-2.tgz
Connecting to 81.216.140.39 (81.216.140.39:80)
mysql-5.1.23-rc-2.tg 100% |*******************************| 10632k 00:00:00 ETA
~/HD_a2/additional_packages # wget http://81.216.140.39/dns-323/mysql_and_php/ph
p-5.2.5-mysql-4.tgz
Connecting to 81.216.140.39 (81.216.140.39:80)
php-5.2.5-mysql-4.tg 100% |*******************************|  6389k 00:00:00 ETA
~/HD_a2/additional_packages # funpkg -i mysql-5.1.23-rc-2.tgz.tar.gz
FATAL: mysql-5.1.23-rc-2.tgz.tar.gz: File not found
~/HD_a2/additional_packages # ls
mysql-5.1.23-rc-2.tgz  php-5.2.5-mysql-4.tgz
~/HD_a2/additional_packages # funpkg -i mysql-5.1.23-rc-2.tgz
Skipping mysql-5.1.23-rc-2.tgz (already installed)
~/HD_a2/additional_packages # funpkg -r mysql-5.1.23-rc-2.tgz
Removing package mysql-5.1.23-rc-2 ...
~/HD_a2/additional_packages # ls
mysql-5.1.23-rc-2.tgz  php-5.2.5-mysql-4.tgz
~/HD_a2/additional_packages # funpkg -i mysql-5.1.23-rc-2.tgz
Installing package mysql-5.1.23-rc-2 ...
~/HD_a2/additional_packages # funpkg -i php-5.2.5-mysql-4.tgz
Installing package php-5.2.5-mysql-4 ...
~/HD_a2/additional_packages # mysql_install_db
Installing MySQL system tables...
080424 13:38:26 [Warning] option 'thread_stack': unsigned value 65536 adjusted t
o 131072
OK
Filling help tables...
080424 13:38:27 [Warning] option 'thread_stack': unsigned value 65536 adjusted t
o 131072
OK

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:

/ffp/bin/mysqladmin -u root password 'new-password'
/ffp/bin/mysqladmin -u root -h NAS password 'new-password'

Alternatively you can run:
/ffp/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

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

You can test the MySQL daemon with mysql-test-run.pl
cd /ffp/mysql-test ; perl mysql-test-run.pl

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

The latest information about MySQL is available at http://www.mysql.com/
Support MySQL by buying support/licenses from http://shop.mysql.com/


That's it!

And then I try connect to my database:

~/HD_a2/ffp/bin # ./mysql_client_test -u root
Enter password:<your password made after installation (see above)>   


#####################################
client_connect
#####################################

Establishing a connection to '' ...OK
Connected to MySQL server version: 5.1.23-rc (50123)

Creating a test database '

Given test not found: 'cb4977'
See legal test names with ./mysql_client_test -T

Aborting!
client_test_db' ...OK

#####################################
client_disconnect
#####################################

dropping the test database 'client_test_db' ...OK
closing the connection ...OK

Sorry, it is working for my too. Only problem at the moment is socket error. Don't know how to correct this at the moment, i'll find out. So thanks for this package. Mysql 5, instead of 4. (optware)

The reason why I wanted Mysql was install of slimserver or Squeezecenter - but I haven't succeded yet.
Has anyone tried installing this piece of software - prereqs are perl and Mysql.

forre wrote:

I am glad that mysql not only working for me :-)

Hi,
wont work here, but thats probably (i'm sure it is) my fault
mysql_install_db is the last thing that seems to go ok.

after that things start going wrong.

what steps do i take after this???

Greetz Henk.