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
innodb_force_recovery=1

# service mysql start

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

# nano /etc/mysql/my.cnf

I removed the line
innodb_force_recovery=1

# 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 https://www.digitalocean.com/community/tutorials/how-to-set-up-nginx-virtual-hosts-server-blocks-on-ubuntu-12-04-lts–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/headadmin.se /etc/nginx/sites-enabled/headadmin.se
# sudo ln -s /etc/nginx/sites-available/headadmin.net /etc/nginx/sites-enabled/headadmin.net

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/sendmail.cf

Edit the “Smart” relay host.
DSmyrelayserver.domain.com

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/config.inc.php 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