08-24-2015, 07:59 PM
Is there anyone had a solution for this error? I had installed a opendocman on windows 8.1 and it works fine, I created a database and the username for MYSQL user and password on Phpmyadmin.
These are the steps that I am doing.
1. I unzip the file (opendocman) to the server(localhost) in the www folder
2. I had create a database, mysql database name and password on phpmyadmin
3. Browsing for localhost:8080/opendocuman on any browsers
4. This message appears " Looks like this is a new installation because we did not find a config.php file or we cannot locate the database. We need to create a config.php file now: Create a file...
5. I click on creating a configuration file
6. I just proceed by following the instructions, and to fill out the database name, username (mysql) and password (mysql). I just enter the name of the database that I already created on the phpmyadmin in the database table. I had import my database from the database.sql
7. When I click next this error appears Error!: SQLSTATE[HY000] [1045] Access denied for user 'testing'@'localhost' (using password: YES) Please make sure you have created a database
8. I go to the config.php file and looking for this error see the code for this file.
<?php
/*
config.php - OpenDocMan database config file
Copyright © 2011 Stephen Lawrence Jr.
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*/
// Eliminate multiple inclusion of config.php
if (!defined('config')) {
define('config', 'true', false);
// config.php - useful variables/functions
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for [OpenDocMan */
define('DB_NAME', 'test');
/** MySQL database username */
define('DB_USER', 'testing');
/** MySQL database password */
define('DB_PASS', 'password');
/** MySQL hostname */
/* The MySQL server. It can also include a port number. e.g. "hostname:port" or a path to a
* local socket e.g. ":/path/to/socket" for the localhost. */
define('DB_HOST', 'localhost');
/**
* Prefix to append to each table name in the database (ex. odm_ would make the tables
* named "odm_users", "odm_data" etc. Leave this set to the default if you want to keep
* it the way it was. If you do change this to a different value, make sure it is either
* a clean-install, or you manually go through and re-name the database tables to match.
* @DEFAULT 'odm_'
* @ARG String
*/
$GLOBALS['CONFIG']['db_prefix'] = 'odm_';
/*** DO NOT EDIT BELOW THIS LINE ***/
/** Absolute path to the OpenDocMan directory. */
if (!defined('ABSPATH')) {
define('ABSPATH', dirname(__FILE__) . '/');
}
}
Thank you please help, what I have done wrong.
These are the steps that I am doing.
1. I unzip the file (opendocman) to the server(localhost) in the www folder
2. I had create a database, mysql database name and password on phpmyadmin
3. Browsing for localhost:8080/opendocuman on any browsers
4. This message appears " Looks like this is a new installation because we did not find a config.php file or we cannot locate the database. We need to create a config.php file now: Create a file...
5. I click on creating a configuration file
6. I just proceed by following the instructions, and to fill out the database name, username (mysql) and password (mysql). I just enter the name of the database that I already created on the phpmyadmin in the database table. I had import my database from the database.sql
7. When I click next this error appears Error!: SQLSTATE[HY000] [1045] Access denied for user 'testing'@'localhost' (using password: YES) Please make sure you have created a database
8. I go to the config.php file and looking for this error see the code for this file.
<?php
/*
config.php - OpenDocMan database config file
Copyright © 2011 Stephen Lawrence Jr.
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*/
// Eliminate multiple inclusion of config.php
if (!defined('config')) {
define('config', 'true', false);
// config.php - useful variables/functions
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for [OpenDocMan */
define('DB_NAME', 'test');
/** MySQL database username */
define('DB_USER', 'testing');
/** MySQL database password */
define('DB_PASS', 'password');
/** MySQL hostname */
/* The MySQL server. It can also include a port number. e.g. "hostname:port" or a path to a
* local socket e.g. ":/path/to/socket" for the localhost. */
define('DB_HOST', 'localhost');
/**
* Prefix to append to each table name in the database (ex. odm_ would make the tables
* named "odm_users", "odm_data" etc. Leave this set to the default if you want to keep
* it the way it was. If you do change this to a different value, make sure it is either
* a clean-install, or you manually go through and re-name the database tables to match.
* @DEFAULT 'odm_'
* @ARG String
*/
$GLOBALS['CONFIG']['db_prefix'] = 'odm_';
/*** DO NOT EDIT BELOW THIS LINE ***/
/** Absolute path to the OpenDocMan directory. */
if (!defined('ABSPATH')) {
define('ABSPATH', dirname(__FILE__) . '/');
}
}
Thank you please help, what I have done wrong.