#+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 <table>;

  

* 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 ........