Sja613 Linux — "nothing Happens!?"

[saf]

I am trying to use sja613 on a centos linux server with mysql 5.

I created a xml job file by modifying the notification.xml when run it prints.

Code:

SQLyog Job Agent Version 6.13
Copyright(c)Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Job started at Thu Nov 15 18:11:59 2007

Job started at Thu Nov 15 18:11:59 2007

Total time taken – 0 sec(s)

I downloaded the enterprise version for Windows, had it create the .xml file for me (it worked fine from windows when I let windows run it). Copied the .xml file to my linux machine, and get the exact same messages. Nothing happens.

I've used a port sniffer when running and I don't see any traffic to the database, or to the smtp server. Nothing seems to happen.

Here's the log file

Code:

# cat sja.log
Job started at Thu Nov 15 17:47:04 2007

Job started at Thu Nov 15 17:51:27 2007

Job started at Thu Nov 15 17:52:24 2007

Job started at Thu Nov 15 17:52:26 2007

Job started at Thu Nov 15 18:17:59 2007

Here's the (redacted) XML file.

Code:

abc.examples.com
username password 3306 0
0





db_name

mySQL Server on ov2
[email protected]
[email protected]
[email protected]
owa.mailseat.com 2525
[email protected] smtp_pw
yyyy-mm-dd hh:mm:ss

select USER_NAME_EMAIL from table_user where USER_NAME_EMAIL
like 'steve%'

Please help, it looks like this product will be super useful, and the enterprise version of the windows client makes working with the server so nice, but it's got to at least do something :huh:

[peterlaursen]

do something …. well, that's an excellent idea really! We will discuss that! But we thought that people were running Linux only for entertainment and for the reason they could then tell that they do!

Jokes apart:

Could there be a Firewall issue? If you use SJA on Linux you would probably connect to MySQL on the same machine? Try 'localhost' or '127.0.0.1' as.

Spam filter issue that results in that mails are not received ?

SMTP: “mySQL Server on ov2”? SMTP must a a SMTP (mail) server not a MySQL server . But was that what you meant?

You have abort on error = yes and no connection error/authencation error in the log, so .. thinking …

[saf]

Thanks for the response. Changing the database server host to localhost made it work Excellent. I probably botched the database user configuration. However it sure would be nice if the error log was a bit more verbose if a connection really did fail. Is there a switch somewhere I missed that would turn on detailed debug logging?

Thanks!!

peterlaursen wrote on Nov 15 2007, 02:55 PM:

do something …. well, that's an excellent idea really! We will discuss that! But we thought that people were running Linux only for entertainment and for the reason they could then tell that they do!

Jokes apart:

Could there be a Firewall issue? If you use SJA on Linux you would probably connect to MySQL on the same machine? Try 'localhost' or '127.0.0.1' as.

Spam filter issue that results in that mails are not received ?

SMTP: “mySQL Server on ov2”? SMTP must a a SMTP (mail) server not a MySQL server . But was that what you meant?

You have abort on error = yes and no connection error/authencation error in the log, so .. thinking …

[peterlaursen]

we know that the sja.log could be much better!

[Author]

Posts