[freetds] php undefined symbol: mssql_module_entry (cannot load phpwith --with-mssql=/usr/local/freetds)

Carlos García cgarcia at intdatacollection.com
Wed Nov 8 15:04:53 EST 2006


Thank you for you help !!

php -m does NOT list mssql. This is what it shows:
[PHP Modules]
ctype
date
dom
hash
iconv
libxml
pcre
PDO
posix
Reflection
session
SimpleXML
SPL
SQLite
standard
tokenizer
xml
xmlreader
xmlwriter


****************************
I can connnect to MS-SQL with tsql , and run queries allright:
 tsql -S PRG1 -U sa

****************************
FREETDS VERSION

[root at qonos php]# tsql -C
Compile-time settings (established with the "configure" script)
                            Version: freetds v0.65.dev.20061103
             freetds.conf directory: /usr/local/etc
     MS db-lib source compatibility: yes
        Sybase binary compatibility: no
                      Thread safety: yes
                      iconv library: yes
                        TDS version: 5.0
                              iODBC: no
                           unixodbc: no

Please note it says v0.65, even though I downloaded the "stable"version 
from freetds, which generated 0.64
freetds-0.64 
freetds-stable.tar

*********************************************************

Upon make install, one message is

You may want to add: /wwwroot/php/lib/php to your php.ini include_path

The install process also adds the following  line to httpd.conf file;
            LoadModule php5_module        modules/libphp5.so

When starting apache, this line fails to execute.
If I remove it, apache starts without php support, only when I make php 
without a reference to   --with-mssql=/usr/local/freetds the php module 
is loaded fine


*********************************************************
MESSAGES ON MAKE

There a 2 mega-lines concerning mssql; nothing useful for me; I've 
pasted them below.


Thank you again. I look forward for any suggestions.


