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

Unfortunately no one can be told what fun_plug is - you have to see it for yourself.

You are not logged in.

#26 2008-03-22 00:51:04

pwvandeursen
Member
Registered: 2007-07-04
Posts: 112

Re: MySQL on DNS-323

Has anybody been able to compile a package that will work with funplug_0.3? I don't have the balls yet to go to 0.5, especially as it has taken me a LOT of effort to get everything running on 0.3.

hopefully someone can help me as I really want to have mysql, but can get it to run (don't even know how to start, and can't compile), so hoping someone here can help me with this.

HaydnH, do you see this becoming easy for us noobs to install with your new gui install software package you are developing?

I hope it will work and help us non IT and Linux people on our way to get packages running. I'm not trying to play down the work Fonz has put here, but it is all just a bit too much for my knowledge.

Reason I want MYSQL and not sqlite is simple, a friend of mine has made some software that needs mysql and not sqlite..... Don't know why, but would really like to be able to run it from my DNS as well...

Thanks all.
Patrick

Last edited by pwvandeursen (2008-03-22 00:52:36)

Offline

 

#27 2008-03-23 22:29:45

pwvandeursen
Member
Registered: 2007-07-04
Posts: 112

Re: MySQL on DNS-323

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)

Offline

 

#28 2008-03-23 22:46:23

pwvandeursen
Member
Registered: 2007-07-04
Posts: 112

Re: MySQL on DNS-323

frannic wrote:

This mysql package is great, but the only problem i have now is that i don't have a php install with mysql support.
Could your make an php installer with mysql support?
I am new with thi so i haven't got a clue how to do this myself.

What does this mean? MySQL and PHP do not yet work together? I need to get PHPMyAdmin to work. will it with this package?

Patrick
p.s. link is still not correct, I'm assuming it is the a http://www.lysator.liu.se/~petterl/dns3 … -rc-2.tgz? correct?

Offline

 

#29 2008-03-23 22:59:37

pwvandeursen
Member
Registered: 2007-07-04
Posts: 112

Re: MySQL on DNS-323

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.

Offline

 

#30 2008-03-24 18:27:09

pwvandeursen
Member
Registered: 2007-07-04
Posts: 112

Re: MySQL on DNS-323

is it possible to have mysql without haveing to recompile php?

I found this on http://www.yohng.com/phpm/phpm.htm#_Toc42628367

http://www.yohng.com/phpm/phpm.htm#_Toc42628367

Enabling MySQL API support for POSIX-compatible OS
When using POSIX-compatible OS (e.g., Linux, FreeBSD, Solaris, etc), then MySQL-enabling option should be applied while compiling PHP from distribution.

so It seams it will never work, unless we have a php with mysql compliled binary for the dns.....Anyone up for that?

Offline

 

#31 2008-03-24 21:27:03

frannic
New member
Registered: 2008-03-19
Posts: 4

Re: MySQL on DNS-323

That would be great!

Offline

 

#32 2008-04-05 15:01:22

frannic
New member
Registered: 2008-03-19
Posts: 4

Re: MySQL on DNS-323

Has anyone tried to compile this package with mysql support?

Offline

 

#33 2008-04-05 17:57:19

bzhou
Member
Registered: 2008-02-15
Posts: 171

Re: MySQL on DNS-323

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.

Offline

 

#34 2008-04-06 15:39:51

pwvandeursen
Member
Registered: 2007-07-04
Posts: 112

Re: MySQL on DNS-323

bzhou,

Thanks for pointing that out. Which packages do I need to have and what do I need to remove from my DNS? I have fonz 0.5 funplug now on my system.

I see in http://ipkg.nslu2-linux.org/feeds/optwa … unstable/: (by the way what does the unstable part in the link mean? do they all work?)


php-mysql_5.2.5-1_arm.ipk
php-gd_5.2.5-1_arm.ipk (I would also like GD support...)
php_5.2.5-1_arm.ipk
php-embed_5.2.5-1_arm.ipk??
lighttpd_1.4.19-3_arm.ipk
mysql_4.1.20-3_arm.ipk

Do I just install all these packages? Is there some kind of order I need to install them? did I miss something If I would like to have lighttp, php, MySql and GD support on the DNS

could you please give us linux noobs some installation help tips/steps?

Thanks in advance for your help
Patrick

Last edited by pwvandeursen (2008-04-06 15:44:57)

Offline

 

#35 2008-04-17 14:51:11

