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

cab wrote:

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.

I succeeded in getting slimserver 6.3 to work, but i would like 6.5.4. But i haven't managed that one yet.
For instructions:
http://dns323.kood.org/forum/t2012-Tuto … .4%29.html

I seams that a program already using port 3306.

type:
ps | grep mysqld
to check if mysqld already is running.

It is a start script in /ffp/start for mysqld. If this file has execution rights, then mysqld is starting when you boot the device.

try:
sh /ffp/start/mysqld.sh stop
sh /ffp/start/mysqld.sh start

The mysqld was already running

connect by typing
mysql -u root

mysql> show databases;
mysql> quit;

if you type ls -la /ffp/start/my*
and the you can find if the start scipt has execution rigts (the x in "-rwxr-xr-x")

I think everything is ok.

Hi there,

now that mysql is up and running i succesfully installed kplaylist.
at the moment its adding 63414 mp3's to the database (wonder how long this is going to take).
hope its not going to freeze up.

Grtzz Henk.

bump... please help me out here guys.. I've tried uninstalling php and mysql and reinstalling them.. but still the same socket error when I got to configure the mysql root password.. I'm trying to do this so that I can install ampache.

that still doesn't seem to help.. I have installed
mysql-5.1.23-rc-2.tgz & also php-5.2.6-mysql-1.tgz

from this website http://81.216.140.39/dns-323/mysql_and_php/

After this, I did the mysql_db_install and it gave me..

========================================

Installing MySQL system tables...
080522 16:36:48 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
OK
Filling help tables...
080522 16:36:48 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 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 dlinkNAS 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/
==========================================

Then after this I do the following... just to check if mysql is running..

======
# mysqld_safe &
# 080522 16:37:11 mysqld_safe Logging to '/ffp/var/mysql/dlinkNAS.err'.
080522 16:37:12 mysqld_safe A mysqld process already exists

[1] + Done(1)                    mysqld_safe
root@dlinkNAS:/mnt/HD_a2/ffp/tmp# ps | grep mysqld
5414 root     /bin/sh /ffp/bin/mysqld_safe --syslog
5553 root     /ffp/libexec/mysqld --basedir=/ffp --datadir=/ffp/var/mysql --user=root --pid-file=/ffp/var/mysqld.pid --socket=/ffp/var/mysql.sock --port=3306
5554 root     logger -t mysqld -p daemon.error
5555 root     /ffp/libexec/mysqld --basedir=/ffp --datadir=/ffp/var/mysql --user=root --pid-file=/ffp/var/mysqld.pid --socket=/ffp/var/mysql.sock --port=3306
5556 root     /ffp/libexec/mysqld --basedir=/ffp --datadir=/ffp/var/mysql --user=root --pid-file=/ffp/var/mysqld.pid --socket=/ffp/var/mysql.sock --port=3306
10078 root     grep mysqld
====================

Then I get to the part of ......
root@dlinkNAS:~# /ffp/bin/mysql_secure_installation




NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Enter current password for root (enter for none):
================================

As you see.. this is where i get stuck in a loop.. and I have to quit terminal service and re-telnet..

ALSO NOTE:

I downloaded the php.ini file from the above mentioned website (from where I downloaded the packages).. and put that under /ffp/etc

I haven't made any changes to it.


WHAT AM I DOING WRONG? WHAT I SHOULD I DO?.. ALSO.. HERE IS THE .ERR FILE

======================================
080521 19:35:50 mysqld_safe Starting mysqld daemon with databases from /ffp/var/
080521 19:35:50 [Warning] option 'thread_stack': unsigned value 65536 adjusted t
080521 19:35:50 [Note] Event Scheduler: Loaded 0 events
080521 19:35:50 [Note] /mnt/HD_a2/ffp/libexec/mysqld: ready for connections.
Version: '5.1.23-rc'  socket: '/ffp/var/mysql.sock'  port: 3306  Source distribu
080521 19:43:04 [Note] /mnt/HD_a2/ffp/libexec/mysqld: Normal shutdown

