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.

Announcement

Pages: 1

 

#1 2009-01-18 00:46:29

hape
Member
From: Germany
Registered: 2008-12-22
Posts: 12

perl and mysql - what did you do that this works together

hi
i have installed mysql and phpmyadmin - everything works
i have installed perl everything works
but if i start this script
#!/ffp/bin/perl

# PERL MODULES
use Mysql;

# MYSQL CONFIG VARIABLES
$host = "localhost";
$database = "test";
$user = "xx";
$pw = "xx";

# PERL CONNECT()
$connect = Mysql->connect($host, $database, $user, $pw);

# LISTDBS()
@databases = $connect->listdbs;
foreach $database (@databases) {
    print "$database<br />";
    }

i get this error

Can't locate Mysql.pm in @INC (@INC contains: /ffp/lib/perl5/5.10.0/arm-linux-thread-multi /ffp/lib/perl5/5.10.0 /ffp/lib/perl5/site_perl/5.10.0/arm-linux-thread-multi /ffp/lib/perl5/site_perl/5.10.0 /ffp/lib/perl5/vendor_perl/5.10.0/arm-linux-thread-multi /ffp/lib/perl5/vendor_perl/5.10.0 /ffp/lib/perl5/vendor_perl .) at ./listdbs.pl line 4.

which is correct it resides in
/ffp/lib/perl5/5.10.0/arm-linux-thread-multi/DBD and /ffp/lib/perl5/5.10.0/arm-linux-thread-multi/Bundle/DBD

so it seems to me that i have to start another script which combines mysql and perl or something like that

any ideas?

Offline

 

#2 2009-01-18 16:30:45

hape
Member
From: Germany
Registered: 2008-12-22
Posts: 12

Re: perl and mysql - what did you do that this works together

hi

i tried more things

/mnt/HD_a2/ffp/tmp # wget http://search.cpan.org/CPAN/authors/id/ … 607.tar.gz
/mnt/HD_a2/ffp/tmp # tar xfz DBI-1.607.tar.gz
/mnt/HD_a2/ffp/tmp # cd DBI-1.607/
/mnt/HD_a2/ffp/tmp/DBI-1.607 # perl Makefile.PL
/mnt/HD_a2/ffp/tmp/DBI-1.607 # make
/mnt/HD_a2/ffp/tmp/DBI-1.607 # make install
/mnt/HD_a2/ffp/tmp/DBI-1.607 # cd ..

as described here http://forums.slimdevices.com/showthread.php?t=52664 (4.2.2)

/mnt/HD_a2/ffp/tmp # wget http://search.cpan.org/CPAN/authors/id/ … 008.tar.gz
/mnt/HD_a2/ffp/tmp # tar xfz DBD-mysql-4.008.tar.gz
/mnt/HD_a2/ffp/tmp # cd DBD-mysql-4.008/
/mnt/HD_a2/ffp/tmp/DBD-mysql-4.008 # perl Makefile.PL
/mnt/HD_a2/ffp/tmp/DBD-mysql-4.008 # make
/mnt/HD_a2/ffp/tmp/DBD-mysql-4.008 # make install
/mnt/HD_a2/ffp/tmp/DBD-mysql-4.008 # cd ..

as described here http://forums.slimdevices.com/showthread.php?t=52664 (4.2.3)

so i got a lot of output but it seems todo things correct. But the script in my first post gets the same error

root@dns323:/mnt/HD_a2/ffp/etc/perlskrip# ./listdbs.pl
Can't locate Mysql.pm in @INC (@INC contains: /ffp/lib/perl5/5.10.0/arm-linux-thread-multi /ffp/lib/perl5/5.10.0 /ffp/lib/perl5/site_perl/5.10.0/arm-linux-thread-multi /ffp/lib/perl5/site_perl/5.10.0 /ffp/lib/perl5/vendor_perl/5.10.0/arm-linux-thread-multi /ffp/lib/perl5/vendor_perl/5.10.0 /ffp/lib/perl5/vendor_perl .) at ./listdbs.pl line 4.
BEGIN failed--compilation aborted at ./listdbs.pl line 4.

so i'm again at the beginning

did anybody know how to get this working?

it would be very nice to give a hint or an installation description or something like that
thx a lot
hape

