"Server installation timezone error"

micheljanos

When I try to install the Server I got the following error message:

Image: https://us.v-cdn.net/6030995/uploads/editor/99/k2e845k7fv7n.png

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

Thanks

Michel

Find more posts tagged with

AI Studio

Server

Errors

Installation

Accepted answers

All comments

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

micheljanos

Hi Jonas,

When doing your sugestion I got this error.

Image: https://us.v-cdn.net/6030995/uploads/editor/eb/gyywqbfahh30.png

Regards,

Michel

mmichel

Hello Michel,

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

Image: https://us.v-cdn.net/6030995/uploads/editor/ll/i6ykeymvmyy1.png

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

micheljanos

Hi Marcel,

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

Image: https://us.v-cdn.net/6030995/uploads/editor/ne/8smw5f4wbmdd.png

Image: https://us.v-cdn.net/6030995/uploads/editor/qv/lgily039837v.png

mmichel

Hi Michel,

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

Cheers,
Marcel

micheljanos

Hi marcel.
Thanks again. Hope is this what you asked.

Regards,
Michel

Image: https://us.v-cdn.net/6030995/uploads/editor/1h/tw26zqraww0q.png

mmichel

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

micheljanos

Only one file here...

Image: https://us.v-cdn.net/6030995/uploads/editor/93/tfg29jxyrhyk.png

mmichel

What happens if you start the server via the standalone.bat (rapidminer-server-9.1.0/bin)?
Do you get any output there?

micheljanos

Aparentelly nothing happens.

mmichel

So, no command window opens?

micheljanos

Correct. It flashes a kind of prompt and than nothing happens.

mmichel

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.

micheljanos

Image: https://us.v-cdn.net/6030995/uploads/editor/5o/imswd6ywxlbx.png

mmichel

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.

micheljanos

Image: https://us.v-cdn.net/6030995/uploads/editor/x8/6q5fuue0xxgd.png

mmichel

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.