Find the answer to your Linux question:
Results 1 to 7 of 7
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' ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Newbie dr_smit's Avatar
    Join Date
    Dec 2006
    Location
    Raipur
    Posts
    171

    Please help me solve this dead end


    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?
    dr_smit
    Registered Linux User # 442381
    You get life once....... If you live right, once is enough!
    Mandriva 2008, CentOS 5, Sabalyon..

  2. #2
    Linux Guru bigtomrodney's Avatar
    Join Date
    Nov 2004
    Location
    Ireland
    Posts
    6,133
    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.

  3. #3
    Linux Newbie dr_smit's Avatar
    Join Date
    Dec 2006
    Location
    Raipur
    Posts
    171

    Let me know if anything else is needed, please help me

    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)
    dr_smit
    Registered Linux User # 442381
    You get life once....... If you live right, once is enough!
    Mandriva 2008, CentOS 5, Sabalyon..

  4. $spacer_open
    $spacer_close
  5. #4
    Linux Guru bigtomrodney's Avatar
    Join Date
    Nov 2004
    Location
    Ireland
    Posts
    6,133
    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.

  6. #5
    Linux Newbie dr_smit's Avatar
    Join Date
    Dec 2006
    Location
    Raipur
    Posts
    171

    followed the instruction to dot.. so many times

    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
    Registered Linux User # 442381
    You get life once....... If you live right, once is enough!
    Mandriva 2008, CentOS 5, Sabalyon..

  7. #6
    Linux Newbie dr_smit's Avatar
    Join Date
    Dec 2006
    Location
    Raipur
    Posts
    171

    here's gacl_admin.inc.php

    <?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
    Registered Linux User # 442381
    You get life once....... If you live right, once is enough!
    Mandriva 2008, CentOS 5, Sabalyon..

  8. #7
    Linux Newbie dr_smit's Avatar
    Join Date
    Dec 2006
    Location
    Raipur
    Posts
    171

    no help?

    sorry I was away for few days.. Still waiting for a suggestion / So;lution
    dr_smit
    Registered Linux User # 442381
    You get life once....... If you live right, once is enough!
    Mandriva 2008, CentOS 5, Sabalyon..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •