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

2013-05-13 Thread georg 
Hi David, and all who helped,

for now one step forward  my text message "db open" hit the screen.

after som brain-melting of various inputs i ad hoc came to the quite obvious 
conclusion,
try yum with what yum could be wanting:

** yum install php-odbc **

and see that magic, without knowledge of what Im really doing I got through

tnx 
/georg
  - Original Message - 
  From: georg 
  To: David OBrien 
  Sent: Sunday, May 12, 2013 9:00 PM
  Subject: Re: [PHP] undef func - any more clues ?


  found this that might be right (64  what does that stand for, i have to my 
knowledge a 32bit machine)

  how would I go about to install this ? 

  tnx
  Goerg
- Original Message - 
From: David OBrien 
To: georg 
Sent: Sunday, May 12, 2013 7:54 PM
Subject: Re: [PHP] undef func - any more clues ?



On May 12, 2013 1:35 PM, "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
>
> - Original Message - From: "Ashley Sheridan" 

> To: "georg" 
> Cc: "James Yerge" ; "PHP General" 

> Sent: Saturday, May 11, 2013 12:05 PM
> Subject: Re: [PHP] undef func - any more clues ?
>
>
>
>> On Sat, 2013-05-11 at 11:36 +0200, georg wrote:
>>
>>> Hi again,
>>> is there any more clues to how Apache/PHP would get hold of ODBC 
libraries ?
>>>
>>>
>>> (( summery; Im a bit new to linux (here Fedora 17) so Im not sure of how
>>> these entities get hold of each other; are they linked into same module 
or
>>> are they dynamically loaded
>>> libraries, guess that the latter. Then Im not clear over the "path" or
>>> "linkage" of these; that is where
>>> are the definitions made to link them together; there is a series of 
conf
>>> and ini files (and keyword) which should
>>> link names, and point to file names in (defined ?) directories (given by
>>> paths)))
>>>
>>> / Georg
>>>
>>>
>>>
>>>
>>>
>>>
>>> - Original Message - From: "georg" 
>>> To: "James Yerge" 
>>> Cc: "PHP General" 
>>> Sent: Saturday, May 11, 2013 12:47 AM
>>> Subject: Re: [PHP] undef func
>>>
>>>
>>> > Ok, txn ! so
>>> > yum install php-devel
>>> >
>>> > worked, and got me a hole lot of pearl, however, still PHP has
>>> > odbc_connect() call as undefined function. as per Apache error log.
>>> >
>>> > There was some mentioning of php.ini; could that be something here ?
>>> >
>>> > /georg
>>> >
>>> > - Original Message - > From: "James Yerge" 

>>> > To: "Gabriel Ricci" 
>>> > Cc: "georg" ; "Serge Fonville"
>>> > ; "Daniel Brown" ; 
"tamouse
>>> > mailing lists" ; "PHP General"
>>> > 
>>> > Sent: Saturday, May 11, 2013 12:12 AM
>>> > Subject: Re: [PHP] undef func
>>> >
>>> >
>>> >> On 05/10/2013 06:08 PM, Gabriel Ricci wrote:
>>> >>> pear isntall php-dev
>>> >>>
>>> >>>
>>> >>> Att.
>>> >>>
>>> >>> Gabriel Ricci
>>> >>> 
>>> >>>
>>> >>> Website 
>>> >>> Follow @gabrielricci 
>>> >>> Facebook profile , GitHub
>>> >>> profile
>>> >>> 
>>> >>>
>>> >>>
>>> >>> On Fri, May 10, 2013 at 7:07 PM, georg  
>>> wrote:
>>> >>>
>>>  **
>>>  So thanx again, closing in. It turned out that I had tried; yum 
 install
>>>  php_pear  // i.e. with an underscore, should be with hyphen !
>>>  so crawling a mm forward; then stuck on; pecl install pdo_odbc
//  in
>>>  this case the undrscore is ok (!)
>>>  which fails as
>>> 
>>>  "Cant find php headers in /usr/include/php"  followed by "Error 
 phpize
>>>  failed"
>>> 
>>>  /georg
>>> 
>>>  - Original Message -
>>>  *From:* Serge Fonville 
>>>  *To:* georg 
>>>  *Cc:* Gabriel Ricci  ; Daniel
>>>  Brown; tamouse
>>>  mailing lists  ; PHP
>>>  General
>>>  *Sent:* Friday, May 10, 2013 11:41 PM
>>>  *Subject:* Re: [PHP] undef func
>>> 
>>>   Assuming OP is using a distro that uses yum for package 
management;
>>>  A "yum whatprovides pecl" should provide the package name that 
needs  to
>>>  be
>>>  installed, in case of an apt based distro, this could be done  
through
>>>  aptitude. Either way, it seems what might provide more information 
 is
>>>  details like the commands executed, the distro used and the erro

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

2013-05-13 Thread Jim Lucas 

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/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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

2013-05-13 Thread georg 

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)

/georg

- Original Message - 
From: "Jim Lucas" 

To: "georg" 
Cc: ; 
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/


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php