apache unixodbc and php - segmentation fault

Issues related to software problems
Post Reply
p-banholzer
Posts: 2
Joined: 2005/05/23 15:44:19

apache unixodbc and php - segmentation fault

Post by p-banholzer » 2005/05/25 06:41:39

Hi all,

sorry, I put this topic into CentOS 3 forum ... and should be in this one.

connecting with php ( odbc_connect ) a Pervasive database through unixODBC on a redhat 7.2.
worked really fine since ... I installed a EL4.

my /etc/odbc.ini : (a soft link : odbc.ini -> /usr/local/psql/etc/odbc.ini)
[ODBC Data Sources]
fermatdbmunch=Pervasive ODBC Client Interface
PostgreSQL-dbmunch=PostgreSQL ODBC Client Interface

[fermatdbmunch]
Driver=/usr/local/psql/lib/odbcci.so
Description=Pervasive ODBC Client Interface: fermat:1583/dbmunch
ServerDSN=dbmunch
ServerName=fermat:1583
UID=
PWD=

[PostgreSQL-dbmunch]
Description=PostgreSQL DSN
Driver=PostgreSQL
Trace=No
TraceFile=/var/log/odbc.log
Database=dbmunch
Servername=localhost
UID=
PWD=
UserName=postgres
Password=postgres
Port=5432
Protocol=6.4
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ShowOidColumn=No
FakeOidIndex=No
ConnSettings=

isql is working fine with both databases
also odbctest (given with the Pervasive client) as user psql (the
Pervasive user) for the Pervasive database

but with php,
as it is working fine on the Postgresql database
with the Pervasive one :
i have at each php script call a "[notice] child pid 11028 exit signal
Segmentation fault (11)" in the httpd error_log.

my php script :

if($conn_gestion=odbc_connect("PostgreSQL-dbmunch","postgres","postgres",SQL_CUR_USE_DRIVER))
{
odbc_close($conn_gestion);
}
else{
echo "no connection !!!";
}

if($conn_gestion=odbc_connect("fermatdbmunch","psql","psql",SQL_CUR_USE_DRIVER))
{
odbc_close($conn_gestion);
}
else{
echo "no connection !!!";
}

I've seen that, as written in
http://www.phpbuilder.com/columns/alberto20000919.php3?aid=109&print_mode=1
this segmentation fault should come from a thread compile option.

In that case, I don't understand why it works with the Postgresql driver.
Is it possible it comes from user rights ?
I've tried to compile unixODBC with the option describe in the previous link but without success

my rpms :
unixODBC-2.2.9-1
httpd-2.0.52-9.ent.centos4.1
php-4.3.9-3.6
php-odbc-4.3.9-3.6

Thank you.
Philippe.

p-banholzer
Posts: 2
Joined: 2005/05/23 15:44:19

Re: apache unixodbc and php - segmentation fault

Post by p-banholzer » 2005/06/01 11:47:14

the Pervasive client rpm was a most recent version than the database one ... strange.

Post Reply

Return to “CentOS 4 - Software Support”