Help!! mysql-php

Your configuration looks rather sparse. You're missing quite a few things.

In particular to get Joomla working:

MySQL, XML, and Zlib
Click to expand...

How did you update PHP?
 
check it now. It's there, but I don't think I have the location correct for mysql
 
yes I do..

with-mysql-dir=/usr'

Also.. all of this worked before updating php.. these module settings will not harm my databases will they?
 
Uh, no you don't.

You have --with-mysql-dir, that is not the same as --with-mysql.

I'm not even sure if --with-mysql-dir is a valid configuration line option.
 
Also, if the mysql extension is correctly called and configured, your phpinfo.php page will have a section for mysql -- yours does not.
 
Ok.. my php is completely hosed.. I cannot access any of my Joomla sites and I have no idea what to do . I cannot seem to load the mysql module correctly. Nothing works. 7 hours of this.. customers are calling.. Probably the worst day ever. I think I'm going to get sick..
 
How are you compiling/update PHP? You didn't answer that earlier.
 
rpmfind and webmin. I loaded php-1.2.5 for i386 fedora 7, which is what I have. After loading it, I saw that there was no mysql modules loaded. I've since removed 5.2.5 and put back 5.2.2. But It seems that made it worse. www.redbirdhost.com/phpinfo.php .

The only hope I see is that webmin and squirrel mail actaully work. Roundcube and joomla do not.

I guess I need to know what I can reload without messing up my current databases.
 
are you using customapache or custombuild?

if you use customapache, you should be able to find the original php downloaded during directadmin setup at:

/usr/local/directadmin/customapache

there is a file called configure.php there, you should compile your newer version of php using the configure command inside that file.

1. download the latest php source from http://www.php.net/downloads.php#v5 (I choose .tar.gz one)

2. untar the downloaded .tar.gz

3. go into the extracted directory and run the configure command you find inside the configure.php file that you find inside the customapache folder

4. run "make" then "make install"

I have not tried the above myself since I think my server have different config. from yours. Try at your own risk
 
Last edited:
Thank you for using PHP.

