What version of MySQL are you using? I believe I've found an issue with MYSQL and am testing now, but I'd like to test on your version if possible, and I'd like to make sure we're having the same issue. Are you getting any error messages? Have you tried running in debug mode? (uncomment the DEBUG line in log4j.properties)
Hi,
it is Linux 32bit OS MySQL 5.0.51a (MySQL precompiled glibc23 version).
I can start GUI and connect to the publisher. Then, during creation of publisher structure:
Table '_database_.Rep_Publications' doesn't exist
This points to creation failure of replication tables...
Monday, i will try with DEBUG...
Regards ;-)
Here DEBUG is:
dbreplicator pubconsole
15:45:33,306 INFO [ReplicationServer] [getInstance 148] URL rmi://0.0.0.0:3001/[myHOST]_3001 PORT 3001
15:45:33,315 DEBUG [ReplicationServer] [getInstance 158] ReplicationServer started
15:45:34,211 DEBUG [ScheduleHandler] [ 62] intializing ScheduleHandler
15:45:34,468 DEBUG [ScheduleHandler] [ 95] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'timesheet.Rep_ScheduleTable' doesn't exist
[ at this moment, it throws error! 'timesheet' is small (few tables) DB - and it has NO Rep_ScheduleTable' db table created (looking at the code it should be created automatically)]
[here I have tried to create publication]:
15:49:06,461 INFO [ReplicationServer] [createPublication 412] Create Publication timesheet_p
15:49:06,490 INFO [Utility] [getDatabaseHandler 90] MySQL
15:49:06,520 DEBUG [CommonMetaDataInfo] [checkTableExistance 79] Resultset found com.mysql.jdbc.ResultSetImpl@cbd8dc OR Resultset found false
15:49:06,538 ERROR [CommonMetaDataInfo] [checkTableExistance 94]
Table 'CONTACT' does not exist in the datasource.
org.dbreplicator.replication.RepException:
Table 'CONTACT' does not exist in the datasource.
at org.dbreplicator.replication.CommonMetaDataInfo.checkTableExistance(CommonMetaDataInfo.java:80)
at org.dbreplicator.replication.ReplicationServer.createPublication(ReplicationServer.java:1032)
at org.dbreplicator.replication.ReplicationServer.createPublication(ReplicationServer.java:413)
at org.dbreplicator.repconsole.SelectTable.jButton2_actionPerformed(SelectTable.java:671)
at org.dbreplicator.repconsole.SelectTable_jButton2_actionAdapter.actionPerformed(SelectTable.java:910)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:5517)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5282)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3984)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)
at java.awt.Dialog$1.run(Dialog.java:535)
at java.awt.Dialog$2.run(Dialog.java:565)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Dialog.java:563)
at org.dbreplicator.repconsole.CreatePublication.jButtonNext_actionPerformed(CreatePublication.java:223)
at org.dbreplicator.repconsole.CreatePublication_jButtonNext_actionAdapter.actionPerformed(CreatePublication.java:307)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:5517)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5282)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3984)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)
at java.awt.Dialog$1.run(Dialog.java:535)
at java.awt.Dialog$2.run(Dialog.java:565)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Dialog.java:563)
at org.dbreplicator.repconsole.MainFrame.jMenuPub_Create_actionPerformed(MainFrame.java:457)
at org.dbreplicator.repconsole.MainFrame_jMenuPub_Create_actionAdapter.actionPerformed(MainFrame.java:1047)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
at java.awt.Component.processMouseEvent(Component.java:5517)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5282)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3984)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
[table CONTACT exists and it it lowercase 'contact' (if that has anything to do). i have stopped here]
FYI, I believe I have this issue solved, sorry it took so long. I'm testing a bit this weekend and I'll put it up this coming week. Thanks for finding that problem.
Sorry for the delay in responding, I've been out of the country. I fixed the MYSQL problem, but didn't create a release with it yet for lack of proper testing. The fix is in cvs, if you're still interested. You can check it out and build the jar, then place it in your path where it's supposed to go. If you need help, I could build the jar and attach if for you.
MySQL replication qick start
Hi,
I have problem to start MySQL replication: db tables used for publishing are not created.
How can I create them?
Using DBReplicator 2.2.3 BIN
Re: MySQL replication
What version of MySQL are you using? I believe I've found an issue with MYSQL and am testing now, but I'd like to test on your version if possible, and I'd like to make sure we're having the same issue. Are you getting any error messages? Have you tried running in debug mode? (uncomment the DEBUG line in log4j.properties)
Hi, it is Linux 32bit OS
Hi,
it is Linux 32bit OS MySQL 5.0.51a (MySQL precompiled glibc23 version).
I can start GUI and connect to the publisher. Then, during creation of publisher structure:
Table '_database_.Rep_Publications' doesn't exist
This points to creation failure of replication tables...
Monday, i will try with DEBUG...
Regards ;-)
Here DEBUG is:
dbreplicator pubconsole
15:45:33,306 INFO [ReplicationServer] [getInstance 148] URL rmi://0.0.0.0:3001/[myHOST]_3001 PORT 3001
15:45:33,315 DEBUG [ReplicationServer] [getInstance 158] ReplicationServer started
15:45:34,211 DEBUG [ScheduleHandler] [ 62] intializing ScheduleHandler
15:45:34,468 DEBUG [ScheduleHandler] [ 95] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'timesheet.Rep_ScheduleTable' doesn't exist
[ at this moment, it throws error! 'timesheet' is small (few tables) DB - and it has NO Rep_ScheduleTable' db table created (looking at the code it should be created automatically)]
[here I have tried to create publication]:
15:49:06,461 INFO [ReplicationServer] [createPublication 412] Create Publication timesheet_p
15:49:06,490 INFO [Utility] [getDatabaseHandler 90] MySQL
15:49:06,520 DEBUG [CommonMetaDataInfo] [checkTableExistance 79] Resultset found com.mysql.jdbc.ResultSetImpl@cbd8dc OR Resultset found false
15:49:06,538 ERROR [CommonMetaDataInfo] [checkTableExistance 94]
Table 'CONTACT' does not exist in the datasource.
org.dbreplicator.replication.RepException:
Table 'CONTACT' does not exist in the datasource.
at org.dbreplicator.replication.CommonMetaDataInfo.checkTableExistance(CommonMetaDataInfo.java:80)
at org.dbreplicator.replication.ReplicationServer.createPublication(ReplicationServer.java:1032)
at org.dbreplicator.replication.ReplicationServer.createPublication(ReplicationServer.java:413)
at org.dbreplicator.repconsole.SelectTable.jButton2_actionPerformed(SelectTable.java:671)
at org.dbreplicator.repconsole.SelectTable_jButton2_actionAdapter.actionPerformed(SelectTable.java:910)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:5517)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5282)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3984)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)
at java.awt.Dialog$1.run(Dialog.java:535)
at java.awt.Dialog$2.run(Dialog.java:565)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Dialog.java:563)
at org.dbreplicator.repconsole.CreatePublication.jButtonNext_actionPerformed(CreatePublication.java:223)
at org.dbreplicator.repconsole.CreatePublication_jButtonNext_actionAdapter.actionPerformed(CreatePublication.java:307)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:5517)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5282)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3984)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)
at java.awt.Dialog$1.run(Dialog.java:535)
at java.awt.Dialog$2.run(Dialog.java:565)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Dialog.java:563)
at org.dbreplicator.repconsole.MainFrame.jMenuPub_Create_actionPerformed(MainFrame.java:457)
at org.dbreplicator.repconsole.MainFrame_jMenuPub_Create_actionAdapter.actionPerformed(MainFrame.java:1047)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
at java.awt.Component.processMouseEvent(Component.java:5517)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5282)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3984)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
[table CONTACT exists and it it lowercase 'contact' (if that has anything to do). i have stopped here]
ERROR.lg has only this in:
---8<----
2008-04-22
Table 'timesheet.Rep_Publications' doesn't exist
---8<---
Regards ;-)
This is indeed the same
This is indeed the same issue that I was having, I'll have a look at it today.
FYI, I believe I have this
FYI, I believe I have this issue solved, sorry it took so long. I'm testing a bit this weekend and I'll put it up this coming week. Thanks for finding that problem.
Brian
MySQL connector
MySQL connector problem
Hi,
any news on this? Best regards ;-)
Sorry for the delay in
Sorry for the delay in responding, I've been out of the country. I fixed the MYSQL problem, but didn't create a release with it yet for lack of proper testing. The fix is in cvs, if you're still interested. You can check it out and build the jar, then place it in your path where it's supposed to go. If you need help, I could build the jar and attach if for you.
Thanks.
~b
Hi, I cannot guess CVS
Hi,
I cannot guess CVS user/password ... I need help.
I am still interested in ;-)
I am still interested in ;-)
Still no luck! Same error
Still no luck!
Same error again. );
Here's a jar file that
Here's a jar file that should work for you!