Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Supported by

Linking MySQL and Jatos

jusporrerjusporrer
in JATOS

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

Comments

  • jusporrerjusporrer
    jatos_msql.JPG

    This is the log.

  • krikri

    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

  • jusporrerjusporrer

    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

  • krikri

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

  • jusporrerjusporrer
    image.png

    This is the output.

  • krikri
    edited April 2021

    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

  • jusporrerjusporrer

    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

  • krikri

    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

Sign In or Register to comment.
Sebastiaan Mathôt » v2.0.18 » Copyright 2011 — 2019 » Vanilla flavored » License

agen judi bola , sportbook, casino, togel, number game, singapore, tangkas, basket, slot, poker, dominoqq, agen bola. Semua permainan bisa dimainkan hanya dengan 1 ID. minimal deposit 50.000 ,- bonus cashback hingga 10% , diskon togel hingga 66% bisa bermain di android dan IOS kapanpun dan dimana pun. poker , bandarq , aduq, domino qq , dominobet. Semua permainan bisa dimainkan hanya dengan 1 ID. minimal deposit 10.000 ,- bonus turnover 0.5% dan bonus referral 20%. Bonus - bonus yang dihadirkan bisa terbilang cukup tinggi dan memuaskan, anda hanya perlu memasang pada situs yang memberikan bursa pasaran terbaik yaitu http://45.77.173.118/ Bola168. Situs penyedia segala jenis permainan poker online kini semakin banyak ditemukan di Internet, salah satunya TahunQQ merupakan situs Agen Judi Domino66 Dan BandarQ Terpercaya yang mampu memberikan banyak provit bagi bettornya. Permainan Yang Di Sediakan Dewi365 Juga sangat banyak Dan menarik dan Peluang untuk memenangkan Taruhan Judi online ini juga sangat mudah . Mainkan Segera Taruhan Sportbook anda bersama Agen Judi Bola Bersama Dewi365 Kemenangan Anda Berapa pun akan Terbayarkan. Tersedia 9 macam permainan seru yang bisa kamu mainkan hanya di dalam 1 ID saja. Permainan seru yang tersedia seperti Poker, Domino QQ Dan juga BandarQ Online. Semuanya tersedia lengkap hanya di ABGQQ. Situs ABGQQ sangat mudah dimenangkan, kamu juga akan mendapatkan mega bonus dan setiap pemain berhak mendapatkan cashback mingguan. ABGQQ juga telah diakui sebagai Bandar Domino Online yang menjamin sistem FAIR PLAY disetiap permainan yang bisa dimainkan dengan deposit minimal hanya Rp.25.000. DEWI365 adalah Bandar Judi Bola Terpercaya & resmi dan terpercaya di indonesia. Situs judi bola ini menyediakan fasilitas bagi anda untuk dapat bermain memainkan permainan judi bola. Didalam situs ini memiliki berbagai permainan taruhan bola terlengkap seperti Sbobet, yang membuat DEWI365 menjadi situs judi bola terbaik dan terpercaya di Indonesia. Tentunya sebagai situs yang bertugas sebagai Bandar Poker Online pastinya akan berusaha untuk menjaga semua informasi dan keamanan yang terdapat di POKERQQ13. Kotakqq adalah situs Judi Poker Online Terpercayayang menyediakan 9 jenis permainan sakong online, dominoqq, domino99, bandarq, bandar ceme, aduq, poker online, bandar poker, balak66, perang baccarat, dan capsa susun. Dengan minimal deposit withdraw 15.000 Anda sudah bisa memainkan semua permaina pkv games di situs kami. Jackpot besar,Win rate tinggi, Fair play, PKV Games