PHP request_startup() for sqlanywhere module failed in Unknown on line 0

alunrowe — Sun, 17 May 2020 18:06:02 GMT

Hi All

I have done the following but get the PHP request_startup() for sqlanywhere module failed in Unknown on line 0 error:

FROM https://wiki.scn.sap.com/wiki/display/SQLANY/SAP+SQL+Anywhere+Database+Client+Download

wget http://d5d4ifzqzkhwt.cloudfront.net/sqla17client/sqla17_client_linux_x86x64.tar.gz
tar -zxvf /opt/sqlanywhere17/installation/sqla17_client_linux_x86x64.tar.gz -C /opt/sqlanywhere17/installation
/opt/sqlanywhere17/installation/sqlany17/setup
rm -rf /opt/sqlanywhere17/installation

Then get the client from https://wiki.scn.sap.com/wiki/display/SQLANY/The+SAP+SQL+Anywhere+PHP+Module

wget http://d5d4ifzqzkhwt.cloudfront.net/drivers/php/SQLAnywhere-php-7.3_Linux.tar.gz 
tar -xzf SQLAnywhere-php-7.3_Linux.tar.gz

I've then copied the lib64 folder to /etc/SQLAnywhere/php73/lib64

I've added the extension to a file called sqlanywhere.ini in my conf.d folder: extension=/etc/SQLAnywhere/php73/lib64/php-7.3.0_sqlanywhere.so

I created a file called sqlanywhere.conf in /etc/ld.so.conf.d containing:

/opt/sqlanywhere17/lib64

And ran ldconfig

If I run "ldconfig -v" it shows all the various lib64 files for sqlanywhere

And then I restart the server and I get the "PHP request_startup() for sqlanywhere module failed in Unknown on line 0" error in my error logs

I've go this far but am absolutely stumped! Permissions? Apache not seeing the LDCONFIG? I'm really stuck and need to get a new server up asap! Any help appreciated!!

BTW I found this elsewhere on the forum but have no idea what file I would put this directive into

Adding: Environment=LD_LIBRARY_PATH=/opt/sqlanywhere17/lib64 at the beginning of [Service] section in the httpd.service file solved the problem in my case.

Re: PHP request_startup() for sqlanywhere module failed in Unknown on line 0

alunrowe — Sun, 17 May 2020 18:08:28 GMT

BTW I am using Serverpilot for managing my server. These docs show how config needs to be done.

https://serverpilot.io/docs/customize-php-settings/

Re: PHP request_startup() for sqlanywhere module failed in Unknown on line 0

alunrowe — Sun, 17 May 2020 18:13:20 GMT

Also my database is on a remote machine so no need for running databases on this Linux install just the client.

Re: PHP request_startup() for sqlanywhere module failed in Unknown on line 0

Former Member — Mon, 18 May 2020 08:58:30 GMT

Are you running php7.2-fpm? I had this problem and fixed it by adding the line

env[SQLANY17]=/opt/sqlanywhere17

to the file

/etc/php/7.2/fpm/pool.d/www.conf

(This was not required for sa 17.0.9.xxx)

Question Re: PHP request_startup() for sqlanywhere module failed in Unknown on line 0 in Technology Q&A

PHP request_startup() for sqlanywhere module failed in Unknown on line 0

Re: PHP request_startup() for sqlanywhere module failed in Unknown on line 0

Re: PHP request_startup() for sqlanywhere module failed in Unknown on line 0

Re: PHP request_startup() for sqlanywhere module failed in Unknown on line 0