#+TITLE: Notes on performing administrative tasks
#+AUTHOR: Those involved with the administration
* Investigate the user database
Log in on imap-server
: $ ssh-add
: $ ssh imap.fripost.org
Log in into MySQL-server
: $ mysql -u root -p
MySQL will prompt for the password, which is found in /default.yml/. Example of usage:
: > show databases;
: > use mail;
: > show tables;
: > describe
;
* 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/
*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
*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
*A:* To come ........