Roman> I just installed the latest mysql-3.22.23b-sun-sunos4.1.4-sparc Roman> binary distribution, then DBI-1.11 and now Msql-Mysql-modules-1.2200.

Roman> Running a Perl script that connects to mysqld crashes Perl 5.00404 Roman> (this is all under SunOS 4.1.4), for example here is dbimon:

csh> dbx /usr/bin/perl

Roman> (dbx) run /usr/local/bin/dbimon dbi:mysql:test username password

Roman> Running: /usr/bin/perl /usr/local/bin/dbimon dbi:mysql:test username
password Roman> Can't open trace file : No such file or directory DBI 1.11-nothread
dispatch trace level set to 2 Roman> Note: perl is running without the recommended perl -w option -> DBI->connect(dbi:mysql:test, username, password) -> DBI->install_driver(mysql) for perl=5.00404 pid=14174 ruid=1611 euid=1611 Roman> install_driver: DBD::mysql loaded (version 2.0400) Roman> <- install_driver= DBI::dr=HASH(0x179a60) -> connect for DBD::mysql::dr (DBI::dr=HASH(0x179a60)~0x2eec68 'test' 'username'
'password' HASH(0x2a805c)) imp_dbh-> connect: dsn = test, uid = username, pwd = password imp_dbh-> MyLogin: dbname = test, uid = username, pwd = password,host = NULL,
port = NULL imp_dbh-> MyConnect: host = NULL, port = 0, uid = username, pwd = password Roman> signal SEGV (segmentation violation) in etext at 0xef7276d4 Roman> etext-0x10978aa4: ld [%i0 + 428], %o1

Roman> (dbx) where Roman> etext() at 0xef7276d4 Roman> etext() at 0xef71d0f4 Roman> etext() at 0xef71d60c Roman> etext() at 0xef71d68c Roman> etext() at 0xef7226a4 Roman> Perl_pp_entersub() at 0x4123c Roman> Perl_runops() at 0x3b518 Roman> perl_call_sv() at 0x59d4 Roman> etext() at 0xef748ccc Roman> Perl_pp_entersub() at 0x4123c Roman> Perl_runops() at 0x3b518 Roman> perl_run() at 0x4eec Roman> main() at 0x2334

Roman> I compiled DBD:mysql with acc, Sun's old ANSI compiler (for the only Roman> reason that this compiler was used a few year ago to compile Perl itself, Roman> so I am pretty much stick with it).

Roman> There was one glitch when I compiled the module. mysql/include/mysql.h Roman> contains a use of "long long", which this compiler does not understand. Roman> After adding the switch -DNO_CLIENT_LONG_LONG to the Makefile, the Roman> module compiled fine, but everytime DBI->connect("dbi:mysql:....") is Roman> invoked, Perl silently segfaults.

Roman> Does anyone have any ideas or suggestions? The mysql server and the Roman> precompiled binaries such as mysql, mysqladmin etc. themselves work fine, Roman> so it looks like something in the C code of DBD:mysql.

Roman> Roman Maeder

Hi!

Note that if you are using a binary MySQL distribution which is compiled with a compiler that has longlong, the above -DNO_CLIENT_LONG_LONG will crash your client!

You have to:

a) Recompile the mysql client library with your current compiler

or

b) Recompile the modules with gcc.

Regards, Monty