php4 and mysql in 9.1 Pro, LAMP won't shine
I reckon I've just found out why I can't get the two to play, with any attempts to access databases giving invalid username/password or unable to acess the database. ----------------------------------------------- phpWebSite - Config File Creation Utility Unable to connect to your server's database. DB Error: connect failed Please reenter your settings. ----------------------------------------------- php-4.3.4, test.php says that php is configured --without-mysql, a strange decision as that rules out LAMP which just about every company using SuSE would require. './configure' '--prefix=/usr' '--datadir=/usr/share/php' '--mandir=/usr/share/man' '--bindir=/usr/bin' '--libdir=/usr/share' '--includedir=/usr/include' '--sysconfdir=/etc' '--with-_lib=lib' '--with-config-file-path=/etc' '--with-exec-dir=/usr/lib/php/bin' '--disable-debug' '--enable-inline-optimization' '--enable-memory-limit' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sigchild' '--disable-ctype' '--disable-session' '--without-mysql' '--disable-cli' '--without-pear' '--with-openssl' '--with-apxs2=/usr/sbin/apxs2-prefork' 'i586-suse-linux' I've built 4.3.6 from sources with mysql and pear, but I must go back and check my configure options as some options need to be selected to make sure they more closely match those SuSE used. Regards Sid. -- Sid Boyce .... Hamradio G3VBV and keen Flyer ===== LINUX ONLY USED HERE =====
On Thu, Jun 24, 2004 at 02:22:23PM +0100, Sid Boyce wrote:
I reckon I've just found out why I can't get the two to play, with any attempts to access databases giving invalid username/password or unable to acess the database.
Can you access it with other means?
----------------------------------------------- phpWebSite - Config File Creation Utility
Unable to connect to your server's database. DB Error: connect failed Please reenter your settings. -----------------------------------------------
Is the server running? Peter
poeml@cmdline.net wrote:
On Thu, Jun 24, 2004 at 02:22:23PM +0100, Sid Boyce wrote:
I reckon I've just found out why I can't get the two to play, with any attempts to access databases giving invalid username/password or unable to acess the database.
Can you access it with other means?
Yes, I forgot to add that I have full access to mysql from the command line and mysqlcc. I've filed a report with SuSE, I reckon it's simply that php4-4.3.4 from the distro is compiled with the configure option --without-mysql. php4-4.3.6 builds OK, but when checkinstall tries to build the rpm, it complains about apache2, the official sources for apache-2.0.49 build also complains about no being able to parse /etc/httpd-prefork.conf or something like that which didn't exist, so I copied httpd.conf.
----------------------------------------------- phpWebSite - Config File Creation Utility
Unable to connect to your server's database. DB Error: connect failed Please reenter your settings. -----------------------------------------------
Is the server running?
Peter
3459 ? S 0:00 /bin/sh /usr/bin/mysqld_safe --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql 3655 ? S 0:00 \_ /usr/sbin/mysqld-max --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock 4109 ? S 0:00 \_ /usr/sbin/mysqld-max --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock <snipped> 11131 ? Ss 0:01 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf 11197 ? S 0:00 \_ /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf 11198 ? S 0:00 \_ /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf 11199 ? S 0:00 \_ /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf 11200 ? S 0:00 \_ /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf 11201 ? S 0:00 \_ /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf 15218 ? S 0:00 \_ /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf Regards Sid. -- Sid Boyce .... Hamradio G3VBV and keen Flyer ===== LINUX ONLY USED HERE =====
On Fri, Jun 25, 2004 at 10:15:39PM +0100, Sid Boyce wrote:
I reckon I've just found out why I can't get the two to play, with any attempts to access databases giving invalid username/password or unable to acess the database.
Can you access it with other means?
Yes, I forgot to add that I have full access to mysql from the command line and mysqlcc. I've filed a report with SuSE, I reckon it's simply that php4-4.3.4 from the distro is compiled with the configure option --without-mysql. [...]
It is _not_ compiled without mysql support. But it is built as a module, and doesn't show up in the configure options. Install php4-mysql. Peter
poeml@cmdline.net wrote:
On Fri, Jun 25, 2004 at 10:15:39PM +0100, Sid Boyce wrote:
I reckon I've just found out why I can't get the two to play, with any attempts to access databases giving invalid username/password or unable to acess the database.
Can you access it with other means?
Yes, I forgot to add that I have full access to mysql from the command line and mysqlcc. I've filed a report with SuSE, I reckon it's simply that php4-4.3.4 from the distro is compiled with the configure option --without-mysql. [...]
It is _not_ compiled without mysql support. But it is built as a module, and doesn't show up in the configure options. Install php4-mysql.
Peter
Thanks, it must be some other problem as I have php4-mysql-4.3.4-43.6 installed. Regards Sid. -- Sid Boyce .... Hamradio G3VBV and keen Flyer ===== LINUX ONLY USED HERE =====
Think this was discussed first few days of SUSE 9.1 release.. But I thought SuSE had patched this. Did you do the You updates? Jerry On Tue, 2004-06-29 at 15:01, poeml@cmdline.net wrote:
On Fri, Jun 25, 2004 at 10:15:39PM +0100, Sid Boyce wrote:
I reckon I've just found out why I can't get the two to play, with any attempts to access databases giving invalid username/password or unable to acess the database.
Can you access it with other means?
Yes, I forgot to add that I have full access to mysql from the command line and mysqlcc. I've filed a report with SuSE, I reckon it's simply that php4-4.3.4 from the distro is compiled with the configure option --without-mysql. [...]
It is _not_ compiled without mysql support. But it is built as a module, and doesn't show up in the configure options. Install php4-mysql.
Peter
Jerome R. Westrick wrote:
Think this was discussed first few days of SUSE 9.1 release.. But I thought SuSE had patched this.
Did you do the You updates?
Jerry
<Stuff deleted> Yes, and I check the updates regularly. Regards Sid. -- Sid Boyce .... Hamradio G3VBV and keen Flyer ===== LINUX ONLY USED HERE =====
On Tue, Jun 29, 2004 at 04:31:46PM +0100, Sid Boyce wrote:
Jerome R. Westrick wrote:
Think this was discussed first few days of SUSE 9.1 release.. But I thought SuSE had patched this.
Did you do the You updates?
Jerry
<Stuff deleted> Yes, and I check the updates regularly. Regards Sid.
Okay, so you have updates installed which means your php4-mysql is functional, and you can access the database with other means (command line, mysqlcc). Though your PHP script will give you invalid password, according to what you wrote earlier:
I reckon I've just found out why I can't get the two to play, with any attempts to access databases giving invalid username/password or unable to acess the database.
Well, check your PHP script then. As well as you username/password. Are you aware that register_globalls defaults to off since php 4.2 or so? http://www.zend.com/zend/art/art-sweat4.php Peter
participants (3)
-
Jerome R. Westrick
-
poeml@cmdline.net
-
Sid Boyce