Новости
Документация
Download
Webboard
Поиск
FAQ/ЧаВо
Обратная связь




MySQL.RU - Webboard



Вернуться
DBD:Mysql - Install HEELP! (Алексей) 12/02/2005 - 19:37:03
      Re: DBD:Mysql - Install HEELP! (FanTom) 22/02/2005 - 11:06:43

> Original message text:
> From: Алексей - 12/02/2005 - 19:37:03
> Subject:DBD:Mysql - Install HEELP!
> -----------------
> Никак не могу установить DBD:Mysql на Fedora 2. DBI установился нормально, а вот DBD никак не хочет
>
> HEEEELP!
>
> Скачал DBD-mysql-2.9004, распаковал...
> Пишу perl Makefile.PL ответ:
>
> -------------------------
> I will use the following settings for compiling and testing:
>
> cflags (mysql_config) = -I/usr/local/mysql/include/mysql
> libs (mysql_config) = -L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
> nocatchstderr (default ) = 0
> nofoundrows (default ) = 0
> ssl (guessed ) = 0
> testdb (default ) = test
> testhost (default ) =
> testpassword (default ) =
> testuser (default ) =
>
> To change these settings, see 'perl Makefile.PL --help' and
> 'perldoc INSTALL'.
>
> Using DBI 1.40 (for perl 5.008003 on i386-linux-thread-multi) installed in /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBI
> Writing Makefile for DBD::mysql
> -------------------------
>
> Вродь все ок... Далее пишу make ответ:
>
> -------------------------
> gcc -c -I/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBI -I/usr/local/mysql/include/mysql -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -march=i386 -mcpu=i686 -DVERSION=\"2.9004\" -DXS_VERSION=\"2.9004\" -fPIC "-I/usr/lib/perl5/5.8.3/i386-linux-thread-multi/CORE" dbdimp.c
> gcc -c -I/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBI -I/usr/local/mysql/include/mysql -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -march=i386 -mcpu=i686 -DVERSION=\"2.9004\" -DXS_VERSION=\"2.9004\" -fPIC "-I/usr/lib/perl5/5.8.3/i386-linux-thread-multi/CORE" mysql.c
> Running Mkbootstrap for DBD::mysql ()
> chmod 644 mysql.bs
> rm -f blib/arch/auto/DBD/mysql/mysql.so
> /usr/bin/perl myld gcc -shared -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
> chmod 755 blib/arch/auto/DBD/mysql/mysql.so
> cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
> chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
> Manifying blib/man3/DBD::mysql.3pm
> Manifying blib/man3/DBD::mysql::INSTALL.3pm
> Manifying blib/man3/Mysql.3pm
> Manifying blib/man3/Bundle::DBD::mysql.3pm
> -------------------------
>
> Вродь тоже все ок, далее пишу make test ответ:
>
> -------------------------
> PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> t/00base...........install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/00base.t line 38
> t/00base...........dubious
> Test returned status 255 (wstat 65280, 0xff00)
> Scalar found where operator expected at (eval 152) line 1, near "'int' $__val"
> (Missing operator before $__val?)
> DIED. FAILED tests 4-5
> Failed 2/5 tests, 60.00% okay
> t/10dsnlist........install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/10dsnlist.t line 45
> t/10dsnlist........dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-9
> Failed 9/9 tests, 0.00% okay
> t/20createdrop.....install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/20createdrop.t line 45
> t/20createdrop.....dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-5
> Failed 5/5 tests, 0.00% okay
> t/30insertfetch....install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/30insertfetch.t line 48
> t/30insertfetch....dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-11
> Failed 11/11 tests, 0.00% okay
> t/40bindparam......install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 3) line 3
> Compilation failed in require at (eval 3) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/40bindparam.t line 64
> t/40bindparam......dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-28
> Failed 28/28 tests, 0.00% okay
> t/40blobs..........install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/40blobs.t line 68
> t/40blobs..........dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-11
> Failed 11/11 tests, 0.00% okay
> t/40listfields.....install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/40listfields.t line 57
> t/40listfields.....dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-18
> Failed 18/18 tests, 0.00% okay
> t/40nulls..........install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/40nulls.t line 50
> t/40nulls..........dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-11
> Failed 11/11 tests, 0.00% okay
> t/40numrows........install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/40numrows.t line 59
> t/40numrows........dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-25
> Failed 25/25 tests, 0.00% okay
> t/50chopblanks.....install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/50chopblanks.t line 57
> t/50chopblanks.....dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-35
> Failed 35/35 tests, 0.00% okay
> t/50commit.........install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/50commit.t line 64
> 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
> all skipped: $ENV{SLOW_TESTS} is not set or Proc::ProcessTable not installed
> t/ak-dbd...........install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/ak-dbd.t line 59
> t/ak-dbd...........dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-90
> Failed 90/90 tests, 0.00% okay
> t/akmisc...........Had to create DBD::mysql::dr::imp_data_size unexpectedly at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 1063.
> Use of uninitialized value in subroutine entry at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 1063.
> Can't locate object method "connect" via package "Mysql" at /-/DBD-mysql-2.9004/blib/lib/Mysql.pm line 71.
> t/akmisc...........dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-351
> Failed 351/351 tests, 0.00% okay
> t/dbdadmin.........install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/dbdadmin.t line 74
> t/dbdadmin.........dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-21
> Failed 21/21 tests, 0.00% okay
> t/insertid.........install_driver(mysql) failed: Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> 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............Can't load '/-/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at /-/DBD-mysql-2.9004/blib/lib/Mysql.pm line 13
> Compilation failed in require at /-/DBD-mysql-2.9004/blib/lib/Mysql.pm line 13.
> Compilation failed in require at t/mysql.t line 34.
> BEGIN failed--compilation aborted at t/mysql.t line 34.
> t/mysql............dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-68
> Failed 68/68 tests, 0.00% okay
> t/mysql2...........Had to create DBD::mysql::dr::imp_data_size unexpectedly at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 1063.
> Use of uninitialized value in subroutine entry at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 1063.
> Can't locate object method "connect" via package "Mysql" at /-/DBD-mysql-2.9004/blib/lib/Mysql.pm line 71.
> t/mysql2...........dubious
> Test returned status 255 (wstat 65280, 0xff00)
> Failed Test Stat Wstat Total Fail Failed List of Failed
> -------------------------------------------------------------------------------
> t/00base.t 255 65280 5 4 80.00% 4-5
> t/10dsnlist.t 255 65280 9 18 200.00% 1-9
> t/20createdrop.t 255 65280 5 10 200.00% 1-5
> t/30insertfetch.t 255 65280 11 22 200.00% 1-11
> t/40bindparam.t 255 65280 28 56 200.00% 1-28
> t/40blobs.t 255 65280 11 22 200.00% 1-11
> t/40listfields.t 255 65280 18 36 200.00% 1-18
> t/40nulls.t 255 65280 11 22 200.00% 1-11
> t/40numrows.t 255 65280 25 50 200.00% 1-25
> t/50chopblanks.t 255 65280 35 70 200.00% 1-35
> t/50commit.t 255 65280 30 60 200.00% 1-30
> t/ak-dbd.t 255 65280 90 180 200.00% 1-90
> t/akmisc.t 255 65280 351 702 200.00% 1-351
> t/dbdadmin.t 255 65280 21 42 200.00% 1-21
> t/insertid.t 255 65280 12 24 200.00% 1-12
> t/mysql.t 255 65280 68 136 200.00% 1-68
> t/mysql2.t 255 65280 ?? ?? % ??
> 1 test skipped.
> Failed 17/18 test scripts, 5.56% okay. 727/730 subtests failed, 0.41% okay.
> make: *** [test_dynamic] Îøèáêà 255
> -------------------------
>
> А вот тут не все впорядке! HEEELP!
> Может кто сталкивался с таким? Надеюсь на помощь.
>
>


