----- Original Message ----- From: "Greg Larkin" <glar...@freebsd.org>
To: "Glenn McCalley" <gl...@bnetmd.net>
Cc: <freebsd-questions@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" <m...@my.gd>
To: <freebsd-questions@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@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscr...@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



_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"

Reply via email to