From d95f8549d118bd9adccbee48a0362b432aff3823 Mon Sep 17 00:00:00 2001 From: Guilhem Moulin Date: Mon, 20 Aug 2012 01:49:57 +0200 Subject: Replacing the MySQL bits by an LDAP version. --- admin-howtos.org | 36 +++++++++--------------------------- 1 file changed, 9 insertions(+), 27 deletions(-) diff --git a/admin-howtos.org b/admin-howtos.org index 6079fcc..47e919b 100644 --- a/admin-howtos.org +++ b/admin-howtos.org @@ -8,38 +8,20 @@ : $ ssh-add : $ ssh imap.fripost.org - Log in into MySQL-server + Dump the LDAP configuration (offline) - : $ mysql -u root -p + : $ slapcat -n0 - MySQL will prompt for the password, which is found in /default.yml/. Example of usage: + Dump our LDAP database (offline) - : > show databases; - : > use mail; - : > show tables; - : > describe ; + : $ slapcat -b "o=mailHosting,dc=fripost,dc=org" - - -* FAQ about fripost tools - - *Q:* Error: - - : DBIx::Class::Row::insert(): DBI Exception: DBD::mysql::st execute failed: Thread stack overrun: 6244 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack. [for Statement "INSERT INTO mailbox (active, domain, maildir, password, username) VALUES ( ?, ?, ?, ?, ? )" with ParamValues: 0=1, 1='fripost.org', 2='fripost.org/avtobiff/Maildir/', 3='{SMD5}gz2tMgYla0HxIOs9dyJsIxUar093sHG01K7Ekwo=', 4='avtobiff@fripost.org'] at ./fripost-adduser line 82 - - *A:* Increase stack on the main MySQL server: write "thread_stackII= 192K" i /etc/mysql/my.cnf/ + Dump our LDAP database (online) - *Q:* Error - - : DBIx::Class::ResultSet::find(): DBI Connection failed: DBI connect('mail;host=127.0.0.1;port=3306','root',...) failed: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1248 at ./fripost-passwd line 45 - - *A:* Use the -N flag wich can not be configured in /~/.ssh/config/ - - : $ ssh -NfL 3306:localhost:3306 imap.fripost.org + : $ ldapsearch -xWD "" -b ou=virtual,o=mailHosting,dc=fripost,dc=org + + ldapsearch will prompt for a password, which can be found (alongside with your "") in ~/.fripost.yml - *Q:* - - : DBIx::Class::ResultSet::find(): DBI Connection failed: DBI connect('mail;host=127.0.0.1;port=3306','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1176 +* FAQ about fripost tools - *A:* To come ........ -- cgit v1.2.3