Linking MySQL and Jatos

jusporrer

Hi All,

I have tried to look around for possible answers to this but couldn't find anything. I am having troubles connecting MySQL and Jatos. I have tried changing the configuration file and the command-line arguments. I also made sure MySQL was running on my server using the right port and that I can connect using the new username I created (and that it had access to the jatos database). One point that I wasn't sure about is if I need to use the public or the private IP of the cloud server I am using. But regardless of what I am trying to do, "Starting JATOS..." is printed on my terminal but Jatos does not start (however, my experiment is running smoothly when I am using the H2 db).

Please let me know what else I should try.

Thanks.

Juliana

jusporrer

This is the log.

kri

Hi Juliana!

Does your MySQL runs on the same host as JATOS? If so then you can just use 'localhost'. E.g. my database configuration in production.conf looks like:

# Database configuration - MySQL database
# ~~~~~
db.default.url = "jdbc:mysql://localhost/jatos6?characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC"
db.default.driver = "com.mysql.cj.jdbc.Driver"
db.default.username = "jatosuser"
db.default.password = "mypassword"

You probably saw the docs about JATOS + MySQL. It's usually straight forward with me.

Best,

Kristian

jusporrer

Hi Kristian,

Thank you very much for trying to help me. Unfortunately, It still does not work for me, even after following all the steps and making sure that I did everything correctly (and indeed it is pretty straightforward).

Using localhost as you suggested, I have now this error in my log:

2021-04-28 21:36:40,461 [ERROR] - o.h.e.j.s.SqlExceptionHelper - Table 'jatos.User_roleList' doesn't exist
2021-04-28 21:36:40,461 [WARN] - o.h.e.j.s.SqlExceptionHelper - SQL Error: 1146, SQLState: 42S02

Best,

Juliana

kri

Can you log into your MySQL, into JATOS' database there and run show tables; for me? What's the output?

jusporrer

This is the output.

kri

Strange, all tables there but the one. Maybe the database evolution got confused. Could you please try to set up the database anew: stop JATOS, drop the JATOS database, create it again, start JATOS.

And what version is your MySQL?

Best,

Kristian

jusporrer

Hi Kristian,

Thanks for helping me! It looks like deleting and creating the database again worked! However, it deleted my users and my study but at least now MySQL is connected (and it does not delete it again when I am reconnecting).

Best wishes,

Juliana

kri

I'm sorry about the deleted users and studies. I had the impression that this installation is still in the process of installation. But nice it's working now.

Best,

Kristian