Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jasper com Mysql na amazon RDS #33

Open
valmeidavr opened this issue Jul 26, 2022 · 1 comment
Open

Jasper com Mysql na amazon RDS #33

valmeidavr opened this issue Jul 26, 2022 · 1 comment

Comments

@valmeidavr
Copy link

valmeidavr commented Jul 26, 2022

Atualização e Correção JDBC Amazon RDS MYSQL:
php apresenta erro de output. Peguei o comando gerada no output e consegui compilar pelo console linux, ou seja, no php não funciona e já no linux sim. Isso só acontece com o banco mysql da amazon.

@valmeidavr
Copy link
Author

valmeidavr commented Jul 26, 2022

Corrigido!

Download e Instalação
wget https://github.com/awslabs/aws-mysql-jdbc/releases/download/1.1.0/aws-mysql-jdbc-1.1.0.jar
cp aws-mysql-jdbc-1.1.0.jar para /vendor/geekcom/phpjasper/bin/jasperstarter/jdbc
export CLASSPATH=$CLASSPATH://vendor/geekcom/phpjasper/bin/jasperstarter/jdbc/aws-mysql-jdbc-1.1.0.jar

trocar padrão do mysql conector para o do AWS
'jdbc_driver' => 'software.aws.rds.jdbc.mysql.Driver',
'jdbc_url' => 'jdbc:mysql:aws://xxxx:3306/?useSSL=false'

Segue o link da documentação que estou utilizando.
https://github.com/awslabs/aws-mysql-jdbc

Observação: Não utiliza senha com caracteres especiais , pois não conecta!
bug relatado: #16

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant