🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

"Server installation timezone error"

User: "micheljanos"
New Altair Community Member
Updated by Jocelyn
When I try to install the Server I got the following error message:


Can someone tell me how do change the timezone in mysql/JDBC driver?

Thanks

Michel

Find more posts tagged with

Sort by:
1 - 17 of 171
    User: "jwpfau"
    Altair Employee
    Updated by jwpfau
    Hi Michel, 

    you can overwrite the timezone setting under Connections -> Manage Database Connections 

    Select the connection that has the issue and append ?serverTimezone=America/Sao_Paulo to the "Database scheme" field.
    If the field already contains a questionmark use an ampersand instead.

    For some JDBC drivers there is also a timezone setting under "Advanced..." available.

    Greetings,
    Jonas
    User: "micheljanos"
    New Altair Community Member
    OP
    Hi Jonas,

    When doing your sugestion I got this error.

    Regards,

    Michel


    User: "mmichel"
    New Altair Community Member
    Updated by mmichel
    Hello Michel,

    what happens if you add the timezone configuration to the schema value within the installer?



    Database schema: 
    db?useTimezone=true&serverTimezone=America/Sao_Paulo

    Please note, that you need to exchange 'db' with your schema name.

    If you are still getting the error please provide some additional information:

    • OS and OS Timezone config
    • Java
    • MySQL server version, JDBC driver version
    • MySQL timezone settings via
      SELECT @@global.time_zone, @@session.time_zone;
    Cheers,
    Marcel
    User: "micheljanos"
    New Altair Community Member
    OP
    Hi Marcel,

    This worked, however, after completing installation I can't connect to localhost:8080/


    User: "mmichel"
    New Altair Community Member
    Hi Michel,

    seems your server start-up failed.
    Please attach the server.log file - you should find it within $server-home$/log.

    Cheers,
    Marcel
    User: "micheljanos"
    New Altair Community Member
    OP
    Hi marcel.
    Thanks again. Hope is this what you asked.

    Regards,
    Michel


    User: "mmichel"
    New Altair Community Member
    Hi Michel,

    this is the log of the MySQL Server. I would need the log file of the RapidMiner Server.
    The log file I'm looking for is stored in the Server Home Folder (\log\server.log). The default location on windows is C:\Users\<user-home>\rapidminer-server\rapidminer-server-home\<br>
    Cheers,
    Marcel
    User: "micheljanos"
    New Altair Community Member
    OP
    Only one file here...


    User: "mmichel"
    New Altair Community Member
    What happens if you start the server via the standalone.bat (rapidminer-server-9.1.0/bin)?
    Do you get any output there?
    User: "micheljanos"
    New Altair Community Member
    OP
    Aparentelly nothing happens.
    User: "mmichel"
    New Altair Community Member
    So, no command window opens?
    User: "micheljanos"
    New Altair Community Member
    OP
    Correct. It flashes a kind of prompt and than nothing happens.
    User: "mmichel"
    New Altair Community Member
    Ok, then open the command prompt manually, go to the directory and start the standalone.bat. By doing this the command prompt will stay open and you can copy the error messages.
    User: "micheljanos"
    New Altair Community Member
    OP

    User: "mmichel"
    New Altair Community Member
    This is the log of the bundled Job Agent and it looks fine. Could you also attach the log of the other command window? It should show the log lines of RapidMiner Server/ JBoss.
    User: "micheljanos"
    New Altair Community Member
    OP

    User: "mmichel"
    New Altair Community Member
    It seems that the Java VM cannot allocate the defined amount of memory.
    You can define the memory limit in the Server Home Folder (\configuration\max-memory.conf). But please make sure to fulfill the System Requirements.