Bug: 2.5 remote DB not used

Subscribe to Bug: 2.5 remote DB not used 10 post(s), 5 voice(s)

Avatar ciuly 5 post(s)

My config says db.mysql.database=something but I look in the error log and see. jbid then hangs.

Access denied for user ’XXX’@’YYY’ to database ‘jbidwatcher’
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ’XXX’@’YYY’ to database ‘jbidwatcher’
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1605)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1524)
at com.jbidwatcher.util.db.Database.setup(Database.java:87)
at com.jbidwatcher.util.db.Database.(Database.java:52)
at com.jbidwatcher.Upgrader.upgrade(Upgrader.java:26)
at com.jbidwatcher.app.JBidWatch.main(JBidWatch.java:425)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.simontuffs.onejar.Boot.run(Boot.java:342)
at com.simontuffs.onejar.Boot.main(Boot.java:168)

Once I change the db in config and rename the schema, it works. So I guess the config setting is ignored.

Avatar ciuly 5 post(s)

I also noticed that it looses the DB configuration after closed and resets to user root and DB localhost with schema jbidwatcher.
so actually the problem is it doesn’t persist the DB configuration

Avatar ciuly 5 post(s)

And another pretty serious issue I notice is that when in remote DB, the snipes are not persisted. After I loaded jbid, the snpies I set yesterday were not shown.
I really need to be using this remote DB option as I’m using jbid at home and at work. Using a local DB would not cut it as the 2 places will always be out of sync from snipes point of view, at least.

Am I doing something wrong or is this really an issue?

Avatar Purity 10 post(s)

I have the same problem. The remote database name is ignored in the config file. It seems like it has a hardcoded database name called “jbidwatcher”. If you create a local database with that name it works perfectly. So it is a bug in the code.

I’m hoping that this problem gets resolved asap. I will happily donate when it does, but for now, the tool doesn’t do what I need

I’ve created a bug report

Avatar Morgan Schweers Administrator 1,204 post(s)

I’ve committed some changes to hopefully do this right.

I changed a couple of places years ago, but the number of people using MySQL with JBidwatcher has always been too small to really find problems with non-green path usage, so it turns out I missed two hardcoded ‘jbidwatcher’ database names.

The next version, probably 2.6, will include those changes.

— Morgan Schweers, CyberFOX!

Avatar Purity 10 post(s)

Brilliant, thanks Morgan. I look forward to those changes

Avatar Purity 10 post(s)

I’m quite happy to beta test if you want me to try the changes out?

Avatar Purity 10 post(s)

The remote database stuff works fine with 2.5.2. Thank you very much

Avatar Caljyody 4 post(s)

The remote database stuff seems to work, but every time I go back into the configuration it reverts back to localhost and user root with empty password. Took me a while to figure thhat out. When that happened and I saved the configuration without changing it back, jbidwatcher hangs on the next start. I’m using 2.5.3pre on Ubuntu 13.10.

Avatar lsmod 11 post(s)

I have many problems with the “normal” storage of the data in JBidwatcher.

So will mysql solve this problems or i get only other problems?