Diego,

You should use the MySQLBackuper (org.continuent.sequoia.controller.backup.backupers.MySQLBackuper) instead of Octopus. For Octopus to work you need to add the MySQL driver to the controller classpath (not to the console classpath). But I strongly discourage the use of Octopus.

Thanks for your interest in Sequoia,
Emmanuel



What messages do you see in the logs when this error occurs? In particular, look at log/full_cluster.log and send us the messages that show up. Also, if you would be so kind please add the full text of your VDB definitions so that we can see it.

Thanks!

Robert


On 2/25/08 6:09 PM, "Diego" <[EMAIL PROTECTED]> wrote:

    posted the message sent to other mailing list!!!!!!!!!!!!!!!!
    Thanks u very much

    Hi guys!

    I am not sure if the is the proper way of act, in case not please
    could u point me to the right place? Thanks.

    In case i am so lucky that this is the place and the way of
    sharing my question. I have one.
    I have been trying to setup sequoia-2.10.9 in Windows. The
    backends databases are MySQL 5.0.
    I have a huge problem (well maybe not so huge) while trying to
    setup the recovery log. What i am
    doing is:

    - adding in the xml virtual database setup file:
    <Backup>
               <Backuper backuperName="Octopus"
    
className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"/>

    </Backup>

    - and setting up the RecoveryLog like:
    <RecoveryLog driver="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost/demo" login="root" password="*******">
                       <RecoveryLogTable tableName="logtable"
                                                                            
sqlColumnName="sqlcol"/>

                   <CheckpointTable tableName="checkpointtable"/>
                                   <BackendTable
    tableName="backendtable"/>
                                    <DumpTable tableName="dumptable"/>
                      </RecoveryLog>

    - The tables created are the specified in the database except for
    the column sql which i changed. And i am using VARCHAR(255) for
    those columns
    which are specified in the userGuide like VARCHAR.

    Well once connected to the virtualdatabase what i do is:
    > initialize mysql-node1
    > backup mysql-node1 my_dump_test Octopues backup

    And always getting this error:
    Backup backend mysql-node1 in dump file my_dump_test
    Exception in method generate() in LoaderGenerator class!
    Error while generate sql statements for all vendors.


    I also added the mysql-connector to the classpath in the
    console.bat as i read that there should be explicitly added to the
    CLASSPATH.

    PLEASE, could anyone bring me some light into this? I appreciate
    very much your help and your time.
    And of course thanks very much in advance.

    Robert Hodges escribió:


        You reached the forum.  What's the question?

        Robert


        On 2/25/08 5:55 PM, "Diego" <[EMAIL PROTECTED]>
        <mailto:[EMAIL PROTECTED]>  wrote:


            Hi!!!!!!!!

            I am about to cry :'(. Is there a forum where or someone
            who i can ask
            one doubt about sequoia!
            Please help me, please.

            Thanks in advance for your time.
            Diego

_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Reply via email to