[root@s33 php-5.2.5]# make
/bin/sh /usr/local/directadmin/customapache/php-5.2.5/libtool --silent --preserv e-dup-deps --mode=compile gcc -I/usr/local/directadmin/customapache/php-5.2.5/ex t/pdo_sqlite/sqlite/src -DPDO_SQLITE_BUNDLED=1 -DSQLITE_OMIT_CURSOR -DTHREADSAFE =0 -I/usr/local/directadmin/customapache/php-5.2.5/ext -Iext/pdo_sqlite/ -I/usr/ local/directadmin/customapache/php-5.2.5/ext/pdo_sqlite/ -DPHP_ATOM_INC -I/usr/l ocal/directadmin/customapache/php-5.2.5/include -I/usr/local/directadmin/customa pache/php-5.2.5/main -I/usr/local/directadmin/customapache/php-5.2.5 -I/usr/incl ude/libxml2 -I/usr/local/directadmin/customapache/php-5.2.5/ext/date/lib -I/usr/ local/directadmin/customapache/php-5.2.5/TSRM -I/usr/local/directadmin/customapa che/php-5.2.5/Zend -I/usr/include -g -O2 -c /usr/local/directadmin/customapa che/php-5.2.5/ext/pdo_sqlite/sqlite/src/parse.c -o ext/pdo_sqlite/sqlite/src/par se.lo
/bin/sh /usr/local/directadmin/customapache/php-5.2.5/libtool --silent --preserv e-dup-deps --mode=compile gcc -Iext/standard/ -I/usr/local/directadmin/customap ache/php-5.2.5/ext/standard/ -DPHP_ATOM_INC -I/usr/local/directadmin/customapach e/php-5.2.5/include -I/usr/local/directadmin/customapache/php-5.2.5/main -I/usr/ local/directadmin/customapache/php-5.2.5 -I/usr/include/libxml2 -I/usr/local/dir ectadmin/customapache/php-5.2.5/ext/date/lib -I/usr/local/directadmin/customapac he/php-5.2.5/TSRM -I/usr/local/directadmin/customapache/php-5.2.5/Zend -I/usr /include -g -O2 -c /usr/local/directadmin/customapache/php-5.2.5/ext/standard/i nfo.c -o ext/standard/info.lo
/bin/sh /usr/local/directadmin/customapache/php-5.2.5/libtool --silent --preserv e-dup-deps --mode=compile gcc -Imain/ -I/usr/local/directadmin/customapache/php -5.2.5/main/ -DPHP_ATOM_INC -I/usr/local/directadmin/customapache/php-5.2.5/incl ude -I/usr/local/directadmin/customapache/php-5.2.5/main -I/usr/local/directadmi n/customapache/php-5.2.5 -I/usr/include/libxml2 -I/usr/local/directadmin/customa pache/php-5.2.5/ext/date/lib -I/usr/local/directadmin/customapache/php-5.2.5/TSR M -I/usr/local/directadmin/customapache/php-5.2.5/Zend -I/usr/include -g -O2 -c main/internal_functions.c -o main/internal_functions.lo
/bin/sh /usr/local/directadmin/customapache/php-5.2.5/libtool --silent --preserv e-dup-deps --mode=link gcc -export-dynamic -I/usr/include -g -O2 ext/libxml/ libxml.lo ext/pcre/pcrelib/pcre_chartables.lo ext/pcre/pcrelib/pcre_ucp_searchfu ncs.lo ext/pcre/pcrelib/pcre_compile.lo ext/pcre/pcrelib/pcre_config.lo ext/pcre /pcrelib/pcre_exec.lo ext/pcre/pcrelib/pcre_fullinfo.lo ext/pcre/pcrelib/pcre_ge t.lo ext/pcre/pcrelib/pcre_globals.lo ext/pcre/pcrelib/pcre_info.lo ext/pcre/pcr elib/pcre_maketables.lo ext/pcre/pcrelib/pcre_newline.lo ext/pcre/pcrelib/pcre_o rd2utf8.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/pcreli b/pcre_valid_utf8.lo ext/pcre/pcrelib/pcre_version.lo ext/pcre/pcrelib/pcre_xcla ss.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_exte nd.lo ext/dom/characterdata.lo ext/dom/documenttype.lo ext/dom/domimplementation list.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/entityre ference.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 e xt/dom/userdatahandler.lo ext/filter/filter.lo ext/filter/sanitizing_filters.lo ext/filter/logical_filters.lo ext/filter/callback_filter.lo ext/hash/hash.lo ext /hash/hash_md.lo ext/hash/hash_sha.lo ext/hash/hash_ripemd.lo ext/hash/hash_hava l.lo ext/hash/hash_tiger.lo ext/hash/hash_gost.lo ext/hash/hash_snefru.lo ext/ha sh/hash_whirlpool.lo ext/hash/hash_adler32.lo ext/hash/hash_crc32.lo ext/iconv/i conv.lo ext/json/json.lo ext/json/utf8_to_utf16.lo ext/json/utf8_decode.lo ext/j son/JSON_parser.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/pdo_sqlite/pdo_sqlite.lo ext/pdo_ sqlite/sqlite_driver.lo ext/pdo_sqlite/sqlite_statement.lo ext/pdo_sqlite/sqlite /src/attach.lo ext/pdo_sqlite/sqlite/src/auth.lo ext/pdo_sqlite/sqlite/src/btree .lo ext/pdo_sqlite/sqlite/src/build.lo ext/pdo_sqlite/sqlite/src/callback.lo ext /pdo_sqlite/sqlite/src/date.lo ext/pdo_sqlite/sqlite/src/delete.lo ext/pdo_sqlit e/sqlite/src/expr.lo ext/pdo_sqlite/sqlite/src/func.lo ext/pdo_sqlite/sqlite/src /hash.lo ext/pdo_sqlite/sqlite/src/insert.lo ext/pdo_sqlite/sqlite/src/legacy.lo ext/pdo_sqlite/sqlite/src/main.lo ext/pdo_sqlite/sqlite/src/os_unix.lo ext/pdo_ sqlite/sqlite/src/os_win.lo ext/pdo_sqlite/sqlite/src/os.lo ext/pdo_sqlite/sqlit e/src/pager.lo ext/pdo_sqlite/sqlite/src/pragma.lo ext/pdo_sqlite/sqlite/src/pre pare.lo ext/pdo_sqlite/sqlite/src/printf.lo ext/pdo_sqlite/sqlite/src/random.lo ext/pdo_sqlite/sqlite/src/select.lo ext/pdo_sqlite/sqlite/src/table.lo ext/pdo_s qlite/sqlite/src/tokenize.lo ext/pdo_sqlite/sqlite/src/analyze.lo ext/pdo_sqlite /sqlite/src/complete.lo ext/pdo_sqlite/sqlite/src/trigger.lo ext/pdo_sqlite/sqli te/src/update.lo ext/pdo_sqlite/sqlite/src/utf.lo ext/pdo_sqlite/sqlite/src/util .lo ext/pdo_sqlite/sqlite/src/vacuum.lo ext/pdo_sqlite/sqlite/src/vdbeapi.lo ext /pdo_sqlite/sqlite/src/vdbeaux.lo ext/pdo_sqlite/sqlite/src/vdbe.lo ext/pdo_sqli te/sqlite/src/vdbemem.lo ext/pdo_sqlite/sqlite/src/where.lo ext/pdo_sqlite/sqlit e/src/parse.lo ext/pdo_sqlite/sqlite/src/opcodes.lo ext/pdo_sqlite/sqlite/src/al ter.lo ext/pdo_sqlite/sqlite/src/vdbefifo.lo ext/pdo_sqlite/sqlite/src/vtab.lo e xt/pdo_sqlite/sqlite/src/loadext.lo ext/posix/posix.lo ext/reflection/php_reflec tion.lo ext/session/session.lo ext/session/mod_files.lo ext/session/mod_mm.lo ex t/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/s pl_observer.lo ext/sqlite/sqlite.lo ext/sqlite/sess_sqlite.lo ext/sqlite/pdo_sql ite2.lo ext/sqlite/libsqlite/src/opcodes.lo ext/sqlite/libsqlite/src/parse.lo ex t/sqlite/libsqlite/src/encode.lo ext/sqlite/libsqlite/src/auth.lo ext/sqlite/lib sqlite/src/btree.lo ext/sqlite/libsqlite/src/build.lo ext/sqlite/libsqlite/src/d elete.lo ext/sqlite/libsqlite/src/expr.lo ext/sqlite/libsqlite/src/func.lo ext/s qlite/libsqlite/src/hash.lo ext/sqlite/libsqlite/src/insert.lo ext/sqlite/libsql ite/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/sqlit e/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/uti l.lo ext/sqlite/libsqlite/src/vdbe.lo ext/sqlite/libsqlite/src/attach.lo ext/sql ite/libsqlite/src/btree_rb.lo ext/sqlite/libsqlite/src/pragma.lo ext/sqlite/libs qlite/src/vacuum.lo ext/sqlite/libsqlite/src/copy.lo ext/sqlite/libsqlite/src/vd beaux.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/b asic_functions.lo ext/standard/browscap.lo ext/standard/crc32.lo ext/standard/cr ypt.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_pr int.lo ext/standard/fsock.lo ext/standard/head.lo ext/standard/html.lo ext/stand ard/image.lo ext/standard/info.lo ext/standard/iptc.lo ext/standard/lcg.lo ext/s tandard/link.lo ext/standard/mail.lo ext/standard/math.lo ext/standard/md5.lo ex t/standard/metaphone.lo ext/standard/microtime.lo ext/standard/pack.lo ext/stand ard/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/sta ndard/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/s tandard/assert.lo ext/standard/strnatcmp.lo ext/standard/levenshtein.lo ext/stan dard/incomplete_class.lo ext/standard/url_scanner_ex.lo ext/standard/ftp_fopen_w rapper.lo ext/standard/http_fopen_wrapper.lo ext/standard/php_fopen_wrapper.lo e xt/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/strea msfuncs.lo ext/standard/http.lo ext/tokenizer/tokenizer.lo ext/tokenizer/tokeniz er_data.lo ext/xml/xml.lo ext/xml/compat.lo ext/xmlreader/php_xmlreader.lo ext/x mlwriter/php_xmlwriter.lo TSRM/TSRM.lo TSRM/tsrm_strtok_r.lo TSRM/tsrm_virtual_c wd.lo main/main.lo main/snprintf.lo main/spprintf.lo main/php_sprintf.lo main/sa fe_mode.lo main/fopen_wrappers.lo main/alloca.lo main/php_scandir.lo main/php_in i.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 ma in/streams/filter.lo main/streams/plain_wrapper.lo main/streams/userspace.lo mai n/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/z end_ini_scanner.lo Zend/zend_alloc.lo Zend/zend_compile.lo Zend/zend_constants.l o Zend/zend_dynamic_array.lo Zend/zend_execute_API.lo Zend/zend_highlight.lo Zen d/zend_llist.lo Zend/zend_opcode.lo Zend/zend_operators.lo Zend/zend_ptr_stack.l o Zend/zend_stack.lo Zend/zend_variables.lo Zend/zend.lo Zend/zend_API.lo Zend/z end_extensions.lo Zend/zend_hash.lo Zend/zend_list.lo Zend/zend_indent.lo Zend/z end_builtin_functions.lo Zend/zend_sprintf.lo Zend/zend_ini.lo Zend/zend_qsort.l o Zend/zend_multibyte.lo Zend/zend_ts_hash.lo Zend/zend_stream.lo Zend/zend_iter ators.lo Zend/zend_interfaces.lo Zend/zend_exceptions.lo Zend/zend_strtod.lo Zen d/zend_objects.lo Zend/zend_object_handlers.lo Zend/zend_objects_API.lo Zend/zen d_default_classes.lo Zend/zend_execute.lo sapi/cgi/cgi_main.lo sapi/cgi/getopt.l o main/internal_functions.lo -lcrypt -lcrypt -lrt -lresolv -lm -ldl -lnsl -lxml2 -lz -lm -lxml2 -lz -lm -lxml2 -lz -lm -lcrypt -lxml2 -lz -lm -lxml2 -lz -lm -lx ml2 -lz -lm -lcrypt -o sapi/cgi/php-cgi
ext/standard/.libs/html.o: In function `determine_charset':
/usr/local/directadmin/customapache/php-5.2.5/ext/standard/html.c:731: undefined reference to `mbstring_globals'
main/.libs/rfc1867.o: In function `substring_conf':
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:598: undefined refe rence to `php_mb_encoding_translation'
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:599: undefined refe rence to `php_mb_gpc_mbchar_bytes'
main/.libs/rfc1867.o: In function `php_ap_getword_conf':
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:623: undefined refe rence to `php_mb_encoding_translation'
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:625: undefined refe rence to `php_mb_gpc_encoding_detector'
main/.libs/rfc1867.o: In function `php_mb_flush_gpc_variables':
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:61: undefined refer ence to `php_mb_encoding_translation'
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:62: undefined refer ence to `php_mb_gpc_encoding_detector'
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:64: undefined refer ence to `php_mb_gpc_encoding_converter'
main/.libs/rfc1867.o: In function `rfc1867_post_handler':
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:849: undefined refe rence to `php_mb_encoding_translation'
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:944: undefined refe rence to `php_mb_encoding_translation'
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:1175: undefined ref erence to `php_mb_encoding_translation'
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:1183: undefined ref erence to `php_mb_gpc_encoding_detector'
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:1187: undefined ref erence to `php_mb_strrchr'
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:1188: undefined ref erence to `php_mb_strrchr'
/usr/local/directadmin/customapache/php-5.2.5/main/rfc1867.c:1185: undefined ref erence to `php_mb_gpc_encoding_converter'
main/.libs/output.o: In function `php_ob_init_named':
/usr/local/directadmin/customapache/php-5.2.5/main/output.c:440: undefined refer ence to `php_ob_gzhandler_check'
collect2: ld returned 1 exit status
make: *** [sapi/cgi/php-cgi] Error 1
Click to expand...



