Ola a todos, Segundo o manual do scadaBR (pagina 64)
Fiz a alteração no arquivo WEB-INF/classes/env.properties para permitir que o mysql pudesse ser usado.
contudo ao acessar o ScadaBR ocorre erro.
db.type=mysql
db.url=jdbc:mysql://localhost/scadabr
db.username=usuariobd
db.password=senhabd
db.pool.maxActive=10
db.pool.maxIdle=10
fui no mysql
mysql -p
create database scadabr …
fiz a criação e o acesso pelo usuariodb com a senhadb para conferir se tudo ta ok,
Ubuntu 16.04 LTS
tomcat-6.0.53
jre-6u45-linux-x64
mysql 5.7.18-0ubuntu0.16.04.1
e o scadabr baixado do link oficial do sourceforge.
mas o scada deixa de subir:
Alguma sugestão?
O mango log informa:
ERROR 2017-07-09 22:50:31,664 (com.serotonin.mango.web.filter.ExceptionDetectionFilter.doFilter:52) - DWR invocation exception
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: No suitable driver
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:576)
…
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDataSource.findDriver(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unknown Source)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
… 40 more
WARN 2017-07-09 22:50:31,687 (org.directwebremoting.util.CommonsLoggingOutput.warn:67) - Method execution failed:
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: No suitable driver
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
WARN 2017-07-09 22:53:04,553 (org.directwebremoting.util.CommonsLoggingOutput.warn:59) - Clash of converters for br.org.scadabr.OPCItem. Using org.directwebremoting.convert.BeanConverter in place of org.directwebremoting.convert.BeanConverter