Hello there,
I have a big confusion on using Multisync as the server and MySQL as the database server.
In the login screen in the client side, I made a direct connection from the client to the MySQL server to check whether the entered username and password is valid or not. I also stored my MySQL username and password in the client, in order to connect to the sql server. Is it safe to do so?
mysql_real_connect(sqlhandler, "host", "user", "pass", "db_name", port, unixsocket, 0);
Is it possible for the client to request a login validation to the server (so that the server will check for the login and returns a response)?
Something like
bool ValidateLogin(char *szUsername, char *szPassword)
{
bool valid;
char *response;
// send login data to server
// receive server response
// if(response == "OK") valid = true;
// else if(response == "BAD") valid = false;
// return valid;
}
Perhaps?
Recently I was thinking of hosting an apache server along with the sql server, and validate the login through web request using libcurl.
Any kind of help would be appreciated
Thanks.
note: I'm new to Multisync, so don't bother me