how to place MySQL server in a remote machine in OpenEMM 6

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

logoff
Posts: 3
Joined: Tue Jun 15, 2010 11:27 am

how to place MySQL server in a remote machine in OpenEMM 6

Post by logoff »

I have found some post replying this question, but none specify how to do it in version 6.

This old post, for instance, talk about emm.properties file which have some system properties, agn.py wich is difficult to interpret and Mailgun.ini which I have not found.

Anybody can explain how to do it?

Thank you.
logoff
Posts: 3
Joined: Tue Jun 15, 2010 11:27 am

Post by logoff »

Hi again!

I have edited emm.properties file and cms.properties file, but I have no good results, this is the output:

Start /home/openemm/bin/scripts/bav-update.py .. done.
Start /home/openemm/bin/scripts/bav-trigger.py .. done.
Start /home/openemm/bin/scripts/bavd.py .. done.
Start /home/openemm/bin/bav -L INFO .. done.
Start python /home/openemm/bin/scripts/recovery.py .. done.
Start /home/openemm/bin/scripts/update.py bounce account .. done.
Start /home/openemm/bin/scripts/pickdist.py .. done.
Failed to setup database interface
Unable to determinate status for sendmail usages, assuming sendmail is enabled
Stopping obsolete sendmail processes: done.
Starting sendmails: listener admin queue mail queue done.
Start /home/openemm/bin/scripts/slrtscn.py .. done.
Resin httpd start at Tue Jun 15 14:15:14 UTC 2010
postfix/postfix-script: starting the Postfix mail system


What I am doing wrong?
logoff
Posts: 3
Joined: Tue Jun 15, 2010 11:27 am

Post by logoff »

Finally I have modified agn.py script because there is hard code inside them!! It looks like a bug, because I have read that in version 6 of OpenEMM all the configuration parameters are in emm.properties and cms.properties files.

In line 247 and 248:

('emm', 'jdbc.url', 'jdbc.username', 'jdbc.password', ['localhost', 'agnitas', 'openemm', 'openemm']),
('cms', 'cmsdb.url', 'cmsdb.username', 'cmsdb.password', ['localhost', 'agnitas', 'openemm', 'openemm_cms'])

the parameters of db_user, and db_password are set hard code!
Post Reply