mysql_connect error

Glenn McCalley techlist at mail.bnetmd.net
Tue Jun 14 15:46:01 UTC 2011 

----- Original Message ----- 
From: "Greg Larkin" <glarkin at freebsd.org>
To: "Glenn McCalley" <glenn at bnetmd.net>
Cc: <freebsd-questions at freebsd.org>
Sent: Tuesday, June 14, 2011 11:26 AM
Subject: Re: mysql_connect error


> -----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-----
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to 
> "freebsd-questions-unsubscribe at freebsd.org"
>
Greg,
----------------------------------------------------------------------
www9# which php
/usr/local/bin/php

----------------------------------------------------------------------
www9# php -i | grep -i php.ini
Configuration File (php.ini) Path => /usr/local/etc            <-- matches 
phpinfo page
Loaded Configuration File => /usr/local/etc/php.ini            <-- matches 
phpinfo page
/libexec/ld-elf.so.1: /usr/local/lib/mysql/libmysqlclient.so.16: Undefined 
symbol "pthread_cond_timedwait"                             <-- interesting, 
don't know if significant

----------------------------------------------------------------------
www9# pkg_info -L php5-5\*    (Voluminous output, but here it is.)
Information for php5-5.3.5:
Files:
/usr/local/man/man1/php-config.1.gz
/usr/local/man/man1/phpize.1.gz
/usr/local/bin/php-config
/usr/local/bin/phpize
/usr/local/etc/php.conf
/usr/local/etc/php.ini-development
/usr/local/etc/php.ini-production
/usr/local/include/php/TSRM/TSRM.h
/usr/local/include/php/TSRM/acconfig.h
/usr/local/include/php/TSRM/readdir.h
/usr/local/include/php/TSRM/tsrm_config.h
/usr/local/include/php/TSRM/tsrm_config.w32.h
/usr/local/include/php/TSRM/tsrm_config_common.h
/usr/local/include/php/TSRM/tsrm_nw.h
/usr/local/include/php/TSRM/tsrm_strtok_r.h
/usr/local/include/php/TSRM/tsrm_virtual_cwd.h
/usr/local/include/php/TSRM/tsrm_win32.h
/usr/local/include/php/Zend/acconfig.h
/usr/local/include/php/Zend/zend.h
/usr/local/include/php/Zend/zend_API.h
/usr/local/include/php/Zend/zend_alloc.h
/usr/local/include/php/Zend/zend_build.h
/usr/local/include/php/Zend/zend_builtin_functions.h
/usr/local/include/php/Zend/zend_closures.h
/usr/local/include/php/Zend/zend_compile.h
/usr/local/include/php/Zend/zend_config.h
/usr/local/include/php/Zend/zend_config.nw.h
/usr/local/include/php/Zend/zend_config.w32.h
/usr/local/include/php/Zend/zend_constants.h
/usr/local/include/php/Zend/zend_dynamic_array.h
/usr/local/include/php/Zend/zend_errors.h
/usr/local/include/php/Zend/zend_exceptions.h
/usr/local/include/php/Zend/zend_execute.h
/usr/local/include/php/Zend/zend_extensions.h
/usr/local/include/php/Zend/zend_fast_cache.h
/usr/local/include/php/Zend/zend_float.h
/usr/local/include/php/Zend/zend_gc.h
/usr/local/include/php/Zend/zend_globals.h
/usr/local/include/php/Zend/zend_globals_macros.h
/usr/local/include/php/Zend/zend_hash.h
/usr/local/include/php/Zend/zend_highlight.h
/usr/local/include/php/Zend/zend_indent.h
/usr/local/include/php/Zend/zend_ini.h
/usr/local/include/php/Zend/zend_ini_parser.h
/usr/local/include/php/Zend/zend_ini_scanner.h
/usr/local/include/php/Zend/zend_ini_scanner_defs.h
/usr/local/include/php/Zend/zend_interfaces.h
/usr/local/include/php/Zend/zend_istdiostream.h
/usr/local/include/php/Zend/zend_iterators.h
/usr/local/include/php/Zend/zend_language_parser.h
/usr/local/include/php/Zend/zend_language_scanner.h
/usr/local/include/php/Zend/zend_language_scanner_defs.h
/usr/local/include/php/Zend/zend_list.h
/usr/local/include/php/Zend/zend_llist.h
/usr/local/include/php/Zend/zend_modules.h
/usr/local/include/php/Zend/zend_multibyte.h
/usr/local/include/php/Zend/zend_multiply.h
/usr/local/include/php/Zend/zend_object_handlers.h
/usr/local/include/php/Zend/zend_objects.h
/usr/local/include/php/Zend/zend_objects_API.h
/usr/local/include/php/Zend/zend_operators.h
/usr/local/include/php/Zend/zend_ptr_stack.h
/usr/local/include/php/Zend/zend_qsort.h
/usr/local/include/php/Zend/zend_stack.h
/usr/local/include/php/Zend/zend_static_allocator.h
/usr/local/include/php/Zend/zend_stream.h
/usr/local/include/php/Zend/zend_strtod.h
/usr/local/include/php/Zend/zend_ts_hash.h
/usr/local/include/php/Zend/zend_types.h
/usr/local/include/php/Zend/zend_variables.h
/usr/local/include/php/Zend/zend_vm.h
/usr/local/include/php/Zend/zend_vm_def.h
/usr/local/include/php/Zend/zend_vm_execute.h
/usr/local/include/php/Zend/zend_vm_opcodes.h
/usr/local/include/php/ext/date/lib/timelib.h
/usr/local/include/php/ext/date/lib/timelib_config.h
/usr/local/include/php/ext/date/lib/timelib_structs.h
/usr/local/include/php/ext/date/php_date.h
/usr/local/include/php/ext/ereg/php_ereg.h
/usr/local/include/php/ext/ereg/php_regex.h
/usr/local/include/php/ext/ereg/regex/cclass.h
/usr/local/include/php/ext/ereg/regex/cname.h
/usr/local/include/php/ext/ereg/regex/regex.h
/usr/local/include/php/ext/ereg/regex/regex2.h
/usr/local/include/php/ext/ereg/regex/utils.h
/usr/local/include/php/ext/libxml/php_libxml.h
/usr/local/include/php/ext/mysqlnd/config-win.h
/usr/local/include/php/ext/mysqlnd/mysqlnd.h
/usr/local/include/php/ext/mysqlnd/mysqlnd_block_alloc.h
/usr/local/include/php/ext/mysqlnd/mysqlnd_charset.h
/usr/local/include/php/ext/mysqlnd/mysqlnd_debug.h
/usr/local/include/php/ext/mysqlnd/mysqlnd_enum_n_def.h
/usr/local/include/php/ext/mysqlnd/mysqlnd_libmysql_compat.h
/usr/local/include/php/ext/mysqlnd/mysqlnd_net.h
/usr/local/include/php/ext/mysqlnd/mysqlnd_portability.h
/usr/local/include/php/ext/mysqlnd/mysqlnd_priv.h
/usr/local/include/php/ext/mysqlnd/mysqlnd_result.h
/usr/local/include/php/ext/mysqlnd/mysqlnd_result_meta.h
/usr/local/include/php/ext/mysqlnd/mysqlnd_statistics.h
/usr/local/include/php/ext/mysqlnd/mysqlnd_structs.h
/usr/local/include/php/ext/mysqlnd/mysqlnd_wireprotocol.h
/usr/local/include/php/ext/mysqlnd/php_mysqlnd.h
/usr/local/include/php/ext/mysqlnd/php_mysqlnd_config.h
/usr/local/include/php/ext/pcre/php_pcre.h
/usr/local/include/php/ext/spl/php_spl.h
/usr/local/include/php/ext/spl/spl_array.h
/usr/local/include/php/ext/spl/spl_directory.h
/usr/local/include/php/ext/spl/spl_dllist.h
/usr/local/include/php/ext/spl/spl_engine.h
/usr/local/include/php/ext/spl/spl_exceptions.h
/usr/local/include/php/ext/spl/spl_fixedarray.h
/usr/local/include/php/ext/spl/spl_functions.h
/usr/local/include/php/ext/spl/spl_heap.h
/usr/local/include/php/ext/spl/spl_iterators.h
/usr/local/include/php/ext/spl/spl_observer.h
/usr/local/include/php/ext/standard/base64.h
/usr/local/include/php/ext/standard/basic_functions.h
/usr/local/include/php/ext/standard/crc32.h
/usr/local/include/php/ext/standard/credits.h
/usr/local/include/php/ext/standard/credits_ext.h
/usr/local/include/php/ext/standard/credits_sapi.h
/usr/local/include/php/ext/standard/crypt_freesec.h
/usr/local/include/php/ext/standard/css.h
/usr/local/include/php/ext/standard/cyr_convert.h
/usr/local/include/php/ext/standard/datetime.h
/usr/local/include/php/ext/standard/dl.h
/usr/local/include/php/ext/standard/exec.h
/usr/local/include/php/ext/standard/file.h
/usr/local/include/php/ext/standard/flock_compat.h
/usr/local/include/php/ext/standard/fsock.h
/usr/local/include/php/ext/standard/head.h
/usr/local/include/php/ext/standard/html.h
/usr/local/include/php/ext/standard/info.h
/usr/local/include/php/ext/standard/md5.h
/usr/local/include/php/ext/standard/microtime.h
/usr/local/include/php/ext/standard/pack.h
/usr/local/include/php/ext/standard/pageinfo.h
/usr/local/include/php/ext/standard/php_array.h
/usr/local/include/php/ext/standard/php_assert.h
/usr/local/include/php/ext/standard/php_browscap.h
/usr/local/include/php/ext/standard/php_crypt.h
/usr/local/include/php/ext/standard/php_crypt_r.h
/usr/local/include/php/ext/standard/php_dir.h
/usr/local/include/php/ext/standard/php_dns.h
/usr/local/include/php/ext/standard/php_ext_syslog.h
/usr/local/include/php/ext/standard/php_filestat.h
/usr/local/include/php/ext/standard/php_fopen_wrappers.h
/usr/local/include/php/ext/standard/php_ftok.h
/usr/local/include/php/ext/standard/php_http.h
/usr/local/include/php/ext/standard/php_image.h
/usr/local/include/php/ext/standard/php_incomplete_class.h
/usr/local/include/php/ext/standard/php_iptc.h
/usr/local/include/php/ext/standard/php_lcg.h
/usr/local/include/php/ext/standard/php_link.h
/usr/local/include/php/ext/standard/php_mail.h
/usr/local/include/php/ext/standard/php_math.h
/usr/local/include/php/ext/standard/php_metaphone.h
/usr/local/include/php/ext/standard/php_rand.h
/usr/local/include/php/ext/standard/php_smart_str.h
/usr/local/include/php/ext/standard/php_smart_str_public.h
/usr/local/include/php/ext/standard/php_standard.h
/usr/local/include/php/ext/standard/php_string.h
/usr/local/include/php/ext/standard/php_type.h
/usr/local/include/php/ext/standard/php_uuencode.h
/usr/local/include/php/ext/standard/php_var.h
/usr/local/include/php/ext/standard/php_versioning.h
/usr/local/include/php/ext/standard/proc_open.h
/usr/local/include/php/ext/standard/quot_print.h
/usr/local/include/php/ext/standard/scanf.h
/usr/local/include/php/ext/standard/sha1.h
/usr/local/include/php/ext/standard/streamsfuncs.h
/usr/local/include/php/ext/standard/uniqid.h
/usr/local/include/php/ext/standard/url.h
/usr/local/include/php/ext/standard/url_scanner_ex.h
/usr/local/include/php/ext/standard/winver.h
/usr/local/include/php/main/SAPI.h
/usr/local/include/php/main/build-defs.h
/usr/local/include/php/main/fopen_wrappers.h
/usr/local/include/php/main/logos.h
/usr/local/include/php/main/php.h
/usr/local/include/php/main/php3_compat.h
/usr/local/include/php/main/php_compat.h
/usr/local/include/php/main/php_config.h
/usr/local/include/php/main/php_content_types.h
/usr/local/include/php/main/php_getopt.h
/usr/local/include/php/main/php_globals.h
/usr/local/include/php/main/php_ini.h
/usr/local/include/php/main/php_logos.h
/usr/local/include/php/main/php_main.h
/usr/local/include/php/main/php_memory_streams.h
/usr/local/include/php/main/php_network.h
/usr/local/include/php/main/php_open_temporary_file.h
/usr/local/include/php/main/php_output.h
/usr/local/include/php/main/php_reentrancy.h
/usr/local/include/php/main/php_scandir.h
/usr/local/include/php/main/php_streams.h
/usr/local/include/php/main/php_syslog.h
/usr/local/include/php/main/php_ticks.h
/usr/local/include/php/main/php_variables.h
/usr/local/include/php/main/php_version.h
/usr/local/include/php/main/rfc1867.h
/usr/local/include/php/main/safe_mode.h
/usr/local/include/php/main/snprintf.h
/usr/local/include/php/main/spprintf.h
/usr/local/include/php/main/streams/php_stream_context.h
/usr/local/include/php/main/streams/php_stream_filter_api.h
/usr/local/include/php/main/streams/php_stream_glob_wrapper.h
/usr/local/include/php/main/streams/php_stream_mmap.h
/usr/local/include/php/main/streams/php_streams_int.h
/usr/local/include/php/main/streams/php_stream_transport.h
/usr/local/include/php/main/streams/php_stream_userspace.h
/usr/local/include/php/main/streams/php_stream_plain_wrapper.h
/usr/local/include/php/main/suhosin_globals.h
/usr/local/include/php/main/suhosin_logo.h
/usr/local/include/php/main/suhosin_patch.h
/usr/local/include/php/main/win32_internal_function_disabled.h
/usr/local/include/php/main/win95nt.h
/usr/local/lib/php/build/Makefile.global
/usr/local/lib/php/build/acinclude.m4
/usr/local/lib/php/build/config.guess
/usr/local/lib/php/build/config.sub
/usr/local/lib/php/build/libtool.m4
/usr/local/lib/php/build/ltmain.sh
/usr/local/lib/php/build/mkdep.awk
/usr/local/lib/php/build/phpize.m4
/usr/local/lib/php/build/run-tests.php
/usr/local/lib/php/build/scan_makefile_in.awk
/usr/local/lib/php/build/shtool
/usr/local/libexec/apache22/libphp5.so

More information about the freebsd-questions mailing list