Openemr/acl_setup.php phpgacl error

duanemorrow wrote on Tuesday, September 19, 2006:

Installing OpenEMR on new AMD64X2 Gentoo system. Mysql server
The phpgacl/setup.php page successfully opened and completed.

Info from gacl.ini.php
  db_type = “mysql”
  db_host = “localhost”
  db_user = “root”
  db_password = “mychosenpassword“
  db_name = “gacl”
  db_table_prefix = “”

My Gentoo system is using UTF-8 as default character set.
To create the gacl database I used:   Create database gacl DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
I then executed : Grant all on gacl.* to root@localhost identified by ‘mychosenpassword’;

When I open the openemr/acl_setup.php page I get the following:

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user ‘root’@‘localhost’ (using password: NO) in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 376

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user ‘root’@‘localhost’ (using password: NO) in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 376

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 218

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 218

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 218

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 218

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 218

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 218

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 218

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 218

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 218

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 218

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 218

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /var/www/localhost/htdocs/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 218
OpenEMR ACL Setup

All done!

sunsetsystems wrote on Wednesday, September 20, 2006:

Looks like gacl.class.php needs to know about your password.  The default value in there is empty.

Rod
www.sunsetsystems.com

duanemorrow wrote on Wednesday, September 20, 2006:

That solved the problem.