MySQL remote question

jimbo456 wrote on Tuesday, April 05, 2005:

I am trying to connect to a remote MySQL server. The localhost is slow. I copied the tables over to the new server, got by the connection issues and now get this error.

Warning: Missing argument 2 for helpfuldie() in /var/www/html/openemr/library/sql.inc on line 120

ERROR: query failed: select distinct name from groups (No Database Selected)

I suspect a rights issue but for the life of me can’t figure it out.

andres_paglayan wrote on Tuesday, April 05, 2005:

the no database selected in the error report looks like the reason in that output, have you already checked that out?

jimbo456 wrote on Tuesday, April 05, 2005:

I had a working system up and running. I changed $host in sqlconf.php from localhost to my server ip. Is this the only change i need to make? The no database selected error comes before I login. The software is supposed to select the database for me. Is there a change I need to make to $dbase.  Right now its ‘openemr’

drbowen wrote on Tuesday, April 05, 2005:

How much control do you have over the remote server?

The mysqld frequently limits connections to "localhost" and will not permit foreign IP connections.  This is the way I have my server setup.

If you have mysql root permission try:

GRANT ALL ON openemr.* TO openemr@192.168.x.x IDENTIFIED BY

drbowen wrote on Tuesday, April 05, 2005:

How much control do you have over the remote server?

The mysqld frequently limits connections to "localhost" and will not permit foreign IP connections.  This is the way I have my server setup.

If you have mysql root permission try:

GRANT ALL ON openemr.* TO openemr@192.168.x.x IDENTIFIED BY ‘yourpassword’;

If this doesn’t work you may have to check out how the mysqld was started and whether it will allow non-localhost connections.