Re: [PHP] undef func - any more clues ?

On 5/13/2013 11:32 PM, georg wrote:
> Thanks !
>
> yum install php-odbc really did the trick.
>
> Now Im stuck where connect gives an error in apache error_log
> that it cannot find file /lib/libmimerodbc.so  which is evidently there
> in exactly that place (as given in odbcini.ini for driver definition) !
> A bit unexpected. (possibly an error in errorhandling ?, i.e. other cause)

So, the file /lib/libmimerodbc.so exists?  If it does and Apache cannot 
access it, then it might be permissions.  Make sure it is readable by 
httpd.  And that your httpd is not setup in a chroot environment.

>
> /georg
>
> ----- Original Message ----- From: "Jim Lucas" <[email protected]>
> To: "georg" <[email protected]>
> Cc: <[email protected]>; <[email protected]>
> Sent: Tuesday, May 14, 2013 3:25 AM
> Subject: Re: [PHP] undef func - any more clues ?
>
>
>> On 05/12/2013 10:34 AM, georg wrote:
>>> Hi
>>> Im not really following, I have done:
>>> pecl list-all ; but dont find anything that has to do with ODBC
>>>
>>> so still stuck with Apache error log saying : no such function (or eqiv
>>> speak) odbc_connect()
>>> tnx
>>> Georg
>>
>>
>> I am using a CentOS 6.4 system as a work station.  So, with that said,
>> the systems are similar, but still different enough that you need to
>> make a few changes regarding the package names to get things working.
>>
>> I also have Apache installed the I develop with.  These are the steps
>> that I performed, and the order I performed them in, to get odbc
>> working at the CLI and with Apache.
>>
>> Here first is an example of what I got when trying to call
>> odbc_connect() without the proper packages installed from the CLI.
>>
>> [root@jim ~]# php -r "odbc_connect();"
>> PHP Fatal error:  Call to undefined function odbc_connect() in Command
>> line code on line 1
>>
>> Fatal error: Call to undefined function odbc_connect() in Command line
>> code on line 1
>>
>>
>> Search for the correct package.
>> [root@jim ~]$ yum list php* | grep -i odbc
>> php-odbc.x86_64                      5.3.3-22.el6         base
>>
>> Install found package... (change the package name if needed)
>> [root@jim ~]# yum install php-odbc
>>
>> ...
>>
>> Total download size: 428 k
>> Installed size: 1.2 M
>> Is this ok [y/N]: y
>>
>> ...
>>
>> Running Transaction
>>   Installing : unixODBC-2.2.14-12.el6_3.x86_64               1/2
>>   Installing : php-odbc-5.3.3-22.el6.x86_64                  2/2
>>   Verifying  : php-odbc-5.3.3-22.el6.x86_64                  1/2
>>   Verifying  : unixODBC-2.2.14-12.el6_3.x86_64               2/2
>>
>> Installed:
>>   php-odbc.x86_64 0:5.3.3-22.el6
>>
>> Dependency Installed:
>>   unixODBC.x86_64 0:2.2.14-12.el6_3
>>
>> Complete!
>>
>> Update your locate database
>> [root@jim ~]# updatedb
>>
>> Search for the recently installed package
>> [root@jim ~]# locate odbc.so | grep php
>> /usr/lib64/php/modules/odbc.so
>> /usr/lib64/php/modules/pdo_odbc.so
>>
>> Re-run the first test - ah it is found...
>> [root@jim ~]# php -r "odbc_connect();"
>> PHP Warning:  odbc_connect() expects at least 3 parameters, 0 given in
>> Command line code on line 1
>>
>> Warning: odbc_connect() expects at least 3 parameters, 0 given in
>> Command line code on line 1
>>
>>
>> Once you have this, you know that everything in place to get it
>> working with Apache.
>>
>> Now to test in the web server.  This is what I received when I viewed
>> my test script via Apache and my browser.
>>
>> URL: http://localhost/odbc_test.php
>>
>> Fatal error: Call to undefined function odbc_connect() in
>> /var/www/html/odbc_test.php on line 3
>>
>>
>> Now, to get it working with Apache, all I had to do was restart the
>> web server.
>>
>> [root@jim html]# service httpd restart
>> Stopping httpd:                                            [  OK  ]
>> Starting httpd:                                            [  OK  ]
>>
>> Now, refreshing the above page gives me this.
>>
>> Warning: odbc_connect() expects at least 3 parameters, 0 given in
>> /var/www/html/odbc_test.php on line 3
>>
>> So, it is now working.
>>
>> Review my steps above, make sure you perform them as I did and you
>> should be working when you are done.
>>
>> Let us know if you need anything further.
>>
>> --
>> Jim Lucas
>>
>> http://www.cmsws.com/
>> http://www.cmsws.com/examples/