i configured openemr and when i try to go to application it throws error
Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user ‘openemr’@‘localhost’ (using password: YES) in /www/openemr/library/adodb/drivers/adodb-mysql.inc.php on line 343
Check that mysqld is running.
But my mysql database is at different system (ie 192.68.1.107) and apache and php at ( 192.68.1.25 ) , and how it is possible to change the configuration because it throwing the above error
in the file openemr/library/sqlconf.php the $host is the name of the server containing the mysql database. What you are describing is a more advanced setup. The current setup routine assumes that you are installing on a machine that contains the mysql database.
You will need to grant permissions on the database to the openemr user to access mysql from a remote machine. You will need to grant privileges to:
‘openemr’@192.68.1.25
These privileges will need to be granted on the 192.68.1.107 machine. You will also need to start the mysql server with privileges that allow networking. (i.e. the "skip networking command will prevent this from working.
In the openemr/library/sqlconf.php file you will need to change
$host = ‘localhost’;
to read:
$host = ‘192.68.1.107’;
// OpenEMR
// MySQL Config
// Referenced from sql.inc
Again, this is an advanced setup that should work but may require some debugging. If you don’t understand what I’m taking about above you may need to reconsider setting up your database this way.