LINE1
/bin/sh /usr/src/php-5.1.6/libtool --silent --preserve-dup-deps 
--mode=link gcc -I/usr/include -g -O2 -prefer-non-pic  -rpath 
/usr/src/php-5.1.6/libs -avoid-version -module -L/usr/local/freetds/lib  
-R /usr/local/freetds/lib ext/libxml/libxml.lo 
ext/pcre/pcrelib/pcre_chartables.lo 
ext/pcre/pcrelib/pcre_ucp_searchfuncs.lo 
ext/pcre/pcrelib/pcre_compile.lo ext/pcre/pcrelib/pcre_config.lo 
ext/pcre/pcrelib/pcre_dfa_exec.lo ext/pcre/pcrelib/pcre_exec.lo 
ext/pcre/pcrelib/pcre_fullinfo.lo ext/pcre/pcrelib/pcre_get.lo 
ext/pcre/pcrelib/pcre_globals.lo ext/pcre/pcrelib/pcre_info.lo 
ext/pcre/pcrelib/pcre_maketables.lo ext/pcre/pcrelib/pcre_ord2utf8.lo 
ext/pcre/pcrelib/pcre_refcount.lo ext/pcre/pcrelib/pcre_study.lo 
ext/pcre/pcrelib/pcre_tables.lo ext/pcre/pcrelib/pcre_try_flipped.lo 
ext/pcre/pcrelib/pcre_valid_utf8.lo ext/pcre/pcrelib/pcre_version.lo 
ext/pcre/pcrelib/pcre_xclass.lo ext/pcre/php_pcre.lo ext/ctype/ctype.lo 
ext/date/php_date.lo ext/date/lib/astro.lo ext/date/lib/dow.lo 
ext/date/lib/parse_date.lo ext/date/lib/parse_tz.lo 
ext/date/lib/timelib.lo ext/date/lib/tm2unixtime.lo 
ext/date/lib/unixtime2tm.lo ext/dom/php_dom.lo ext/dom/attr.lo 
ext/dom/document.lo ext/dom/domerrorhandler.lo ext/dom/domstringlist.lo 
ext/dom/domexception.lo ext/dom/namelist.lo 
ext/dom/processinginstruction.lo ext/dom/cdatasection.lo 
ext/dom/documentfragment.lo ext/dom/domimplementation.lo 
ext/dom/element.lo ext/dom/node.lo ext/dom/string_extend.lo 
ext/dom/characterdata.lo ext/dom/documenttype.lo 
ext/dom/domimplementationlist.lo ext/dom/entity.lo ext/dom/nodelist.lo 
ext/dom/text.lo ext/dom/comment.lo ext/dom/domconfiguration.lo 
ext/dom/domimplementationsource.lo ext/dom/entityreference.lo 
ext/dom/notation.lo ext/dom/xpath.lo ext/dom/dom_iterators.lo 
ext/dom/typeinfo.lo ext/dom/domerror.lo ext/dom/domlocator.lo 
ext/dom/namednodemap.lo ext/dom/userdatahandler.lo ext/hash/hash.lo 
ext/hash/hash_md.lo ext/hash/hash_sha.lo ext/hash/hash_ripemd.lo 
ext/hash/hash_haval.lo ext/hash/hash_tiger.lo ext/hash/hash_gost.lo 
ext/hash/hash_snefru.lo ext/hash/hash_whirlpool.lo 
ext/hash/hash_adler32.lo ext/hash/hash_crc32.lo ext/iconv/iconv.lo 
ext/mssql/php_mssql.lo ext/mysql/php_mysql.lo ext/pdo/pdo.lo 
ext/pdo/pdo_dbh.lo ext/pdo/pdo_stmt.lo ext/pdo/pdo_sql_parser.lo 
ext/pdo/pdo_sqlstate.lo ext/posix/posix.lo 
ext/reflection/php_reflection.lo ext/session/session.lo 
ext/session/mod_files.lo ext/session/mod_mm.lo ext/session/mod_user.lo 
ext/simplexml/simplexml.lo ext/spl/php_spl.lo ext/spl/spl_functions.lo 
ext/spl/spl_engine.lo ext/spl/spl_iterators.lo ext/spl/spl_array.lo 
ext/spl/spl_directory.lo ext/spl/spl_sxe.lo ext/spl/spl_exceptions.lo 
ext/spl/spl_observer.lo ext/sqlite/sqlite.lo ext/sqlite/sess_sqlite.lo 
ext/sqlite/pdo_sqlite2.lo ext/sqlite/libsqlite/src/opcodes.lo 
ext/sqlite/libsqlite/src/parse.lo ext/sqlite/libsqlite/src/encode.lo 
ext/sqlite/libsqlite/src/auth.lo ext/sqlite/libsqlite/src/btree.lo 
ext/sqlite/libsqlite/src/build.lo ext/sqlite/libsqlite/src/delete.lo 
ext/sqlite/libsqlite/src/expr.lo ext/sqlite/libsqlite/src/func.lo 
ext/sqlite/libsqlite/src/hash.lo ext/sqlite/libsqlite/src/insert.lo 
ext/sqlite/libsqlite/src/main.lo ext/sqlite/libsqlite/src/os.lo 
ext/sqlite/libsqlite/src/pager.lo ext/sqlite/libsqlite/src/printf.lo 
ext/sqlite/libsqlite/src/random.lo ext/sqlite/libsqlite/src/select.lo 
ext/sqlite/libsqlite/src/table.lo ext/sqlite/libsqlite/src/tokenize.lo 
ext/sqlite/libsqlite/src/update.lo ext/sqlite/libsqlite/src/util.lo 
ext/sqlite/libsqlite/src/vdbe.lo ext/sqlite/libsqlite/src/attach.lo 
ext/sqlite/libsqlite/src/btree_rb.lo ext/sqlite/libsqlite/src/pragma.lo 
ext/sqlite/libsqlite/src/vacuum.lo ext/sqlite/libsqlite/src/copy.lo 
ext/sqlite/libsqlite/src/vdbeaux.lo ext/sqlite/libsqlite/src/date.lo 
ext/sqlite/libsqlite/src/where.lo ext/sqlite/libsqlite/src/trigger.lo 
regex/regcomp.lo regex/regexec.lo regex/regerror.lo regex/regfree.lo 
ext/standard/array.lo ext/standard/base64.lo 
ext/standard/basic_functions.lo ext/standard/browscap.lo 
ext/standard/crc32.lo ext/standard/crypt.lo ext/standard/cyr_convert.lo 
ext/standard/datetime.lo ext/standard/dir.lo ext/standard/dl.lo 
ext/standard/dns.lo ext/standard/exec.lo ext/standard/file.lo 
ext/standard/filestat.lo ext/standard/flock_compat.lo 
ext/standard/formatted_print.lo ext/standard/fsock.lo 
ext/standard/head.lo ext/standard/html.lo ext/standard/image.lo 
ext/standard/info.lo ext/standard/iptc.lo ext/standard/lcg.lo 
ext/standard/link.lo ext/standard/mail.lo ext/standard/math.lo 
ext/standard/md5.lo ext/standard/metaphone.lo ext/standard/microtime.lo 
ext/standard/pack.lo ext/standard/pageinfo.lo ext/standard/quot_print.lo 
ext/standard/rand.lo ext/standard/reg.lo ext/standard/soundex.lo 
ext/standard/string.lo ext/standard/scanf.lo ext/standard/syslog.lo 
ext/standard/type.lo ext/standard/uniqid.lo ext/standard/url.lo 
ext/standard/url_scanner.lo ext/standard/var.lo 
ext/standard/versioning.lo ext/standard/assert.lo 
ext/standard/strnatcmp.lo ext/standard/levenshtein.lo 
ext/standard/incomplete_class.lo ext/standard/url_scanner_ex.lo 
ext/standard/ftp_fopen_wrapper.lo ext/standard/http_fopen_wrapper.lo 
ext/standard/php_fopen_wrapper.lo ext/standard/credits.lo 
ext/standard/css.lo ext/standard/var_unserializer.lo 
ext/standard/ftok.lo ext/standard/sha1.lo ext/standard/user_filters.lo 
ext/standard/uuencode.lo ext/standard/filters.lo 
ext/standard/proc_open.lo ext/standard/streamsfuncs.lo 
ext/standard/http.lo ext/tokenizer/tokenizer.lo ext/xml/xml.lo 
ext/xml/compat.lo ext/xmlreader/php_xmlreader.lo 
ext/xmlwriter/php_xmlwriter.lo TSRM/TSRM.lo TSRM/tsrm_strtok_r.lo 
TSRM/tsrm_virtual_cwd.lo main/main.lo main/snprintf.lo main/spprintf.lo 
main/php_sprintf.lo main/safe_mode.lo main/fopen_wrappers.lo 
main/alloca.lo main/php_scandir.lo main/php_ini.lo main/SAPI.lo 
main/rfc1867.lo main/php_content_types.lo main/strlcpy.lo 
main/strlcat.lo main/mergesort.lo main/reentrancy.lo 
main/php_variables.lo main/php_ticks.lo main/network.lo 
main/php_open_temporary_file.lo main/php_logos.lo main/output.lo 
main/streams/streams.lo main/streams/cast.lo main/streams/memory.lo 
main/streams/filter.lo main/streams/plain_wrapper.lo 
main/streams/userspace.lo main/streams/transports.lo 
main/streams/xp_socket.lo main/streams/mmap.lo 
Zend/zend_language_parser.lo Zend/zend_language_scanner.lo 
Zend/zend_ini_parser.lo Zend/zend_ini_scanner.lo Zend/zend_alloc.lo 
Zend/zend_compile.lo Zend/zend_constants.lo Zend/zend_dynamic_array.lo 
Zend/zend_execute_API.lo Zend/zend_highlight.lo Zend/zend_llist.lo 
Zend/zend_opcode.lo Zend/zend_operators.lo Zend/zend_ptr_stack.lo 
Zend/zend_stack.lo Zend/zend_variables.lo Zend/zend.lo Zend/zend_API.lo 
Zend/zend_extensions.lo Zend/zend_hash.lo Zend/zend_list.lo 
Zend/zend_indent.lo Zend/zend_builtin_functions.lo Zend/zend_sprintf.lo 
Zend/zend_ini.lo Zend/zend_qsort.lo Zend/zend_multibyte.lo 
Zend/zend_ts_hash.lo Zend/zend_stream.lo Zend/zend_iterators.lo 
Zend/zend_interfaces.lo Zend/zend_exceptions.lo Zend/zend_strtod.lo 
Zend/zend_objects.lo Zend/zend_object_handlers.lo 
Zend/zend_objects_API.lo Zend/zend_mm.lo Zend/zend_default_classes.lo 
Zend/zend_execute.lo sapi/apache2handler/mod_php5.lo 
sapi/apache2handler/sapi_apache2.lo sapi/apache2handler/apache_config.lo 
sapi/apache2handler/php_functions.lo main/internal_functions.lo -lcrypt 
-lcrypt -lmysqlclient -lsybdb -lresolv -lm -ldl -lnsl -lxml2 -lz -lm 
-lxml2 -lz -lm -lxml2 -lz -lm -lcrypt -lxml2 -lz -lm -lxml2 -lz -lm 
-lxml2 -lz -lm -lcrypt  -o libphp5.la

