Click to See Complete Forum and Search --> : Pear DB and MySQL


Anon
02-04-2002, 06:21 PM
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

Anon
02-04-2002, 07:27 PM
er, you need to change the name from php.ini-dist to php.ini

Anon
02-04-2002, 07:43 PM
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...

Anon
02-04-2002, 07:47 PM
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 =