v2.db.SFSDBManager and MySQL

li_ramen07 · Post by **li_ramen07** » 25 Jul 2011, 13:59

Hi All,

We had just setup our MySQL db & sfs2x server and encountered the following error. Anyone knows what causes this? Do we need to configure anything?

Code: Select all

26 Jul 2011 02:02:39,435 ERROR [main] v2.db.SFSDBManager     - 
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Exception: java.sql.SQLException
Message: null,  message from server: "Host '192.168.xx.xxx' is not allowed to connect to this MySQL server"
Description: The DBManager Test SQL failed
Please double check your SQL code and make sure that Database server is running.
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

Post by **Lapo** » 25 Jul 2011, 18:40

MySQL by default only accepts connections coming from the localhost. You must set it up correctly so that it can accept connections from the SFS2X instance (also make sure that login/pass are correctly matching)

cheers

li_ramen07 · Post by **li_ramen07** » 26 Jul 2011, 13:06

Thanks Lapo. We have already fixed this issue.

Just to verify, are delays expected in SFS writing logs? Sometimes, it takes minutes and even hours before we could see updates. Is this expected? The only way we could check errors in db connections and in sfs extensions are through the sfs logs so debugging for us consumes a lot of time.