From: FanTom - 22/02/2005 - 11:06:43
Subject:DBD:Mysql - Install HEELP!
-----------------
Мучился той же проблемой довольно долго.В инете ответа на этот вопрос не смог найти. Короче.
Видимо в системе остались хвосты от предыдущей (родной) базы.
Обнаружить их можно в /usr/bin
Если система Fedora, то в X-ах есть утилита установки/удаления приложений. Снеси все что касается MYSQL. Твою базу установленную в /usr/local/mysql это не затронет
Для проверки попробуй запустить
#mysql_config
в ответ получишь что нет файла или директории
далее
#export PATH=$PATH:/usr/local/mysql/bin
снова
#mysql_config
Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
Options:
--cflags [-I/usr/local/mysql/include/mysql]
--include [-I/usr/local/mysql/include/mysql]
--libs [-L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm]
--libs_r [-L/usr/local/mysql/lib/mysql -lmysqlclient_r -lpthread -lz -lcrypt -lnsl -lm -lpthread]
--socket [/tmp/mysql.sock]
--port [3306]
--version [4.0.20]
--libmysqld-libs [-L/usr/local/mysql/lib/mysql -lmysqld -lpthread -lz -lcrypt -lnsl -lm -lpthread -lrt]

Дело в том что инсталяция BDB::mysql пользует этот скрипт и установка переменных при запуске Makefile.PL при наличии хвостов старой базы бесполезное занятие
Ессно не забываем перед этим
#export LANG='C'
Использовал Mysql-4.0.20 из исходников, пароль не ставил и базу "test" не убивал
DBI-1.47
DBD-mysql-2.9005_3
Все это проверил на системе RedHatInterprise AS3 (на Fedora3 все аналогично)


[Это сообщение - спам!]

Последние сообщения из форума

Уважаемые посетители форума MySQL.RU!
Убедительная просьба, прежде чем задавать свой вопрос в этом форуме, обратите внимание на разделы:
- ответы на наиболее часто задаваемые вопросы - FAQ
- раздел документация
- раздел поиск по сообщениям форума и документации
Также, старайтесь наиболее подробно указывать свою ситуацию (версию операционной системы, версию MySQL, версию программного обеспечения, по которому возникает вопрос, текст возникающих ошибок, и др.)
Помните, чем конкретнее Вы опишете ситуацию, тем больше шансов получить реальную помощь.
 Имя:
 E-mail:
 Тема:
 Текст:
Код подтверждения отправки: Code
20273



РЕКЛАМА НА САЙТЕ
  Создание сайтов | |