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:[email protected]] On Behalf Of Martijn > Brinkers via Users > Sent: Thursday, August 9, 2018 3:25 AM > To: [email protected] > 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 > [email protected] > https://lists.ciphermail.com/mailman/listinfo/users > _______________________________________________ > Users mailing list > [email protected] > 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 _______________________________________________ Users mailing list [email protected] https://lists.ciphermail.com/mailman/listinfo/users