LINE2

/bin/sh /usr/src/php-5.1.6/libtool --silent --preserve-dup-deps 
--mode=link gcc -export-dynamic -I/usr/include -g -O2  
-L/usr/local/freetds/lib  -R /usr/local/freetds/lib ext/libxml/libxml.lo 
ext/pcre/pcrelib/pcre_chartables.lo 
ext/pcre/pcrelib/pcre_ucp_searchfuncs.lo 
ext/pcre/pcrelib/pcre_compile.lo ext/pcre/pcrelib/pcre_config.lo 
ext/pcre/pcrelib/pcre_dfa_exec.lo ext/pcre/pcrelib/pcre_exec.lo 
ext/pcre/pcrelib/pcre_fullinfo.lo ext/pcre/pcrelib/pcre_get.lo 
ext/pcre/pcrelib/pcre_globals.lo ext/pcre/pcrelib/pcre_info.lo 
ext/pcre/pcrelib/pcre_maketables.lo ext/pcre/pcrelib/pcre_ord2utf8.lo 
ext/pcre/pcrelib/pcre_refcount.lo ext/pcre/pcrelib/pcre_study.lo 
ext/pcre/pcrelib/pcre_tables.lo ext/pcre/pcrelib/pcre_try_flipped.lo 
ext/pcre/pcrelib/pcre_valid_utf8.lo ext/pcre/pcrelib/pcre_version.lo 
ext/pcre/pcrelib/pcre_xclass.lo ext/pcre/php_pcre.lo ext/ctype/ctype.lo 
ext/date/php_date.lo ext/date/lib/astro.lo ext/date/lib/dow.lo 
ext/date/lib/parse_date.lo ext/date/lib/parse_tz.lo 
ext/date/lib/timelib.lo ext/date/lib/tm2unixtime.lo 
ext/date/lib/unixtime2tm.lo ext/dom/php_dom.lo ext/dom/attr.lo 
ext/dom/document.lo ext/dom/domerrorhandler.lo ext/dom/domstringlist.lo 
ext/dom/domexception.lo ext/dom/namelist.lo 
ext/dom/processinginstruction.lo ext/dom/cdatasection.lo 
ext/dom/documentfragment.lo ext/dom/domimplementation.lo 
ext/dom/element.lo ext/dom/node.lo ext/dom/string_extend.lo 
ext/dom/characterdata.lo ext/dom/documenttype.lo 
ext/dom/domimplementationlist.lo ext/dom/entity.lo ext/dom/nodelist.lo 
ext/dom/text.lo ext/dom/comment.lo ext/dom/domconfiguration.lo 
ext/dom/domimplementationsource.lo ext/dom/entityreference.lo 
ext/dom/notation.lo ext/dom/xpath.lo ext/dom/dom_iterators.lo 
ext/dom/typeinfo.lo ext/dom/domerror.lo ext/dom/domlocator.lo 
ext/dom/namednodemap.lo ext/dom/userdatahandler.lo ext/hash/hash.lo 
ext/hash/hash_md.lo ext/hash/hash_sha.lo ext/hash/hash_ripemd.lo 
ext/hash/hash_haval.lo ext/hash/hash_tiger.lo ext/hash/hash_gost.lo 
ext/hash/hash_snefru.lo ext/hash/hash_whirlpool.lo 
ext/hash/hash_adler32.lo ext/hash/hash_crc32.lo ext/iconv/iconv.lo 
ext/mssql/php_mssql.lo ext/mysql/php_mysql.lo ext/pdo/pdo.lo 
ext/pdo/pdo_dbh.lo ext/pdo/pdo_stmt.lo ext/pdo/pdo_sql_parser.lo 
ext/pdo/pdo_sqlstate.lo ext/posix/posix.lo 
ext/reflection/php_reflection.lo ext/session/session.lo 
ext/session/mod_files.lo ext/session/mod_mm.lo ext/session/mod_user.lo 
ext/simplexml/simplexml.lo ext/spl/php_spl.lo ext/spl/spl_functions.lo 
ext/spl/spl_engine.lo ext/spl/spl_iterators.lo ext/spl/spl_array.lo 
ext/spl/spl_directory.lo ext/spl/spl_sxe.lo ext/spl/spl_exceptions.lo 
ext/spl/spl_observer.lo ext/sqlite/sqlite.lo ext/sqlite/sess_sqlite.lo 
ext/sqlite/pdo_sqlite2.lo ext/sqlite/libsqlite/src/opcodes.lo 
ext/sqlite/libsqlite/src/parse.lo ext/sqlite/libsqlite/src/encode.lo 
ext/sqlite/libsqlite/src/auth.lo ext/sqlite/libsqlite/src/btree.lo 
ext/sqlite/libsqlite/src/build.lo ext/sqlite/libsqlite/src/delete.lo 
ext/sqlite/libsqlite/src/expr.lo ext/sqlite/libsqlite/src/func.lo 
ext/sqlite/libsqlite/src/hash.lo ext/sqlite/libsqlite/src/insert.lo 
ext/sqlite/libsqlite/src/main.lo ext/sqlite/libsqlite/src/os.lo 
ext/sqlite/libsqlite/src/pager.lo ext/sqlite/libsqlite/src/printf.lo 
ext/sqlite/libsqlite/src/random.lo ext/sqlite/libsqlite/src/select.lo 
ext/sqlite/libsqlite/src/table.lo ext/sqlite/libsqlite/src/tokenize.lo 
ext/sqlite/libsqlite/src/update.lo ext/sqlite/libsqlite/src/util.lo 
ext/sqlite/libsqlite/src/vdbe.lo ext/sqlite/libsqlite/src/attach.lo 
ext/sqlite/libsqlite/src/btree_rb.lo ext/sqlite/libsqlite/src/pragma.lo 
ext/sqlite/libsqlite/src/vacuum.lo ext/sqlite/libsqlite/src/copy.lo 
ext/sqlite/libsqlite/src/vdbeaux.lo ext/sqlite/libsqlite/src/date.lo 
ext/sqlite/libsqlite/src/where.lo ext/sqlite/libsqlite/src/trigger.lo 
regex/regcomp.lo regex/regexec.lo regex/regerror.lo regex/regfree.lo 
ext/standard/array.lo ext/standard/base64.lo 
ext/standard/basic_functions.lo ext/standard/browscap.lo 
ext/standard/crc32.lo ext/standard/crypt.lo ext/standard/cyr_convert.lo 
ext/standard/datetime.lo ext/standard/dir.lo ext/standard/dl.lo 
ext/standard/dns.lo ext/standard/exec.lo ext/standard/file.lo 
ext/standard/filestat.lo ext/standard/flock_compat.lo 
ext/standard/formatted_print.lo ext/standard/fsock.lo 
ext/standard/head.lo ext/standard/html.lo ext/standard/image.lo 
ext/standard/info.lo ext/standard/iptc.lo ext/standard/lcg.lo 
ext/standard/link.lo ext/standard/mail.lo ext/standard/math.lo 
ext/standard/md5.lo ext/standard/metaphone.lo ext/standard/microtime.lo 
ext/standard/pack.lo ext/standard/pageinfo.lo ext/standard/quot_print.lo 
ext/standard/rand.lo ext/standard/reg.lo ext/standard/soundex.lo 
ext/standard/string.lo ext/standard/scanf.lo ext/standard/syslog.lo 
ext/standard/type.lo ext/standard/uniqid.lo ext/standard/url.lo 
ext/standard/url_scanner.lo ext/standard/var.lo 
ext/standard/versioning.lo ext/standard/assert.lo 
ext/standard/strnatcmp.lo ext/standard/levenshtein.lo 
ext/standard/incomplete_class.lo ext/standard/url_scanner_ex.lo 
ext/standard/ftp_fopen_wrapper.lo ext/standard/http_fopen_wrapper.lo 
ext/standard/php_fopen_wrapper.lo ext/standard/credits.lo 
ext/standard/css.lo ext/standard/var_unserializer.lo 
ext/standard/ftok.lo ext/standard/sha1.lo ext/standard/user_filters.lo 
ext/standard/uuencode.lo ext/standard/filters.lo 
ext/standard/proc_open.lo ext/standard/streamsfuncs.lo 
ext/standard/http.lo ext/tokenizer/tokenizer.lo ext/xml/xml.lo 
ext/xml/compat.lo ext/xmlreader/php_xmlreader.lo 
ext/xmlwriter/php_xmlwriter.lo TSRM/TSRM.lo TSRM/tsrm_strtok_r.lo 
TSRM/tsrm_virtual_cwd.lo main/main.lo main/snprintf.lo main/spprintf.lo 
main/php_sprintf.lo main/safe_mode.lo main/fopen_wrappers.lo 
main/alloca.lo main/php_scandir.lo main/php_ini.lo main/SAPI.lo 
main/rfc1867.lo main/php_content_types.lo main/strlcpy.lo 
main/strlcat.lo main/mergesort.lo main/reentrancy.lo 
main/php_variables.lo main/php_ticks.lo main/network.lo 
main/php_open_temporary_file.lo main/php_logos.lo main/output.lo 
main/streams/streams.lo main/streams/cast.lo main/streams/memory.lo 
main/streams/filter.lo main/streams/plain_wrapper.lo 
main/streams/userspace.lo main/streams/transports.lo 
main/streams/xp_socket.lo main/streams/mmap.lo 
Zend/zend_language_parser.lo Zend/zend_language_scanner.lo 
Zend/zend_ini_parser.lo Zend/zend_ini_scanner.lo Zend/zend_alloc.lo 
Zend/zend_compile.lo Zend/zend_constants.lo Zend/zend_dynamic_array.lo 
Zend/zend_execute_API.lo Zend/zend_highlight.lo Zend/zend_llist.lo 
Zend/zend_opcode.lo Zend/zend_operators.lo Zend/zend_ptr_stack.lo 
Zend/zend_stack.lo Zend/zend_variables.lo Zend/zend.lo Zend/zend_API.lo 
Zend/zend_extensions.lo Zend/zend_hash.lo Zend/zend_list.lo 
Zend/zend_indent.lo Zend/zend_builtin_functions.lo Zend/zend_sprintf.lo 
Zend/zend_ini.lo Zend/zend_qsort.lo Zend/zend_multibyte.lo 
Zend/zend_ts_hash.lo Zend/zend_stream.lo Zend/zend_iterators.lo 
Zend/zend_interfaces.lo Zend/zend_exceptions.lo Zend/zend_strtod.lo 
Zend/zend_objects.lo Zend/zend_object_handlers.lo 
Zend/zend_objects_API.lo Zend/zend_mm.lo Zend/zend_default_classes.lo 
Zend/zend_execute.lo sapi/cli/php_cli.lo sapi/cli/php_cli_readline.lo 
sapi/cli/getopt.lo main/internal_functions_cli.lo -lcrypt -lcrypt 
-lmysqlclient -lsybdb -lresolv -lm -ldl -lnsl -lxml2 -lz -lm -lxml2 -lz 
-lm -lxml2 -lz -lm -lcrypt -lxml2 -lz -lm -lxml2 -lz -lm -lxml2 -lz -lm 
-lcrypt  -o sapi/cli/php






   



More information about the FreeTDS mailing list