The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Installing DBI::MySQL

Discussion in 'General Discussion' started by WildWayz, Jan 3, 2002.

  1. WildWayz

    WildWayz Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    209
    Likes Received:
    0
    Trophy Points:
    16
    Hi ya

    Anyone have any experience getting this installed?

    I tried using WHM\'s Install Perl Mod but it seems to always fail to compile.

    I also tried /scripts/installdbi (I think thats its name) but it goes into an endless loop of \"Enter country code\" or similar.

    Sorry for the vagueness :)

    --James
     
  2. Jon

    Jon Registered

    Joined:
    Aug 19, 2001
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Hi James,

    Try installing it manually

    [code:1:3cb3bafcf2]
    wget http://www.cpan.org/authors/id/TIMB/DBI-1.20.tar.gz
    tar zxvf DBI-1.20.tar.gz
    cd DBI-1.20
    perl Makefile.pl
    make
    make test
    make install
    [/code:1:3cb3bafcf2]

    John
     
  3. WildWayz

    WildWayz Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    209
    Likes Received:
    0
    Trophy Points:
    16
    Thanks - that worked fine.

    Now to install DBI::MySQL
    (so Perl can interact with MySQL)

    Any ideas?

    James
     
  4. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    16
    /scripts/fixinterchange
    :)

    or from cpan shell,
    force install DBD::mysql

    or use wget in the fashion described earlier in this thread.
     
  5. Jon

    Jon Registered

    Joined:
    Aug 19, 2001
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    If you want to do a manual install for DBD::MySQL it is the same process as above, the url: http://www.cpan.org/authors/id/JWIED/DBD-mysql-2.1009.tar.gz
     
  6. WildWayz

    WildWayz Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    209
    Likes Received:
    0
    Trophy Points:
    16
    Thanks all those who helped :)

    James
     
  7. carperman

    carperman Well-Known Member

    Joined:
    Feb 7, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    [quote:26feacd28f][i:26feacd28f]Originally posted by feanor[/i:26feacd28f]


    /scripts/fixinterchange
    :)

    or from cpan shell,
    force install DBD::mysql

    or use wget in the fashion described earlier in this thread.

    [/quote:26feacd28f]

    Hello, i followed instruction given in this thread and installed DBI ok but i when i tried DBD.mysql
    make test
    I got loads of errors, i have post results of make test, if any one could give some feed back on cause of errors it would be much appriciated.

    It seems to be telling me that server is not up and running, but it is, both apache and mysql are working fine.

    -------begin make test output----
    PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.1/i686-linux -I/usr/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
    t/00base............ok
    t/10dsnlist.........DBI-&connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/10dsnlist.t line 45
    Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
    Either your server is not up and running or you have no
    permissions for acessing the DSN DBI:mysql:test.
    This test requires a running server and write permissions.
    Please make sure your server is running and you have
    permissions, then retry.
    t/10dsnlist.........dubious
    Test returned status 10 (wstat 2560, 0xa00)
    DIED. FAILED tests 1-9
    Failed 9/9 tests, 0.00% okay
    t/20createdrop......DBI-&connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/20createdrop.t line 45
    Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
    Either your server is not up and running or you have no
    permissions for acessing the DSN DBI:mysql:test.
    This test requires a running server and write permissions.
    Please make sure your server is running and you have
    permissions, then retry.
    t/20createdrop......dubious
    Test returned status 10 (wstat 2560, 0xa00)
    DIED. FAILED tests 1-5
    Failed 5/5 tests, 0.00% okay
    t/30insertfetch.....DBI-&connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/30insertfetch.t line 48
    Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
    Either your server is not up and running or you have no
    permissions for acessing the DSN DBI:mysql:test.
    This test requires a running server and write permissions.
    Please make sure your server is running and you have
    permissions, then retry.
    t/30insertfetch.....dubious
    Test returned status 10 (wstat 2560, 0xa00)
    DIED. FAILED tests 1-11
    Failed 11/11 tests, 0.00% okay
    t/40bindparam.......DBI-&connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/40bindparam.t line 64
    Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
    Either your server is not up and running or you have no
    permissions for acessing the DSN DBI:mysql:test.
    This test requires a running server and write permissions.
    Please make sure your server is running and you have
    permissions, then retry.
    t/40bindparam.......dubious
    Test returned status 10 (wstat 2560, 0xa00)
    DIED. FAILED tests 1-28
    Failed 28/28 tests, 0.00% okay
    t/40blobs...........DBI-&connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/40blobs.t line 68
    Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
    Either your server is not up and running or you have no
    permissions for acessing the DSN DBI:mysql:test.
    This test requires a running server and write permissions.
    Please make sure your server is running and you have
    permissions, then retry.
    t/40blobs...........dubious
    Test returned status 10 (wstat 2560, 0xa00)
    DIED. FAILED tests 1-11
    Failed 11/11 tests, 0.00% okay
    t/40listfields......DBI-&connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/40listfields.t line 57
    Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
    Either your server is not up and running or you have no
    permissions for acessing the DSN DBI:mysql:test.
    This test requires a running server and write permissions.
    Please make sure your server is running and you have
    permissions, then retry.
    t/40listfields......dubious
    Test returned status 10 (wstat 2560, 0xa00)
    DIED. FAILED tests 1-16
    Failed 16/16 tests, 0.00% okay
    t/40nulls...........DBI-&connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/40nulls.t line 50
    Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
    Either your server is not up and running or you have no
    permissions for acessing the DSN DBI:mysql:test.
    This test requires a running server and write permissions.
    Please make sure your server is running and you have
    permissions, then retry.
    t/40nulls...........dubious
    Test returned status 10 (wstat 2560, 0xa00)
    DIED. FAILED tests 1-11
    Failed 11/11 tests, 0.00% okay
    t/40numrows.........DBI-&connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/40numrows.t line 59
    Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
    Either your server is not up and running or you have no
    permissions for acessing the DSN DBI:mysql:test.
    This test requires a running server and write permissions.
    Please make sure your server is running and you have
    permissions, then retry.
    t/40numrows.........dubious
    Test returned status 10 (wstat 2560, 0xa00)
    DIED. FAILED tests 1-25
    Failed 25/25 tests, 0.00% okay
    t/50chopblanks......DBI-&connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/50chopblanks.t line 57
    Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
    Either your server is not up and running or you have no
    permissions for acessing the DSN DBI:mysql:test.
    This test requires a running server and write permissions.
    Please make sure your server is running and you have
    permissions, then retry.
    t/50chopblanks......dubious
    Test returned status 10 (wstat 2560, 0xa00)
    DIED. FAILED tests 1-35
    Failed 35/35 tests, 0.00% okay
    t/50commit..........DBI-&connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/50commit.t line 64
    Can't call method &tables& on an undefined value at t/lib.pl line 216.
    t/50commit..........dubious
    Test returned status 255 (wstat 65280, 0xff00)
    DIED. FAILED tests 1-30
    Failed 30/30 tests, 0.00% okay
    t/60leaks...........skipped test on this platform
    t/ak-dbd............DBI-&connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/ak-dbd.t line 59
    t/ak-dbd............ok 3/90Can't call method &tables& on an undefined value at t/lib.pl line 216.
    t/ak-dbd............dubious
    Test returned status 255 (wstat 65280, 0xff00)
    DIED. FAILED tests 1, 4-90
    Failed 88/90 tests, 2.22% okay
    t/akmisc............Mysql-&connect(database=test;host=) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/akmisc.t line 140
    t/akmisc............NOK 1Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
    It looks as if your server is not up and running.
    This test requires a running server.
    Please make sure your server is running and retry.
    t/akmisc............dubious
    Test returned status 10 (wstat 2560, 0xa00)
    DIED. FAILED tests 1-351
    Failed 351/351 tests, 0.00% okay
    t/dbdadmin..........DBI-&connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/dbdadmin.t line 74
    t/dbdadmin..........NOK 1Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
    Either your server is not up and running or you have no
    permissions for acessing the DSN DBI:mysql:test.
    This test requires a running server and write permissions.
    Please make sure your server is running and you have
    permissions, then retry.
    t/dbdadmin..........dubious
    Test returned status 10 (wstat 2560, 0xa00)
    DIED. FAILED tests 1-20
    Failed 20/20 tests, 0.00% okay
    t/insertid..........DBI-&connect(test) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/insertid.t line 13
    t/insertid..........dubious
    Test returned status 255 (wstat 65280, 0xff00)
    DIED. FAILED tests 1-12
    Failed 12/12 tests, 0.00% okay
    t/mysql.............Mysql-&connect(database=test;host=) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/mysql.t line 55
    not ok 1: Access denied for user: 'root@localhost' (Using password: NO)
    It looks as if your server is not up and running.
    This test requires a running server.
    Please make sure your server is running and retry.
    t/mysql.............FAILED tests 1-68
    Failed 68/68 tests, 0.00% okay
    t/mysql2............Mysql-&connect(database=test;host=) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/mysql2.t line 29
    Can't call method &getserverinfo& on an undefined value at t/mysql2.t line 30.
    t/mysql2............dubious
    Test returned status 255 (wstat 65280, 0xff00)
    Failed Test Status Wstat Total Fail Failed List of Failed
    --------------------------------------------------------------------------------
    t/10dsnlist.t 10 2560 9 9 100.00% 1-9
    t/20createdrop.t 10 2560 5 5 100.00% 1-5
    t/30insertfetch.t 10 2560 11 11 100.00% 1-11
    t/40bindparam.t 10 2560 28 28 100.00% 1-28
    t/40blobs.t 10 2560 11 11 100.00% 1-11
    t/40listfields.t 10 2560 16 16 100.00% 1-16
    t/40nulls.t 10 2560 11 11 100.00% 1-11
    t/40numrows.t 10 2560 25 25 100.00% 1-25
    t/50chopblanks.t 10 2560 35 35 100.00% 1-35
    t/50commit.t 255 65280 30 30 100.00% 1-30
    t/ak-dbd.t 255 65280 90 88 97.78% 1, 4-90
    t/akmisc.t 10 2560 351 351 100.00% 1-351
    t/dbdadmin.t 10 2560 20 20 100.00% 1-20
    t/insertid.t 255 65280 12 12 100.00% 1-12
    t/mysql.t 68 68 100.00% 1-68
    t/mysql2.t 255 65280 ?? ?? % ??
    1 test skipped.
    Failed 16/18 test scripts, 11.11% okay. 720/727 subtests failed, 0.96% okay.
    make: *** [test_dynamic] Error 2

    ------end make test ---------
     
  8. carperman

    carperman Well-Known Member

    Joined:
    Feb 7, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    sorted i ran ./installdbi
     
  9. rodstewart

    rodstewart Active Member

    Joined:
    Feb 4, 2004
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Hamburg Germany
    cPanel Access Level:
    DataCenter Provider
Loading...

Share This Page