[dr_smit]

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

Configuration:
driver = mysql,Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'root'@'localhost' (using password: NO) in /var/www/html/phpgacl/adodb/drivers/adodb-mysql.inc.php on line 376
phpGACL Database Setup

Configuration:
driver = mysql,
host = localhost,
user = root,
database = gacl,
table prefix =
Testing database connection...
Failed! ERROR connecting to database,
are you sure you specified the proper host, user name, password, and database in admin/gacl_admin.inc.php?
Did you create the database, and give read/write permissions to "root" already?
host = localhost,
user = root,
database = gacl,
table prefix =
Testing database connection...
Failed! ERROR connecting to database,
are you sure you specified the proper host, user name, password, and database in admin/gacl_admin.inc.php?
Did you create the database, and give read/write permissions to "root" already?

[bigtomrodney]

You might want to give a little more information on what you're trying to do. It looks like you need to create a database and grant access for a user, then enter that user information into your configuration.

[dr_smit]

thanks for a quick response I have been trying to install OPENEMR a medical record keeping software for over an year following the instructions given at :

OpenEMR 2.8.2 Virtual Appliance Manual

I have progressed though very slowly to this far (No regrets! I have learned a lot)


Install php-GACL
Main TOC Link
Chapter Index Link
1. Download phpgacl-3.3.6.tar.gz file from:
SourceForge.net: Files
2. Enter below bolded instructions on command line as root user:
#log into root
su
#unpack and place program in its proper place
cd /var/www/html
tar xvzf /location/to/file/phpgacl-3.3.6.tar.gz
mv phpgacl-* phpgacl
#create the mySQL database
mysql
At mysql> prompt type:
CREATE DATABASE gacl;
exit
3. Start phpGACL Installer via : http://localhost/phpgacl/setup.php

this leads to a screen I have posted as 1st posting


I have tried SET PASSWORD FOR 'root'@'smitdesk' = PASSWORD ("mypassword")


and SET PASSWORD FOR 'root'@'localhost' = PASSWORD ("mypassword")

I can login as
mysql -p with mypassword
but not as
mysql (without -p)

[bigtomrodney]

Have you amended gacl_admin.inc.php to include the password you set? The error above seems to indicate that it is not attempting to use the password.

[dr_smit]

the instructions are to
mysql> CREATE DATABASE gacl;
mysql> exit

then log on to http;//localhost/phpgacl/setup.php

so I did not do bit extra to gacl

I may have done something to mysql but I have dropped every database and uninstalled mysql two- three times to do away this error but it is same..

[dr_smit]

<?php
BLAH BLAH BLAH....

require_once(dirname(__FILE__).'/../gacl.class.php');
require_once(dirname(__FILE__).'/../gacl_api.class.php');
require_once(dirname(__FILE__).'/gacl_admin_api.class.php');

// phpGACL Configuration file.
if ( !isset($config_file) ) {
# $config_file = '../gacl.ini.php';
$config_file = dirname(__FILE__).'/../gacl.ini.php';
}

//Values supplied in $gacl_options array overwrite those in the config file.
if ( file_exists($config_file) ) {
$config = parse_ini_file($config_file);

if ( is_array($config) ) {
if ( isset($gacl_options) ) {
$gacl_options = array_merge($config, $gacl_options);
} else {
$gacl_options = $config;
}
}
unset($config);
}

$gacl_api = new gacl_admin_api($gacl_options);

$gacl = &$gacl_api;

$db = &$gacl->db;

//Setup the Smarty Class.
require_once($gacl_options['smarty_dir'].'/Smarty.class.php');

$smarty = new Smarty;
$smarty->compile_check = TRUE;
$smarty->template_dir = $gacl_options['smarty_template_dir'];
$smarty->compile_dir = $gacl_options['smarty_compile_dir'];

/*
* Email address used in setup.php, please do not change.
*/
$author_email = 'ipso@snappymail.ca';

[dr_smit]

sorry I was away for few days.. Still waiting for a suggestion / So;lution