Command Line PHP Mysql Connection Core dump

[rb512c]

Hello. I am hoping someone here can help me out.

I have a new machine (ultra 60 solaris 8) that is running php 4.2.3 and mysql 3.23.52.

If I run a simple mysql_connect to the database through apache (web page) it works just fine. But if I run the same file with the command line php, I get a:
Segmentation Fault(coredump)

If I gdb the core file I find that it failed in read_charset_index () if I truss the program, I see the same thing:

open64("/usr/local/mysql/share/mysql/charsets/Index", O_RDONLY) = 6
Incurred fault #6, FLTBOUNDS %pc = 0x000F535C
siginfo: SIGSEGV SEGV_MAPERR addr=0x00000008
Received signal #11, SIGSEGV [default]
siginfo: SIGSEGV SEGV_MAPERR addr=0x00000008
process killed

So now I know where the problem is...but not what to do about it.

Any advice would be greatly appreciated.

Jason

[jweissig]

can you show me the code that you are attempting to run on the command line?

• Justin

[rb512c]

This is just a REALLY dumbed down connect to the mysql database. Just to make sure that it works.

<?

  $lnk = mysql_connect("localhost","root","");
  if ($lnk) {
    mysql_select_db("mysql",$lnk);
    $rst = mysql_query("select user from user");
    if ($rst) {
      while($row=mysql_fetch_row($rst)) {

echo "$row[0]\n";
}
}
} else {
echo "<b>Error connecting to server.</b>\n";
}
?>

[jweissig]

hi,

you had a } in the wrong place.. try this.

<? 

$lnk = mysql_connect("localhost","root",""); 

if ($lnk) {
	mysql_select_db("mysql",$lnk);
	$rst = mysql_query("select user from user");

if ($rst) {
	while($row=mysql_fetch_row($rst)) {
		echo "$row[0]\n";
	}
} else {
	echo "<b>Error connecting to server.</b>\n";
}
}

?>

[jweissig]

hi,

you also need to use the -q switch at commend line.. something like this /usr/local/bin/php -q db_connect_tmp.php

[rb512c]

I see the } problem now. But that just changed the Error statement. It still just Seg Faults.

As I said. The strange this is that it will run just fine if I access the same page through a web browser. The compile options for the command line are identical to the ones for the apache module except for taking out
--with-apxs=/usr/local/apache/bin/apxs

[rb512c]

no help with -q or -fq 🙁 still get a Seg Fault in read_charset_index ()

[rb512c]

Ok...got some feedback from the folks over at PHP.net.

They pointed out that the issues was with the charset...which we already knew. But they also told me that php has its own embedded libmysql.

That just means building it without the --with-mysql. I did so and I am up and running. Thanks Georg!!!

Here is the configure command in case anyone needs it.

./configure --enable-track-vars --disable-force-cgi-redirect --with-ldap\
--enable-discard-path --with-gd=/usr/local --with-zlib=/usr/local \
--with-png-dir=/usr/local --with-jpeg-dir=/usr/localk