New Install Remote DB issue

[timothy....@gmail.com]

I setup a new installation of PWM and when attempting to setup the remote DB (the credentials work) it spews out the following error.

"unable to initialize database: exception initializing database service: 5051 ERROR_DB_UNAVAILABLE (error creating new table PWM_META: (conn=22) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'value TEXT )"

It's running on MariaDB 10.2 and PWM v1.8.0-SNAPSHOT b30195566 r5d05735d4446b4d3ad5f4e63f8f5ccc26037083c.

[timothy....@gmail.com]

I'm using the mariadb odbc driver v 2.2.0 with a database version of "Other" just for clarification.

[fpgr...@gmail.com]

Hi Timoty,

have you copied mariadb-java-client-2.1.2.jar or mysql-connector-java-5.0.8-bin.jar to directory /var/lib/tomcat/webapps/pwm/WEB-INF/lib/ ?

Best regards,

[timothy....@gmail.com]

I uploaded mariadb-java-client-2.2.0.jar via the PWM UI. By the sounds of the error message it seems to be an issue with the SQL table creation (since the it is successfully connecting) and I'm using a database type of "Other".

[fpgr...@gmail.com]

Hi Timothy,

please review your configuration and checks

Could you tell me your email to sent you my configuration ?

Please, copy mariadb-java-client.2.1.2.jar to directory, you also use mysql JDBC driver.

Best regards

[Felix Pablo Grande Ramos]

Hi Timothy,

please review your configuration and checks

I've attached my configuration

Please, copy mariadb-java-client.2.1.2.jar to directory, you also use mysql JDBC driver.

Best regards,

--
You received this message because you are subscribed to a topic in the Google Groups "pwm-general" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/pwm-general/uvGDPvLzI6I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to pwm-general+unsubscribe@googlegroups.com.
To post to this group, send email to pwm-g...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pwm-general/d955627c-625c-40fa-9f37-fffd1ff4d023%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Félix Pablo Grande Ramos

“Mi conciencia tiene para mí más peso que la opinión de todo el mundo.”

Marco Tulio Cicerón.

[timothy....@gmail.com]

On Monday, November 27, 2017 at 2:41:19 PM UTC-6, timothy....@gmail.com wrote:

Just wanted to let everyone know, I undeployed build 30195566 and deployed 28700112 on the "broken" system. 28700112 is working properly with the exact same database/user/password/config that 30195566 is failing with due to the issue being with the SQL syntax and not the DB connection itself.

[haiz...@googlemail.com]

Hi. I can't find the build numbers. Can you tell me which Version (date) this is, or how I can find the build number? I also tried the Version of today, same error.

https://www.pwm-project.org/artifacts/pwm/

[timothy....@gmail.com]

The one that I know works is 25 Sep. It is entirely possible there are others after that work as well.

[Andrew Meyer]

I'm having this same problem on 1.8.0 from 2018-9-1.  MariaDB 10.1.36 connector 2.1.2.