"Server installation timezone error"

micheljanosmicheljanos Member Posts: 40 Maven
edited May 2019 in Help
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

Answers

  • jwpfaujwpfau Employee, Member Posts: 274 RM Engineering
    edited January 2019
    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
  • micheljanosmicheljanos Member Posts: 40 Maven
    Hi Jonas,

    When doing your sugestion I got this error.

    Regards,

    Michel


  • mmichelmmichel Employee, Member Posts: 129 RM Engineering
    edited January 2019
    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
  • micheljanosmicheljanos Member Posts: 40 Maven
    Hi Marcel,

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


  • mmichelmmichel Employee, Member Posts: 129 RM Engineering
    Hi Michel,

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

    Cheers,
    Marcel
  • micheljanosmicheljanos Member Posts: 40 Maven
    Hi marcel.
    Thanks again. Hope is this what you asked.

    Regards,
    Michel


  • mmichelmmichel Employee, Member Posts: 129 RM Engineering
    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
  • micheljanosmicheljanos Member Posts: 40 Maven
    Only one file here...


  • mmichelmmichel Employee, Member Posts: 129 RM Engineering
    What happens if you start the server via the standalone.bat (rapidminer-server-9.1.0/bin)?
    Do you get any output there?
  • micheljanosmicheljanos Member Posts: 40 Maven
    Aparentelly nothing happens.
  • mmichelmmichel Employee, Member Posts: 129 RM Engineering
    So, no command window opens?
  • micheljanosmicheljanos Member Posts: 40 Maven
    Correct. It flashes a kind of prompt and than nothing happens.
  • mmichelmmichel Employee, Member Posts: 129 RM Engineering
    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.
  • micheljanosmicheljanos Member Posts: 40 Maven

  • mmichelmmichel Employee, Member Posts: 129 RM Engineering
    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.
  • micheljanosmicheljanos Member Posts: 40 Maven

  • mmichelmmichel Employee, Member Posts: 129 RM Engineering
    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.
Sign In or Register to comment.