On 16-08-18 11:27, Dino Edwards via Users wrote:
If I remove the following lines from
hibernate.mysql.cfg.xml:
<property
name="hibernate.connection.url">jdbc:mysql://127.0.0.1:3306/djigzo</property>^M
<property
name="hibernate.connection.username">USERNAME</property>^M
<property
name="hibernate.connection.password">PASSWORD</property>^M
I cannot login to the Ciphermail web GUI. Without the lines above, I get the back-end is
not running error.
Also, I can't find an include for the hibernate.mysql.connection.xml in the
hibernate.mysql.cfg.xml file.
The hibernate.mysql.cfg.xml seems like it's generated automatically by something. I
suspect that's the case with the ^M characters in it.
Please download the tar file to confirm that hibernate.mysql.xml
contains the include:
<!-- include XML fragment with the database connection URL and
credentials -->
&connectionsettings;
Older releases of hibernate.mysql.xml did not contain this import so you
had to modify hibernate.mysql.connection.xml if you wanted to change the
credentials. This was not optimal because if hibernate.mysql.xml was
updated, you would either loose your changes or the files had to be
merged manually.
You probably changed the credentials in the file hibernate.mysql.xml
somewhere before 5/3/2016 (the date the version with include was
provided) and did not merge the old and the new file. Therefore your
(old) version does not contain the part to include
hibernate.mysql.connection.xml.
Kind regards,
Martijn Brinkers
-----Original Message-----
From: Users [mailto:users-bounces@lists.ciphermail.com] On Behalf Of Martijn Brinkers via
Users
Sent: Thursday, August 9, 2018 3:25 AM
To: users(a)lists.ciphermail.com
Subject: Re: [CipherMail User] Changing MySQL credentials
On 06-08-18 13:16, Dino Edwards via Users wrote:
If I wanted to change MySQL credentials for
Ciphermail, what config
files would I have to modify?
The installation Guide only seems to mention the
/usr/share/djigzo/conf/database/hibernate.mysql.connection.xml file,
but the /usr/share/djigzo/conf/database/hibernate.mysql.cfg.xml also
seems to have the MySQL crendentials in it. Does the
/usr/share/djigzo/conf/database/hibernate.mysql.cfg.xml get generated
automatically by the system?
The file hibernate.mysql.cfg.xml should not have credentials in it.
hibernate.mysql.cfg.xml includes the file hibernate.mysql.connection.xml (see
&connectionsettings;)
Are you sure you are not referring to the file:
/usr/share/djigzo/conf/database/mysql.cnf
Because this file also contains the credentials. This file is used for backup/restore
because MariaDB backup/restore functions need a password.
So if you change the password and need to use the backup/restore functionality, you also
need to update this password.
Kind regards,
Martijn Brinkers
--
CipherMail email encryption
Email encryption with support for S/MIME, OpenPGP, PDF encryption and secure webmail
pull.
https://www.ciphermail.com
Twitter:
http://twitter.com/CipherMail
_______________________________________________
Users mailing list
Users(a)lists.ciphermail.com
https://lists.ciphermail.com/mailman/listinfo/users
_______________________________________________
Users mailing list
Users(a)lists.ciphermail.com
https://lists.ciphermail.com/mailman/listinfo/users
--
CipherMail email encryption
Email encryption with support for S/MIME, OpenPGP, PDF encryption and
secure webmail pull.
https://www.ciphermail.com
Twitter:
http://twitter.com/CipherMail