Hi all,
thanks for your answer, Christian.
/usr/sbin/sogo-tool dump-defaults
returns some parts of my sogo.conf containing my database password.
But actually, I cannot find any .GNUstepDefaults, neither in
/root/GNUtep/Defaults nore somewhere else.
plparse /etc/sogo/sogo.conf
returns "Parsing '/etc/sogo/sogo.conf' - a dictionary" as expected.
And yes, I ran the db-upgrade but tried it again just now. This time, I get:
root@www:/usr/share/doc/sogo# ./sql-update-3.2.10_to_4.0.0-mysql.sh
Username (root): sogo
Hostname (127.0.0.1):
Database (sogo):
This script will ask for the database password twice
Converting c_content from TEXT to LONGTEXT in the sogo_user_profile table
Converting c_mail from VARCHAR(255) to TEXT in Contacts quick tables
Enter password:
Enter password:
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
[...]
Thanks in advance,
Carsten
Am 17.01.19 um 09:05 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
Am 16.01.19 um 23:15 schrieb Carsten Pieper (i...@carstenpieper.com):
Hi dear community,
today, I upgraded from SOGo 3.2.15 to 4.0.5 and everything worked. I
optimized some points with sogo-tool (cleanup). But now, I do get the
following error:
ERROR: could not open MySQL4 connection to database 'sogo': Access
denied for user 'sogo'
I now changed the user in /etc/sogo/sogo.conf for testing purposes to
root. But even after a complete restart of my ubuntu server, I still get
the message above, still with the user sogo.
I assume, that my sogo.conf file is not read but some other default is
taken.
Can please somebody help me to fix this problem and maybe tell me what
to do thaat SOGo accepts my sogo.conf?
First check if there exists an old GNUstep configuration outside
sogo.conf with:
/usr/sbin/sogo-tool dump-defaults
You should get "No defaults found. Try to use -f.".
If not, move the following GNUstep config file out of the way.
sudo -u sogo mv ~/GNUstep/Defaults/.GNUstepDefaults
~/GNUstep/Defaults/GNUstepDefaults.old
Then check your sogo.conf
plparse /etc/sogo/sogo.conf
You should get "Parsing '/etc/sogo/sogo.conf' - a dictionary".
If not, fix your sogo.conf
Did you execute sql-update-3.2.10_to_4.0.0-mysql.sh after upgrade?
Kind regards,
Christian Mack
--
CARSTEN PIEPER
Dyckburgheide 1
48157 Münster
Deutschland
Fon: +49 251 3997257
Fax: +49 251 3997256
Mobil: +49 151 46673961
E-Mail: i...@carstenpieper.com
Internet: www.carstenpieper.com
--
users@sogo.nu
https://inverse.ca/sogo/lists
