search

intuit / wasabi

Wasabi A/B Testing service is an open source project that is no longer under active development or being supported
Apache License 2.0
1.13k stars 238 forks source link

mysql super user? Why? #180

Open djMax opened 7 years ago

djMax commented 7 years ago

https://github.com/intuit/wasabi/blob/develop/bin/container.sh#L209

grant all on *.*...

Why does wasabi need that?

djMax commented 7 years ago

Amazon RDS doesn't allow that command, and I end up with this less-than-useful error in the logs:


31322 [main] DEBUG com.jolbox.bonecp.BoneCPDataSource - JDBC URL = jdbc:mysql://wasabi-mysql:3306/wasabi?verifyServerCertificate=false&useSSL=false&requireSSL=false&autoReconnect=true&autoReconnectForPools=true, Username = readwrite, partitions = 1, max (per partition) = 30, min (per partition) = 10, idle max age = 60 min, idle test period = 240 min, strategy = DEFAULT
log4j:WARN No appenders could be found for logger (com.googlecode.flyway.core.dbsupport.DbSupportFactory).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
35925 [main] ERROR com.jolbox.bonecp.ConnectionHandle - Database access problem. Killing off this connection and all remaining connections in the connection pool. SQL State = HY000
3```
djMax commented 7 years ago

This fixes the problem for posterity, but I still don't like the line...

https://techtavern.wordpress.com/2013/06/17/mysql-triggers-and-amazon-rds/