This is what I get after running make
 
This is my Configure.php

#!/bin/sh
./configure \
--with-apxs2 \
--with-curl \
--with-curl-dir=/usr/local/lib \
--with-gd \
--with-gd-dir=/usr/local \
--with-freetype \
--with-freetype-dir=/usr/local/lib
--with-gettext \
--with-jpeg-dir=/usr/local/lib \
--with-kerberos \
--with-mcrypt \
--with-mhash \
--with-mysql=/usr \
--with-pear \
--with-png-dir=/usr/local/lib \
--with-xml \
--with-zlib \
--with-zlib-dir=/usr/local/lib \
--with-zip \
--with-openssl \
--enable-bcmath \
--enable-calendar \
--enable-ftp \
--enable-magic-quotes \
--enable-sockets \
--enable-track-vars \
--enable-mbstring \
--enable-memory-limit
 
A lot of error :D

have you run the configure command before running make and make install.

.ie

go into the extracted php source directory and run command in the following order:

1.

./configure \
--with-apxs2 \
--with-curl \
--with-curl-dir=/usr/local/lib \
--with-gd \
--with-gd-dir=/usr/local \
--with-freetype \
--with-freetype-dir=/usr/local/lib
--with-gettext \
--with-jpeg-dir=/usr/local/lib \
--with-kerberos \
--with-mcrypt \
--with-mhash \
--with-mysql=/usr \
--with-pear \
--with-png-dir=/usr/local/lib \
--with-xml \
--with-zlib \
--with-zlib-dir=/usr/local/lib \
--with-zip \
--with-openssl \
--enable-bcmath \
--enable-calendar \
--enable-ftp \
--enable-magic-quotes \
--enable-sockets \
--enable-track-vars \
--enable-mbstring \
--enable-memory-limit

2.
make clean

3.
make

4.
make install

other than that, I can't think of any more suggestion.
May be leave to other forum members.:)
 
Ok... make clean seemed to fix my previous problem. Now I've done a make clean .. make . and a make install.. no errors. My php info still shows the old php info. Is there something else I'm missing?
 
under the php-source directory, there should be a folder called sapi/cli/

inside that directory, there is an php binary called something like php, you may try to copy it to /usr/local/bin (remember to backup the old one before you overwrite it)

then restart httpd

Take your own risk:)
 
hamiltonjm said:
Ok... make clean seemed to fix my previous problem. Now I've done a make clean .. make . and a make install.. no errors. My php info still shows the old php info. Is there something else I'm missing?
Click to expand...

when you run:

./configure \
--with-apxs2 \
--with-curl \
--with-curl-dir=/usr/local/lib \
--with-gd \
--with-gd-dir=/usr/local \
--with-freetype \
--with-freetype-dir=/usr/local/lib
--with-gettext \
--with-jpeg-dir=/usr/local/lib \
--with-kerberos \
--with-mcrypt \
--with-mhash \
--with-mysql=/usr \
--with-pear \
--with-png-dir=/usr/local/lib \
--with-xml \
--with-zlib \
--with-zlib-dir=/usr/local/lib \
--with-zip \
--with-openssl \
--enable-bcmath \
--enable-calendar \
--enable-ftp \
--enable-magic-quotes \
--enable-sockets \
--enable-track-vars \
--enable-mbstring \
--enable-memory-limit

are there any error message?
 
You must log in or register to reply here.
Back
Top