CLI problem

whoami

I posted this in the database section and did not get any meaningful help. So I repost it here and hope the high volume in this section will give me some help.

Here is the problem I am facing: I am using PHP 5.0.3 and MySql 4.1.10. PHP works with MySql well as an Apache module. However, when I run php as a CLI script and try to connect to MySql, no sql query seems to be executed (I do not get anything for simple "select * from ..." query). There is no error message either. I actually tried to pass in a none-existing database, invalid username/password when connect to MySql for debug purpose, I still receive no error message. Does someone know what possibly goes wrong? I can run php CLI script without problem if it does not access MySql (for example, print out "hello world").

Here is phpinfo() output related to MySql config:

mysql

MySQL Support => enabled
Active Persistent Links => 0
Active Links => 0
Client API version => 4.1.10a
MYSQL_MODULE_TYPE => external
MYSQL_SOCKET => /tmp/mysql.sock
MYSQL_INCLUDE => -I/usr/local/mysql/include
MYSQL_LIBS => -L/usr/local/mysql/lib -lmysqlclient

Directive => Local Value => Master Value
mysql.allow_persistent => On => On
mysql.connect_timeout => 60 => 60
mysql.default_host => no value => no value
mysql.default_password => no value => no value
mysql.default_port => no value => no value
mysql.default_socket => no value => no value
mysql.default_user => no value => no value
mysql.max_links => Unlimited => Unlimited
mysql.max_persistent => Unlimited => Unlimited
mysql.trace_mode => Off => Off

I desparately want to get over this problem. Any enlightment will be greatly appreciated.

thorpe

i know on my machine, my php cli is not in any way related to my mod_php used for web developement. in fact my cli is only php-4.x.x while my mod_php is php-5.0.4.

so... what comes up in a phpinfo() function run through a web browser using mod_php has nothing to do with my cli.

that being said, you may have a different setup.

anyway, try running this from the command line to see what version of cli your running.

php -v

i have a feeling you may be using an older cli version, and that this version might not be compatible with your mysql. php-4.x.x will not work (there are workarounds) with mysql 4.1.10 because of new password stuff in mysql.

i might be way off... but worth looking at.

whoami

Sorry for the late reply. I was sidetracked in the past couple of days.

I actually ran phpinfo() from a CLI program. So it should be the correct version for CLI configuration.

In addition, here is the output of php -v:
PHP 5.0.3 (cli) (built: Mar 25 2005 23:23:10)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v2.0.3, Copyright (c) 1998-2004 Zend Technologies

It seems that I am running the same version of CLI as apache module.

Any further thoughts?

Thanks in advance.

bradgrafelman

MySQL 4.1 you say? Are you using [man]MySQL[/man] functions or [man]MySQLi[/man] functions?

whoami

It is MySql function. Just curious, what is the possible difference if using MySqli functions?

bradgrafelman

MySQL 4.1 introduced a new password algorithm among other features. If you are using the new password algorithm (it'd take some messing with to NOT use it, so chances are, you are), then MySQL functions SHOULDN'T work.

MySQLi functions were redesigned to communicate better with the new version of the MySQL server.

Follow the link for MySQLi in my previous post for more information.

EDIT: May it be known that I have no knowledge nor experience in working with MySQL 4.1 ... I've always used 4.0 and I plan to stick with it for a while 😉