Problems with unicode - cyrilic

[levros]

how do i send messages with cyrilic inside the html version???

[maschoff]

Force the JDBC driver to use UTF-8. To do this, edit file emm.properties in directory

Code: Select all

/home/openemm/webapps/core/WEB-INF/classes

Search for line

Code: Select all

jdbc.url=jdbc:mysql://localhost/openemm

and change it to

Code: Select all

jdbc.url=jdbc:mysql://localhost/openemm?useUnicode=yes&characterEncoding=UTF-8

After that change restart OpenEMM with

Code: Select all

su - openemm
OpenEMM.sh stop
OpenEMM.sh start
exit

[levros]

"
After that change restart OpenEMM with

Code:
su - openemm
OpenEMM.sh stop
OpenEMM.sh start
exit

"

Where do I write this code?

[maschoff]

At the Linux shell prompt.

[levros]

i have donwloaded the newset version of openemm and istalled it from scratch and now it works with russian

the only problem is that all the mails that im sending are identified as spam

[maschoff]

In this case you should use the mail server of your ISP as smart relay. Hopefully, those IP addresses have a better reputation.

[levros]

Hi ma,

I changed the smart relay to a gmail account and it works fine.

i have one more question though,

We are using the latest openemm version (6.0.1) and i installed all the required programs on the same server.

Now we want to separate the MySql DB From the application, so we changed the "openemm.py" and added "-h [ip of the MySql server]" and we changed the "emm.properties" and "agn.py" - replaced localhost with the ip of the MySql server.

But We still getting an error message : "failed to connect to database" after creating the openemm and the openemm_cms database.

Can you help me?