Date: Tue, 14 Jun 2011 11:45:52 -0400 From: "Glenn McCalley" <techlist@mail.bnetmd.net> To: <glarkin@freebsd.org> Cc: freebsd-questions@freebsd.org Subject: Re: mysql_connect error Message-ID: <AFA6FCD7CDF343F6AD717917D7EC619A@GLENN2> References: <0F3C08F3CEF445EB8DC0060735DCA69D@GLENN2> <4DF771B7.4090104@my.gd><2DA8538A0B6947089C33DB97CAF2E918@GLENN2> <4DF77D8C.9060802@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
----- Original Message ----- From: "Greg Larkin" <glarkin@freebsd.org> To: "Glenn McCalley" <glenn@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" <ml@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-unsubscribe@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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?AFA6FCD7CDF343F6AD717917D7EC619A>