0000546: php mysqli crashes searchd

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0000546

[Sphinx] general

crash

always

2010-07-02 19:06

2010-08-04 21:44

Reporter

marstonstudio

View Status

public

Assigned To

shodan

Priority

normal

Resolution

unable to reproduce

Status

resolved

Product Version

0.9.9-rc2

Summary

0000546: php mysqli crashes searchd

Description

The windows version of the searchd service crashes for me when i try to connect using php
mysqli. The old school php mysql connector appears to work, but I'm using the zend
framework and need to connect using mysqli. Any guidance on the configuration would be
appreciated, but based on my testing it appears to be a bug. I've got a test php script
here and I can offer my installation and test matrix details

script

<?php

error_reporting(E_ALL);
ini_set('display_errors','On');

$host = '127.0.0.1';
$username = '';
$password = '';
$dbname = '';
$port = 9306;

echo '

mysql_connect test

';
$db = mysql_connect("$host:$port", $username, $password);
$result = mysql_query('SHOW STATUS', $db);
while ($row = mysql_fetch_row($result)) {
echo $row[0] . ' : ' . $row[1] . '
';
}

echo '

mysqli test

';
$dbi = mysqli_init();
if(mysqli_real_connect($dbi, $host, $username, $password, $dbname, $port)) {
        $resulti = mysqli_query($dbi, 'SHOW STATUS');
        while ($rowi = mysqli_fetch_row($resulti)) {
                echo $rowi[0] . ' : ' . $rowi[1] . '
';
        }
} else {
        echo mysqli_error($dbi);
}

?>

I did my testing using a mac and windows machine each with the out of the box
sphinx.conf.min set up. I used the Zend Server distribution of apache/php 5.3, but saw
similar results using XAMPP.

on the windows machine:
- mysql -P 9306 connects to searchd on windows and mac host and can run queries
- php test script can connect to searchd on windows host using mysql php connector and
execute queries
- php test script can NOT connect to searchd on windows using mysqli php connector.
searchd crashes and cannot be restarted through services console
- php test script can connect to searchd on mac host using both mysql and mysqli
connector and execute queries

on the mac machine
- mysql -P 9306 connects to searchd on windows and mac host and can run queries
- php test script can connect to searchd on windows host using mysql php connector and
execute queries
- php test script can NOT connect to searchd on windows using mysqli php connector.
searchd crashes and cannot be restarted through services console
- php test script can connect to searchd on mac host using both mysql and mysqli
connector and execute queries

i don't see anything about crashes in either the searchd or apache logs.

Additional Information

Notes
(0000809) marstonstudio (reporter) 2010-07-24 04:26	tested on windows on 1.10-beta, works fine now.

(0000824) shodan (administrator) 2010-08-04 21:44	mysqli path worked for me using both 0.9.9-release and 1.10-beta on Windows.

Issue History
Date Modified	Username	Field	Change
2010-07-02 19:06	marstonstudio	New Issue
2010-07-24 04:26	marstonstudio	Note Added: 0000809
2010-08-04 21:44	shodan	Note Added: 0000824
2010-08-04 21:44	shodan	Status	new => resolved
2010-08-04 21:44	shodan	Resolution	open => unable to reproduce
2010-08-04 21:44	shodan	Assigned To	=> shodan

Relationships