What if you run
mpirun -np 1 mysqlconnect
on your frontend (aka compilation and/or submission) host ?
does it work as expected ?
if yes, then this likely indicates a MySQL permission/configuration issue.
for example, it accepts connections from 'someUser' only from one node,
or maybe mysqld is running on your frontend and only accepts connections
from the unix socket
(and you need to enable TCP (at least) if you want to allow connections
from remote hosts)
Cheers,
Gilles
On 8/9/2016 8:43 AM, alev mutlu wrote:
Hello,
I am trying to connect to MySQL with the following
if (!mysql_real_connect(connection,server,user,password,database, 0,
NULL, 0)) {
printf("Conection error : %s\n", mysql_error(connection));
exit(1);
}
The code compiles with g++ and works fine.
It compiles with mpicxx as well but when run through pbs script
mpirun -np1-hostfile$PBS_NODEFILEmysqlconnect
I get a run time error
Conection error : Access denied for user 'someUser'@'node2' (using
password: YES)
I guess mysql itself adds the @ "node2" and my connection fails.
How can I prevent this, any suggestions?
thanks in advance
_alev
_______________________________________________
users mailing list
users@lists.open-mpi.org
https://rfd.newmexicoconsortium.org/mailman/listinfo/users
_______________________________________________
users mailing list
users@lists.open-mpi.org
https://rfd.newmexicoconsortium.org/mailman/listinfo/users
