mysql_connect error

[Greg Larkin]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 6/14/11 10:49 AM, Glenn McCalley wrote:
> 
> ----- Original Message ----- From: "Damien Fleuriot" <ml at my.gd>
> To: <freebsd-questions at freebsd.org>
> Sent: Tuesday, June 14, 2011 10:35 AM
> Subject: Re: mysql_connect error
> 
> 
>> On 6/14/11 2:46 PM, Glenn McCalley wrote:
>>> Seen other people have this problem but cannot get their resolutions to
>>> work for me.
>>>
>>> "Fatal error: Call to oundefined function mysql_connect() in etc., etc."
>>>
>>> This began happening after an upgrade to php5 using the portmaster
>>> program.
>>> phpinfo page does -not- show the mysql_connect function anywhere.
>>> phpinfo page is at www9.bnetmd.net/index.php if you have the desire to
>>> look.
>>>
>>> Suggestions from lists/boards seem to all point to mysql.so not being in
>>> the php library, yet a "find" shows it is in there.
>>>
>>> pkg_info shows "php5-mysql-5.3.5      The mysql shared extension for
>>> php"
>>>
>>> extensions.ini shows "extension=mysql.so"
>>>
>>> Is there anywhere/anything else to look/do?
>>>
>>> Thanks!
>>> Glenn.
>>>
>>>
>>
>>
>> If I were you, I would reinstall the php5 mysql extension like so:
>>
>>
>> cd /usr/ports/lang/php5-extensions
>> make config
>> # make sure you tick the MYSQL option
>> make clean
>> make
>> make deinstall && make reinstall
>>
>>
>> Then, restart your web server or PHP FCGI process, as applicable.
>>
>> You should be cool.
>>
> Thanks Damien,
> 
> Did so, mysql definitely checked, no help.  I did see that gd was not
> checked so checked that, did the make process and that cured another
> problem so I'd say the reinstall did in fact take.
> 
> The error happens when being run from the command line.  Does that make
> a difference?
> 
> Glenn.

Hi Glenn,

Try running this command in your shell:

php -i | grep -i php.ini

Does the reported path match the one reported by your phpinfo page
(viewed in the web browser)?  Also, is it possible you have multiple php
executables installed?  What is the output of the following commands?

which php
pkg_info -L php5-5\*

Regards,
Greg
- -- 
Greg Larkin

http://www.FreeBSD.org/           - The Power To Serve
http://www.sourcehosting.net/     - Ready. Set. Code.
http://twitter.com/cpucycle/      - Follow you, follow me
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk33fYwACgkQ0sRouByUApBPBACfZLyTSRQfGuFR6kg9IYts2pmJ
B7gAn3CieUC57U0rOfsvIo+ZddtCltaZ
=1Zbg
-----END PGP SIGNATURE-----