Unsupported Screen Size: The viewport size is too small for the theme to render properly.

SQLyog Job Agent Version 2.0 Config

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › SQLyog Job Agent Version 2.0 Config

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • August 20, 2004 at 12:09 am #8535
      Red
      Member

      Hello, I just can't get this to work.

      I'am using Linux Fedora Core 2.

      Here's my job file:

      (greater than and smaller than symbols removed for this post, board software doesn't seem to like them.)

      job version=”2.0″

      abortonerror abort=”no” /

      fkcheck check=”no” /

      syncjob

      source

      host 192.168.0.2 /host

      user somevaliduser /user

      pwd /

      port 3306 /port

      database somevaliddatabase /database

      /source

      target

      host 192.168.0.100 /host

      user somevaliduser /user

      pwd somevalidpassword /pwd

      port 3306 /port

      database somevaliddatabase /database

      /target

      tables all=”yes” /

      /syncjob

      /job

      Here's the output:

      SQLyog Job Agent Version 2.0

      Copyright © Webyog. All Rights Reserved.

      Sync started at Thu Aug 19 19:46:36 2004

      Could not connect to SOURCE MySQL server

      The only way I can make it connect to thesource is by changing the address to localhost

      but then I can not connect to the target (remote machine on the same network)

      Any clues ?

      Thanks.

    • August 20, 2004 at 8:22 am #16191
      Ritesh
      Member

      Are you able to connect to above MySQL servers using the MySQL CLI tool with same parameters?

    • August 21, 2004 at 8:46 pm #16192
      Red
      Member

      Looks that this is the problem.

      My databases are remotely hosted and I have no control on remote users permissions

      I can not connect using something like:

      mysql -h host_name -u user_name -pyour_pass

      But I can run stuff like phpmyadmin.

      Any ideas?

      Thanks.

    • August 22, 2004 at 11:38 am #16193
      Ritesh
      Member

      Wait for SQLyog 3.8 which is 2 weeks away.

      Ver 3.8 would allow you to connect to MySQL host thru PHP/HTTP tunnelling. This means that SQLyog ( and SJA ) will continue to work even if the MySQL port is blocked, as well as in case of MySQL security disallowing remote access.

    • August 23, 2004 at 3:02 am #16194
      Red
      Member

      OK and many thanks for devellopping an http version.

      Just for the record I'am hosted by a compagny using Plusmail as a site manager interface it's a shared machine with many other customers beside me they also have some machines running Ensim, apparently they can unlock the remote mysql access with Ensim but not with Plusmail.

      I might switch to Ensim if they don't charge me an arm for it.

      Again thank you for the software even thought I'm using Linux I'll see if I can

      put together a few bucks and I'll probably purchase it a little later.

      Keep up the good work 😀

  • Author
    Posts
Viewing 4 reply threads
  • You must be logged in to reply to this topic.