Ps make test gives this:
root@dns323:/mnt/HD_a2/ffp/pkg/cpan/DBD-mysql-4.008# make test
PERL_DL_NONLAZY=1 /ffp/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base......................ok
t/10connect...................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) Can't continue test
t/20createdrop................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/25lockunlock................skipped: Can't connect to database ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/29warnings..................skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) at t/29warnings.t line 15
t/30insertfetch...............skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/31insertid..................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/32insert_error..............skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) at t/32insert_error.t line 17
t/35limit.....................skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) at t/35limit.t line 18
t/35prepare...................skipped: Can't connect to database ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/40bindparam.................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/40bindparam2................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/40blobs.....................Can't call method "get_info" on an undefined value at t/40blobs.t line 37.
t/40blobs..................... Dubious, test returned 2 (wstat 512, 0x200)
No subtests run
t/40catalog...................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/40keyinfo...................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/40listfields................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/40nulls.....................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/40numrows...................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/40server_prepare............skipped: ERROR: DBI connect('test;mysql_server_prepare=1','root',...) failed: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) at t/40server_prepare.t line 16
t/40server_prepare_error......skipped: ERROR: DBI connect('test;mysql_server_prepare=1','root',...) failed: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) at t/40server_prepare_error.t line 18
t/40types.....................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/41bindparam.................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/41blobs_prepare.............skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/42bindparam.................skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) at t/42bindparam.t line 13
t/50chopblanks................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/50commit....................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/55utf8......................skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) at t/55utf8.t line 18
t/60leaks.....................skipped: Skip $ENV{SLOW_TESTS} is not set
t/65types.....................skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) at t/65types.t line 13
t/70takeimp...................skipped: Can't connect to database ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) at t/70takeimp.t line 27
t/71impdata...................DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) at t/71impdata.t line 14
t/71impdata...................skipped: Can't obtain driver handle. Can't continue test
t/75supported_sql.............skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test
t/76multi_statement...........skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) at t/76multi_statement.t line 15
t/80procs.....................skipped: ERROR: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2). Can't continue test

Test Summary Report
-------------------
t/40blobs.t               (Wstat: 512 Tests: 0 Failed: 0)
  Non-zero exit status: 2
  Parse errors: No plan found in TAP output
Files=34, Tests=6, 53 wallclock secs ( 0.82 usr  0.24 sys + 49.42 cusr  2.37 csys = 52.85 CPU)
Result: FAIL
Failed 1/34 test programs. 0/6 subtests failed.
make: *** [test_dynamic] Error 255

Last edited by hape (2009-01-18 16:33:21)

Offline

 

#3 2009-01-18 16:47:48

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

Re: perl and mysql - what did you do that this works together

hape wrote:

/mnt/HD_a2/ffp/tmp # wget http://search.cpan.org/CPAN/authors/id/ … 607.tar.gz
/mnt/HD_a2/ffp/tmp # wget http://search.cpan.org/CPAN/authors/id/ … 008.tar.gz

These correspond to
http://www.inreto.de/dns323/fun-plug/0. … rl-mod-DBI
and
http://www.inreto.de/dns323/fun-plug/0. … -DBD-mysql

The documentation of the mysql interface is at
http://search.cpan.org/~capttofu/DBD-my … D/mysql.pm

There's no 'Use Mysql', but 'Use DBI', and also no 'connect'. It seems, your testprogram is for a different mysql module.

Offline

 

#4 2009-01-18 17:09:02

hape
Member
From: Germany
Registered: 2008-12-22
Posts: 12

Re: perl and mysql - what did you do that this works together

hi everyone

thx fonz for the answer. Life can be so easy if you do the right things together.

here ist line 9 :
my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost",
                       "xxx", "xx",
                      {'RaiseError' => 1});


but i got every time this error :

DBI connect('database=test;host=localhost','root',...) failed: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) at ./listdbs.pl line 9

any idreas?

hape

Last edited by hape (2009-01-18 17:38:46)

Offline

 

#5 2009-01-18 18:23:48

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

Re: perl and mysql - what did you do that this works together

Did you start mysql? Is it running?

Offline

 

#6 2009-01-18 19:21:30

hape
Member
From: Germany
Registered: 2008-12-22
Posts: 12

Re: perl and mysql - what did you do that this works together

hi
thx fonz. Yes the mysql was down - so it can't work. Now everything is fine.
thx a lot
hape

Offline

 

 

Pages: 1

Board footer

Powered by PunBB
© Copyright 2002–2010 PunBB