jrbilodeau
Member
Registered: 2007-11-26
Posts: 47

Re: MySQL on DNS-323

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

Offline

 

#36 2008-04-17 15:31:08

pwvandeursen
Member
Registered: 2007-07-04
Posts: 112

Re: MySQL on DNS-323

unfortunately not. I coun't get further that what is mentioned above. I hope someone with enough knowledge will succeed soon and give us a small tutorial on how to proceed. until then, no MySQL, which is a share, as I would really like to have it working.....

P

Offline

 

#37 2008-04-17 18:12:34

cab
Member
Registered: 2007-11-30
Posts: 12

Re: MySQL on DNS-323

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.

Offline

 

#38 2008-04-17 18:33:51

pwvandeursen
Member
Registered: 2007-07-04
Posts: 112

Re: MySQL on DNS-323

unfortunately my knowledge is limited, otherwise I would try to combine our knowledge and experience. However, I have no linux knowledge, so can only follow instructions.....

Is there anyone that now has php and mysql running together on the DNS (and a working phpmyadmin)?

Offline

 

#39 2008-04-17 23:08:13

jrbilodeau
Member
Registered: 2007-11-26
Posts: 47

Re: MySQL on DNS-323

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.

Offline

 

#40 2008-04-24 00:45:40

fonz
Member / Developer
From: Berlin
Registered: 2007-02-06
Posts: 1716
Website

Re: MySQL on DNS-323

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

Offline

 

#41 2008-04-24 02:31:33

bzhou
Member
Registered: 2008-02-15
Posts: 171

Re: MySQL on DNS-323

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

Offline

 

#42 2008-04-24 02:54:22

[DrAg]
Member
Registered: 2008-04-17
Posts: 16

Re: MySQL on DNS-323

No luck with mysql form forre's, see errors down here

Installing MySQL system tables...
080424  1:46:41 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
OK
Filling help tables...
080424  1:46:42 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
OK
etc.


Confirm the optware packages running smoothly, not that easy to configure as the ffp packages with examples included but working fine.
- mysql 4.1.22-2
- php-mysql 5.2.5-1
- php-fcgi 5.2.5-2

Offline

 

#43 2008-04-24 15:53:44

cab
Member
Registered: 2007-11-30
Posts: 12

Re: MySQL on DNS-323

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

Offline

 

#44 2008-04-25 00:48:54

forre
Member
Registered: 2008-04-22
Posts: 26

Re: MySQL on DNS-323

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

Offline

 

#45 2008-04-25 09:48:30

[DrAg]
Member
Registered: 2008-04-17
Posts: 16

Re: MySQL on DNS-323

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)

Offline

 

#46 2008-04-25 13:33:59

frannic
New member
Registered: 2008-03-19
Posts: 4

Re: MySQL on DNS-323

This is really great!!! I even got phpmyadmin working.
Thanks a lot Forre.

Offline

 

#47 2008-04-25 14:37:38

cab
Member
Registered: 2007-11-30
Posts: 12

Re: MySQL on DNS-323

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.

Offline

 

#48 2008-05-03 09:01:36

Jimi Bondi
Member
Registered: 2007-09-02
Posts: 9

Re: MySQL on DNS-323

Hallo,

I typ the command "mysql_install_db". The systems output:

/mnt/HD_a2/ffp/libexec # mysql_install_db
/ffp/bin/my_print_defaults: can't resolve symbol 'bcmp'
Installing MySQL system tables...
/ffp/libexec/mysqld: can't resolve symbol 'bcmp'

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

You can try to start the mysqld daemon with:

    shell> /ffp/libexec/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 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/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /ffp/bin/mysqlbug script!

/mnt/HD_a2/ffp/libexec #


Can me help anywhere?

fun_plug 0.5 with mysql-5.1.23-rc-2.tgz and  php-5.2.5-mysql-4.tgz

Thanks
Jimi Bondi

Offline

 

#49 2008-05-17 16:24:55

Henkie-Penkie
Member
Registered: 2008-05-10
Posts: 6

Re: MySQL on DNS-323

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 smile
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.

Offline

 

#50 2008-05-17 20:28:10

forre
Member
Registered: 2008-04-22
Posts: 26

Re: MySQL on DNS-323

What is going wrong?

can you post the errors in the /ffp/var/mysql/*.err

Offline

 

Board footer

Powered by PunBB
© Copyright 2002–2010 PunBB