mydbr_sync - Store your reports to version control

(13 posts) (5 voices)

Tags:

  1. myDBR Team, Key Master

    Hi,
    myDBR Team is happy to announce the the availability mydbr_sync, a tool which eases up the task to keep myDBR reports under a version control.

    mydbr_sync ja a Java-based tool that knows it's ways around myDBR database and extracts the relevant data from the server and allows you to check in your changes to a version control system from your local system. You can now work freely in the server and when you are done, run mydbr_sync and check in the changes / new reports you have done.

    How to use:

    • Download mydbr_sync
    • Create an empty directory for your project
    • Launch mydbr_sync from the command line
    • mydbr_sync will ask you required information, logs in to your server and extracts the report to your local machine
    • mydbr_sync will create a settings file mydbr_sync.properties for customization

    mydbr_sync is available for Premium license holders.

    Happy reporting,
    --
    myDBR Team

  2. duane, Member

    Great stuff!!

    I didn't have java on my linux box (amazon hosted) before, so I did a 'yum install java' and everything seemed fine. However when i tried to run the backup the following error occurred:

    # java -jar mydbr_sync.jar mydbr_sync.properties Exception in thread "main" java.lang.ClassFormatError: com.taikala.mydbr.MyDbrSync (unrecognized class file version) at java.lang.VMClassLoader.defineClass(libgcj.so.8rh) at java.lang.ClassLoader.defineClass(libgcj.so.8rh) at java.security.SecureClassLoader.defineClass(libgcj.so.8rh) at java.net.URLClassLoader.findClass(libgcj.so.8rh) at java.lang.ClassLoader.loadClass(libgcj.so.8rh) at java.lang.ClassLoader.loadClass(libgcj.so.8rh) at java.lang.Class.forName(libgcj.so.8rh) at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:56)

    Is there a particular java version I should install? Any additional modules? I'm not a linux expert so am not sure what is wrong, but can make it work if given clear instructions :-)

  3. myDBR Team, Key Master

    Hello Duane,

    mydbr_sync has been tested with the Sun's official Java distribution, and it looks like the java version you installed is not compatible with the official distribution.

    To install the Sun's Java version please first uninstall the java you currently have, i.e. yum uninstall java and then install the correct version as follows:

    apt-get install sun-java6-bin

    After that you should be able to run mydbr_sync.

    Best Regards,

    myDBR Team

  4. duane, Member

    Unfortunately that doesn't work on red hat (I installed apt but even so it didn't work). Guess I'll just leave it for now.

  5. myDBR Team, Key Master

    You can find Java installation instructions also from Oracle:

    http://www.java.com/en/download/help/linux_install.xml

    Depending where you want to have the reports stored (version control) and if you have an hosted server, the other alternative is to open an SSH tunnel to server and run mydbr_sync from your local machine throught the tunnel. This way you get the files stored directly to your own machine.

    --
    myDBR Team

  6. vboccalate, Member

    can I understand better how I have to install it locally.

    If I have to run it through SSH do I have ot prlace the mydbr_sync files into a specific directory or into a mydbr directory?

    thanks

  7. myDBR Team, Key Master

    Hi,
    To sync the reports from remote server to your local machine you can do following:

    Open the ssh tunnel to server:

    % ssh -L3309:localhost:3306 myusername@myserver.com

    This will create a SSH tunnel to server allowing to access remote MySQL as it would be local. The port for the remote server is in this case 3309.

    Now make sure you have Java 1.6 installed in you local machine and that you have mydbr_sync downloaded. Go a directory where you wish the objects to appear and launch mydbr_sync from your local command prompt:

    % java -jar PATH_TO_MYDBR_SYNC/mydbr_sync.jar

    Now that mydbr_sync asks your connection (only at first time) info you give:
    - Database host address: localhost
    - Database port number: 3309

    mydbr_sync reads all your reports, procedures, functions and views from myDBR database and stores them in organized structure. This directory is then easy to commit into your version control system. mydbr_sync stores your settings to a local file, so next time you do the sync, you just need to repeat the command and sync will happen.

    --
    myDBR Team

  8. vboccalate, Member

    dear sir

    we do have to sync mydbr sql file on remote lnx server.

    however then we need to put it back locally on XAMPP localhost.

    I'm not sure I can upload on remote lnx machine the mydbr_sync running it through putty SSH for instance.

    however can you only advice if the file to run .jar is located in mydbr_sync folder and where

    thanks

  9. myDBR Team, Key Master

    There are two different tasks here.

    If you wish to duplicate the remote server's myDBR setup to local machine, the easiest way to do it is using database backup. Dump the database (with procedures in MySQL) and load it to local machine.

    With mydbr_sync you can grab the changes made to the reports/other objects on server and put them into version control.

    mydbr_sync is not installed on server, but run locally. You can download the mydbr_sync.jar from http://mydbr.com/download and place it anywhere you like in your local machine.

    --
    myDBR Team

  10. cdavison, Member

    Is there a way to specify the user/pass each time as in input? I am running this script from an AWS EC2 instance and I don't want to save the user/pass in clear text so I want to grab it from a secrets manager instead.

    For example, I woudl like this as an option...

    java -jar mydbr_sync.jar SyncThis_sync.properties password=TheActualPassword user=TheActualUser

  11. myDBR Team, Key Master

    We can take a look at it.

    --
    myDBR Team

  12. myDBR Team, Key Master

    With the latest version of mydbr_sync, you can now set parameters from the command line (optionally overriding the ones from the .properties file):

    java -jar mydbr_sync.jar SyncThis_sync.properties -uTheActualUser -pTheActualPassword

    --
    myDBR Team

  13. cdavison, Member

    Thank you! This is exactly what I needed to back up all of my reports without storing the user/pass in clear text on the PC.


Reply

You must log in to post.