Thread: PHP5-Sybase - MSSQL_CONNECT()

hey guys.


have following problem , need fast fix.

did install "php5-mssql" on server start running cronjobs phpcli working fine until 1 day.


cronjob kept failing errors php library not loaded. narrowed down mssql. uninstalled packed using: sudo apt-get remove php5-mssql

restart apache: /etc/init.d/apache2 restart

ran installation of php5-mssql again.

root@bravosl:~# sudo apt-get install php5-mssql
reading package lists... done
building dependency tree
reading state information... done
note, selecting 'php5-sybase' instead of 'php5-mssql'
following packages automatically installed , no longer required:
gamin bind9utils libdns66 maildrop libisccc60 geoip-database libgamin0
sensible-mda courier-ssl liblwres60 expect courier-base libbind9-60
courier-authlib-userdb courier-authlib tcl8.5 libgeoip1 libisccfg60 libisc60
courier-authdaemon
use 'apt-get autoremove' remove them.
following new packages installed:
php5-sybase
0 upgraded, 1 newly installed, 0 remove , 0 not upgraded.
need 0b/23.2kb of archives.
after operation, 123kb of additional disk space used.
selecting deselected package php5-sybase.
(reading database ... 21571 files , directories installed.)
unpacking php5-sybase (from .../php5-sybase_5.3.3-1ubuntu9.10_i386.deb) ...
processing triggers libapache2-mod-php5 ...
* reloading web server config apache2 [wed sep 26 21:34:04 2012] [warn] alias directive in /etc/phpmyadmin/apache.conf @ line 3 never match because overlaps earlier alias.
[ ok ]
setting php5-sybase (5.3.3-1ubuntu9.10) ...
root@bravosl:~#

ever since then, have noticed php5-sybase gets installed without functions looking (mssql_connect)


have collected following logs share:

root@bravosl:~#dmesg
179921.031720] php[19676]: segfault @ ff ip b6b9836a sp bfa6c150 error 6 in ms sql.so[b6b94000+9000]
[179981.135023] php[19684]: segfault @ ff ip b6b6836a sp bf9eb290 error 6 in ms sql.so[b6b64000+9000]

root@bravosl:~#cat /var/log/apache2/error.log | grep mssql
[tue sep 25 16:47:21 2012] [error] [client 109.170.137.202] php fatal error: call undefined function mssql_connect() in /var/www/mssql.php on line 8, referer: http://www.nightsfall-online.com/index.php
[tue sep 25 17:20:16 2012] [error] [client 109.170.137.202] php fatal error: call undefined function mssql_connect() in /var/www/mssql.php on line 8
[tue sep 25 20:05:13 2012] [error] [client 94.168.105.102] php fatal error: call undefined function mssql_connect() in /var/www/mssql.php on line 8
[tue sep 25 20:35:34 2012] [error] [client 94.168.105.102] php fatal error: call undefined function mssql_connect() in /var/www/mssql.php on line 8
root@bravosl:~#

i have checked functions of mssql_connect exist using standard php script check present functions. not present.

question asking, how mssql extension work again

i don't have ubuntu server running php @ moment check, i'm pretty sure need tell php load modules sybase command-line executable. root around in /etc/php5 , see find. there should files load .so files contain additional modules. may need clone 1 in /etc/php5/apache2 works command-line executable well.

create file called info.php single line "<?php phpinfo() ?>" , run command-line executable. see sybase modules loaded there? if access same file through apache?

Forum The Ubuntu Forum Community Ubuntu Specialised Support Ubuntu Servers, Cloud and Juju Server Platforms [ubuntu] PHP5-Sybase - MSSQL_CONNECT()

Ubuntu