Problem starting MySQL MariaDB: InnoDB: Set innodb_force_recovery to ignore this error.

After trying to import a database I had problem starting mysql.

# service mysql start

Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details.

# systemctl status mariadb.service

InnoDB: Set innodb_force_recovery to ignore this error.

To be able to delete tables in the database I had imported to I needed to use innodb_force_recovery

# nano /etc/mysql/my.cnf

I added the following line under [mysqld] in my.cnf

# service mysql start

I then logged into PHPmyAdmin and drop the tables in the database.

# nano /etc/mysql/my.cnf

I removed the line

# service mysql restart

Now everything worked. But I have to figure out why the db I tried to import messed up mysql….

Problem with virtual hosts using nginx on on ubuntu

Problem after following this guide–3 virtual hosts didn’t work. All access was going to default root.

I need to create symbolic links of the virtual hosts in sites-available to sites-enabled
# sudo ln -s /etc/nginx/sites-available/ /etc/nginx/sites-enabled/
# sudo ln -s /etc/nginx/sites-available/ /etc/nginx/sites-enabled/

Can’t connect to ProFTPD

I’m running Ubuntu Server 10.04.2 and have installed ProFTPD. First I could connect to the server via FTP but not anymore.

First I change ServerType from inetd to standalone in /etc/proftpd/proftpd.conf. When I started ProFTPD I got OK, but when I check the status ProFTPD wasn’t running.

# sudo /etc/init.d/proftpd start * Starting ftp server proftpd [ OK ]
#/etc/init.d/proftpd status ProFTPd is started in standalone mode, currently not running.

I check the ProFTPD log:
# tail -f /var/log/proftpd/proftpd.log

failed binding to ::, port 21: Address already in use

From the log I got the message that ProFTPD failed to bind to port 21.

To get the PID of the process currently bound to port 21:
# fuser -n tcp 21

The PID that was using port 21 was 599.

To find what process uses that PID:
# ps -ef | grep 599

The process was inetutils-inetd. I uninstalled inetutils-inetd and reinstalled ProFTPD.
# sudo aptitude –purge remove inetutils-inetd
# sudo aptitude install proftpd -y

I also changed back to ServerType inetd in /etc/proftpd/proftpd.conf.

Mail relay host in sendmail

I wanted sendmail on my Ubuntu server to relay all outgoing e-mails to one specific server, this is what i did.

Install sendmail
# sudo aptitude install sendmail -y

Confiure sendmail
# sudo nano /etc/mail/

Edit the “Smart” relay host.

Restart sendmail
# sudo /etc/init.d/sendmail restart

phpMyAdmin tracking problem

After installing phpMyAdmin 3.3.2deb1 on a Ubuntu 10.04 server with MySQL 5.1.41 I got this error massage when logging on to phpMyAdmin:
The additional features for working with linked tables have been deactivated. To find out why click here.

$cfg[‘Servers’][$i][‘tracking’] … not OK [ Documentation ] Tracking: Disabled

I sloved this by editing /etc/phpmyadmin/ and added
$cfg[‘Servers’][$i][‘tracking’] = ‘pma_tracking’;
to the $cfg[‘Servers’][$i] section

Import database larger then 2mb via phpMyAdmin

To import databases larger then 2MB you need to edit /etc/php5/<flavour>/php.ini.

Edit the existing parameters in  php.ini, if they does not exists add them at the end of the file:
post_max_size = 50M
upload_max_filesize = 50M

Restart the webserver. If you are using Apache: sudo /etc/init.d/apache2 restart

1 2