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

Installing Data Protector 6.0 on Ubuntu

Download the latest HP-UX core and disk agent patches (either Ia64 or PA-RISC, Linux installation is included on both!) from hp.com.

In this examaple the the core patch filename is PHSS_39016.depot and the disk agent patch filename is PHSS_39439.depot. The patches is located in the users home folder on the client. The cell managers FQDN (Fully Qualified Domain Name)  is cellmananger.mydomain.com and has IP-address 192.168.0.10.  The clients FQDN is ubuntu.mydomain.com and has IP-address 192.168.0.11.

Verify that the client can resolve the FQDN of the cellmananger
Verify the the cell manager can resolve the FQDN of the client.

If you have problem resolving the FQDNs, check the DNS configuration. If you for example have the client on a DMZ you may have to edit the hosts file and add an entry for the cell manger. Open the hosts file with your favortite text editor, in my case nano.
Install Nano
# sudo aptitude install nano

Edit hosts with Nano
# sudo nano /etc/hosts
Add the following entry at the top:
192.168.0.10 cellmanager.mydomain.com
Save the file.

Now install the following on the client running Ubuntu Server. I have tested this installation on Ubuntu Server 8.04.

Install and configurate RPM
#sudo aptitude install rpm -y
# sudo mkdir -p /var/lib/rpm
# sudo rpm –initdb

Install inetutils-inetd
# sudo  aptitude install inetutils-inetd -y

Install HP Data Protector core
# cd ~/
# sudo tar xvf PHSS_39016.depot
# sudo mkdir /tmp/install
# sudo mkdir /tmp/install/core
# sudo cp ~/PHSS_39016/OMNI-CORE-IS/opt/omni/databases/vendor/omnicf/gpl/i386/linux-x86/A.06.00/packet.Z /tmp/install/core
# sudo cp ~/PHSS_39016/OMNI-CORE-IS/opt/omni/databases/utils/gpl/i386/linux-x86/utils.tar /tmp/install/core
# cd /tmp/install/core
# sudo mv packet.Z packet.Z.gz
# sudo mv utils.tar utils.tar.gz
# sudo gunzip packet.Z.gz
# sudo gunzip utils.tar.gz
# sudo mkdir /tmp/omni_tmp
# sudo mkdir /tmp/omni_tmp/core
# cd /tmp/omni_tmp/core
# sudo tar xvf /tmp/install/core/utils.tar
# sudo cp /tmp/install/core/packet.Z .
# ./omni_rinst.sh /tmp/omni_tmp/core/packet.Z CORE A.06.00 gpl/i386/linux-x86 /opt/omni cellmananger.mydomain.net 5555

Install HP Data Protector disk agent
# cd ~/
# sudo tar xvf PHSS_39439.depot
# sudo mkdir /tmp/install/da
# sudo cp ~/PHSS_39439/OMNI-OTHUX-P/opt/omni/databases/vendor/da/gpl/i386/linux-x86/A.06.00/packet.Z /tmp/install/da
# sudo cp ~/PHSS_39016/OMNI-CORE-IS/opt/omni/databases/utils/gpl/i386/linux-x86/utils.tar /tmp/install/da
# cd /tmp/install/da
# sudo mv packet.Z packet.Z.gz
# sudo mv utils.tar utils.tar.gz
# sudo gunzip packet.Z.gz
# sudo gunzip utils.tar.gz
# sudo mkdir /tmp/omni_tmp/da
# cd /tmp/omni_tmp/da
# sudo tar xvf /tmp/install/da/utils.tar
# sudo cp /tmp/install/da/packet.Z .
# sudo ./omni_rinst.sh /tmp/omni_tmp/da/packet.Z DA A.06.00 gpl/i386/linux-x86 /opt/omni cellmananger.mydomain.net 5555

If you have a firewall enabled on the client remember to allow incoming connections from the cell manager over port 5555 TCP and outgoing connections to the cell manager over port 5555 TCP.

Firewall rules on the client
Source/Destination/Service
192.168.0.11/192.168.0.10/5555TCP
192.168.0.10/192.168.0.11/5555TCP

If you have a firewall enabled on the cell manager remember to allow incoming connections from the client over port 5555 TCP and outgoing connections to the client over port 5555 TCP.

Firewall rules on the cell mananger
Source/Destination/Service
192.168.0.11/192.168.0.10/5555TCP
192.168.0.10/192.168.0.11/5555TCP

Test the connectivity on the client:
# sudo aptitude install telnet
# telnet cellmanager.mydomain.com 5555
The cell manager will answer “HP OpenView Storage Data Protector A.06.00: INET…” if the connectivity is working.

Test the connectivity on the cell manager
telnet ubuntu.mydomain.com 5555

1 2