I got lots of messages from kernel telling me about neigbour table overflow. It was really annoying and not allow me to do something at terminal. After uncommenting line


kernel.printk = 3 4 1 3


at /etc/sysctl.conf and exec sysctl -p this messages never appear again.

(more...)

DB_CREATE_FILE_DEST,
DB_CREATE_ONLINE_LOG_DEST_n, or
DB_RECOVERY_FILE_DEST
in your initialization parameter file, you instruct Oracle Database to create and manage the underlying operating system files of your database

(more...)

ORA-01109 database not open

This error may occur if you start instance with nomount option. Try to log as SYSDBA and do the following:


shutdown;
startup;Connected to an idle instance.


ORA-17610: file blah does not exist and no size specified

If this error occurs during database creation, add DATAFILE to that tablespace mentioned in error.

Connected to an idle instance.

This is not error but you have to startup your instance using STARTUP command.

(more...)

All necessary packages are included in "Development Tools" group. You need to type:


yum groupinstall "Development Tools"


Edit your /etc/sysctl.conf like that:


kernel.shmall = 268435456
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max=1048576


Now you can run runInstaller

(more...)

Replication may failed due to many reasons. That's why first step is to look through slaves error log file to spot it. In my example slaves error log exists in /var/log directory and called mysqld.err.


Slave I/O thread: connected to master 'user@mysql:3306', replication
started in log 'binlog.log.00299' at position 110223
8:15:08 Error reading packet from server: binlog truncated in the middle of event
(server_errno=1236) 110223
8:15:08 Got fatal error 1236: 'binlog truncated in the middle of event' from master when reading data from binary log 110223

(more...)

If mysql server does not start due to the following error:
table mysql/user is marked as crashed and last repair failed

You need to do the next three steps to repair it.

In linux to run mysql server with options is very easy:

/usr/sbin/mysqld --skip-grant-tables

(more...)

As mentioned in official documentation SSI switch on using the following directive:

Options +Include


You must add it to the configuration file of your virtual host or in httpd.conf. But it may not work in debian until the include module isn't loaded. Check if such module is loaded. You can do it using the following command:

a2dismod


(more...)

Installing new networking software especially for VPN, you may occasionally corrupt TCP/IP. It can be spotted easily - misterious behaviour of networking settings. For example, output of ipconfig differs from GUI output. Any ping caused winsock errors and may report:


can not load helper dll



That is winsock issue. You can not reinstall it, but you may reset it to the initial values.



netsh winsock reset catalog



(more...)

To synchronize php clients with server, when script does not call "SET NAMES" statement, just add skip-character-set-client-handshake. Troubles with different encodings on server and client side would be resolved.

(more...)

Splitting DNS allows you to create local DNS-zone visible only to allowed hosts. It prevents the zone being transfered to another NS-servers.
First step is to install DNS using apt-get command:


apt-get install bind9


You can easily split DNS by view directive. Move include "/etc/bind/named.conf.local"; line at the beginning of the /etc/bind/name.conffollowed by include "/etc/bind/named.conf.options";. Cover all existing zones by view "" directive like this:

(more...)