080521 19:43:04 [Note] Event Scheduler: Purging the queue. 0 events
080521 19:43:04 [Note] /mnt/HD_a2/ffp/libexec/mysqld: Shutdown complete

080521 19:43:04 mysqld_safe mysqld from pid file /ffp/var/mysqld.pid ended
080521 20:02:22 mysqld_safe A mysqld process already exists
080521 20:39:19 mysqld_safe A mysqld process already exists
080521 22:54:49 mysqld_safe A mysqld process already exists
080521 22:56:23 mysqld_safe Starting mysqld daemon with databases from /ffp/var/
080521 22:56:23 [Warning] option 'thread_stack': unsigned value 65536 adjusted t
080521 22:56:23 [Note] Event Scheduler: Loaded 0 events
080521 22:56:23 [Note] /ffp/libexec/mysqld: ready for connections.
Version: '5.1.23-rc'  socket: '/ffp/var/mysql.sock'  port: 3306  Source distribu
080521 23:06:13 [Note] /ffp/libexec/mysqld: Normal shutdown

080521 23:06:13 [Note] Event Scheduler: Purging the queue. 0 events
080521 23:06:13 [Note] /ffp/libexec/mysqld: Shutdown complete
===================================================

NOW I AM WONDERING...

why is it looking under /tmp for the mysql.sock???? I don't see that file being in there.. Do i need to define the path of mysql.sock in some configuration file?? What is the problem here? I have downloaded the php.ini and put it in the /etc without modifying anything.. I assumed the author of those packages have them all working together..

AM I SUPPOSED TO HAVE a my.cnf ALSO in the /ffp/etc???

Hey.. thanks for your reply.. I tried that.. the socket error has gone.. but now when I do the

/ffp/bin/mysql_secure_installation



It tells me..

Enter current password for root (enter for none): (I hit enter here)

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Enter current password for root (enter for none):

I don't know why it says access denied.. I am logged in as root
any ideas???

fonz wrote:

anyone tried forre's packages,yet?
http://81.216.140.39/dns-323/mysql_and_php/

I tried this some time ago and got it working in the end. However I wanted to have imagemagick working as well so installed it from fonz's site, but after that my mysql got broken so I need to reinstall it again....(unless someone knows why it could be the case and knows how to solve it.

So I wanted to go back to the site above, but the link doesn't work anymore......

How can I get it again, and get Mysql and imagemagick working together?

Thanks
Patrick

Thanks forre, just got it working again.
anybody know why after installing imagemagick from fonz that the mysql installtion got broken? How can I get imagemagick working in this setup?

What steps did you follow to install imagemagick?

I have compiled mysql-5.1.26-rc from release candidate tree and mysql-5.0.67 from GA tree for FFP 0.5.

Changelogs:
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html
http://dev.mysql.com/doc/refman/5.0/en/ … es-cs.html

http://81.216.140.39/dns-323/mysql_and_php/

NOTE! /ffp/etc/my.cnf are deleted after upgrade. Make a backup on this file!

I've got segmentation fault every time I tried to compile mysql. I could fix this by recompiling and installing
gcc, uclibc, make, autoconf and automake, in that order.

I do not know which of these packages that ocuured segmentation fault when compiling.

Last edited by forre (2008-08-20 17:12:18)

WildSioux wrote:

I can get into something using:  mysql -u "localhost"

It is OK. You can check soem with following commands:

mysql -u "localhost"
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema | 
| test               | 
+--------------------+
2 rows in set (0.00 sec)

mysql> use information_schema;
Database changed
mysql> select * from USER_PRIVILEGES;
+----------------+---------------+----------------+--------------+
| GRANTEE        | TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
+----------------+---------------+----------------+--------------+
| ''@'localhost' | NULL          | USAGE          | NO           | 
+----------------+---------------+----------------+--------------+
1 row in set (0.00 sec)

WildSioux wrote:

[However, how do I find out what my username and password is?  Also, instead of root, I can get into "localhost."  Don't know how that happened.

When installing mysql, the user root exist without any password

do same commands after login as root to see the differencis (mysql -u root)

To change root password, see earlier message from emailpr