I'm a French student that needs to setup a groupware for my final exam, and I've encountered a little problem with mariaDB. I just hope this is the right section to post this,because I've tried to find the right place to post this, been looking for a forum to help me for an hour. Sorry if this Isn't the right place. (sorry for english mistakes..)
I'm trying to install the groupware for my first time, and its on debian 9.
The groupware I've decided to install is : SOGo
I've started with installing it first, then installing apache2, and mariaDB. ( I'm just following a tutorial on google)
After I've created my mariadb's user, and configured it out, and now I have to switch to the user I've just created, to type some commands. But cant switch to it.
If you can help me out..that'll be awesome
This is what I've did until now :
- Code: Select all
su
# change sources.list
echo '# sogo:' >> /etc/apt/sources.list
echo 'deb http://inverse.ca/debian squeeze squeeze' >> /etc/apt/sources.list
apt-key adv --keyserver keys.gnupg.net --recv-key 0x810273C4
apt-get update
# install programs
apt-get install sogo mariaDB-server memcached rpl
/etc/init.d/mysql restart
# this is because of IPv6 errors
rpl '127.0.0.1' localhost /etc/memcached.conf
/etc/init.d/memcached restart
------start mariaDB------
CREATE DATABASE sogo CHARSET='UTF8';
CREATE USER 'sogo'@'localhost' IDENTIFIED BY 'secret';
GRANT ALL PRIVILEGES ON sogo.* TO 'sogo'@'localhost';
USE sogo;
CREATE TABLE sogo_users (c_uid VARCHAR(10) PRIMARY KEY, c_name VARCHAR(10), c_password VARCHAR(32), c_cn VARCHAR(128), mail VARCHAR(128));
INSERT INTO sogo_users VALUES ('paul', 'paul', MD5('zxc'), 'Paul Example', 'paul@example.com');
INSERT INTO sogo_users VALUES ('piet', 'piet', MD5('zxc'), 'Piet Jansen', 'piet@example.com');
INSERT INTO sogo_users VALUES ('klaas', 'klaas', MD5('zxc'), 'Klaas van der Zee', 'klaas@example.com');
flush privileges;
exit
----end mysql--------
# add some apache modules
a2enmod proxy
a2enmod proxy_http
a2enmod headers
a2enmod rewrite
/etc/init.d/apache2 restart
And now it says that I need to switch to user "sogo" but the account is not available apparently.
su sogo
This account is currently not available.
I have to type the following commands with the user sogo :
- Code: Select all
su sogo
defaults write sogod SOGoTimeZone "Europe/Amsterdam"
defaults write sogod SOGoMailDomain "example.com"
defaults write sogod SOGoLanguage "Dutch"
defaults write sogod SOGoUserSources '({canAuthenticate = YES; displayName = "SOGo Users"; id = users; isAddressBook = YES; type = sql; userPasswordAlgorithm = md5; viewURL ="mysql://sogo:secret@127.0.0.1:3306/sogo/sogo_users";})'
defaults write sogod SOGoProfileURL 'mysql://sogo:secret@127.0.0.1:3306/sogo/sogo_user_profile'
defaults write sogod OCSFolderInfoURL 'mysql://sogo:secret@127.0.0.1:3306/sogo/sogo_folder_info'
defaults write sogod OCSSessionsFolderURL 'mysql://sogo:secret@127.0.0.1:3306/sogo/sogo_sessions_folder'
defaults write sogod SOGoAppointmentSendEMailNotifications YES
defaults write sogod SOGoLoginModule Calendar
defaults write sogod SOGoSieveScriptsEnabled YES
If anyone knows what the problem is and how do I switch to that user, please let me know !
