Click to See Complete Forum and Search --> : Pear DB and MySQL
Okay, so I have a working install of mysql and a working install of php 4.1.1 on an aix machine.
When I run a make test command, pear db fails...miserably.
Pear is installed in $HOME/php/pear
I've tried editing my php.ini-dist file to set the include_path to include the pear directory but no luck.
Mysql is installed on port 1157 -- do I need to specify that as well? I don't think php is seeing pear, but I could be wrong...how do i determine what is causing the problem? I can build and edit databases in mysql, but could the mysql installation be the problem?
Help!!
Thanks,
Brian
er, you need to change the name from php.ini-dist to php.ini
I've done that...I've also set the mysql port to 1157 in the php.ini file.
I can't run as superuser, so I can't so the make install -su command...
Here's what I have specified in the relevant sections of php.ini:
;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;
; UNIX: "/path1:/path2"
include_path = ".:/php/includes:/php/pear"
;
; Windows: "\path1;\path2"
;include_path = ".;c:\php\includes"
; The root of the PHP pages, used only if nonempty.
doc_root =
; The directory under which PHP opens the script using /~usernamem used only
; if nonempty.
user_dir =
; Directory in which the loadable extensions (modules) reside.
extension_dir = ./
; Whether or not to enable the dl() function. The dl() function does NOT work
; properly in multithreaded servers, such as IIS or Zeus, and is automatically
; disabled on them.
enable_dl = On
[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On
; Maximum number of persistent links. -1 means no limit.
mysql.max_persistent = -1
; Maximum number of links (persistent + non-persistent). -1 means no limit.
mysql.max_links = -1
; Default port number for mysql_connect(). If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
' at MYSQL_PORT.
mysql.default_port = 1157
; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =
; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =
; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =
; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo cfg_get_var("mysql.default_password")
; and reveal this password! And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =
PHP Builder
Copyright WebMediaBrands Inc. All Rights Reserved.