Lenny

Can't connect to local MySQL server through socket

2011-01-26T08:23:00.000-08:00

My problem occured after I increased the size of the MySQL query_cache_size. The first step to fix this problem was to stop the MySQL server through the init.d script:

/etc/init.d/mysql stop

After I changed the query_cache_size setting in /etc/mysql/my.cnf to 16M

So I tried to start the MySQL server again but the following error message was shown:

Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

And in the syslog:

Jan 26 16:14:34 1106-28-18 /etc/init.d/mysql[25916]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 26 16:14:34 1106-28-18 /etc/init.d/mysql[25916]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jan 26 16:14:34 1106-28-18 /etc/init.d/mysql[25916]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan 26 16:14:34 1106-28-18 /etc/init.d/mysql[25916]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 26 16:14:34 1106-28-18 /etc/init.d/mysql[25916]:

So I took a look to the /var/run/mysqld/ directory if there is a mysqld.sock file, it was not there so I created it and made the mysql user to his owner:

chown mysql /var/run/mysqld/mysqld.sock
touch /var/run/mysqld/mysqld.sock

After I started MySQL with the init.d script the server runs like it should

Plesk vhost and register globals

2011-01-12T07:18:00.000-08:00

To activate register globals or other php modules on a linux machine running plesk you have to create a file named vhost.conf in the conf directory of your virtual host directory containing something like this:

php_flag register_globals on

After that I had to execute the following command:

/usr/local/psa/admin/sbin/websrvmng --reconfigure-vhost --vhost-name=domain.com

terminal browser

2010-12-22T06:04:00.000-08:00

A great terminal web browser for linux is w3m. It is easy to use and works how a browser should work.

apt-get install w3m

horde Auth_imp: Required IMAP extension not found.

2010-12-22T05:08:00.000-08:00

I installed the horde webmail groupware on my rackmounted server as it is described in the horde webmail wiki for debian. After I tried to login to my mailaccount via horde I received the following error message

A fatal error has occurred
Auth_imp: Required IMAP extension not found.
Details have been logged for the administrator.

The solution was to install the imap extension for php5:

apt-get install php5-imap

"sh: /mogrify: No such file or directory"

2010-08-31T00:50:00.000-07:00

This has actually nothing to do with specially with debian lenny. This problem can happen on any machine which runs a apache webserver. In a PHP Script I use a ImageMagick function called mogrify to resize the images automatically. It did not work and in my /var/log/apache2/error.log I found this entry:

"sh: /mogrify: No such file or directory"

The solution was very simple. I had activated PHP SafeMode which prevent PHP Scripts from using the exec command. After I deactivated Safe Mode ImageMagick works how it should.

lost connection after UNKNOWN

2010-08-11T05:23:00.000-07:00

I had this message in the mail.log after I tried to send a mail through my new isp using mozilla thunderbird lost connection after UNKNOWN. The solution was to configure the outgoing server new I use STARTTLS and confirm the certificate again.

Change Debian Timezone

2010-08-05T11:52:00.000-07:00

To change the timezone of your debian machine you can use this command to reconfigure the timezone:

dpkg-reconfigure tzdata

MySQL Backup

2010-07-12T02:34:00.000-07:00

To create a compressed backup of your MySQL Database you can use the following statement:

mysqldump --all-databases -u user -p'password' | gzip > /path/file-"`date +%F-%H-%M-%S`
".sql.gz

Change a users home directory also the ftp on standard debian

2010-07-06T10:43:00.000-07:00

To change the home directory of a user this line will do that:

usermod -d /path/to/new/homedir/ username

vhost rackmounted

2010-06-22T11:42:00.000-07:00

On a rackmounted vps you have to edit the /etc/apache2/sites-enabled/000-default and add this section at the top:

# Use name-based virtual hosting.
#
NameVirtualHost *:80

< VirtualHost *:80 >
##ServerAdmin postmaster@dummy-host2.localhost
DocumentRoot /var/www/folderforyoursubwww/
ServerName yourdomain.com
ServerAlias www.yourdomain.com
##ErrorLog "logs/dummy-host2.localhost-error.log"
##CustomLog "logs/dummy-host2.localhost-access.log" combined
< / VirtualHost>

This is enough at the beginning and you can add as much sections like this to the apache configuration on rackmounted for multiple domains. The support team has done his job with great effort, so I will recommend there products with this refer link which is linked to me http://whmcs.rackmounted.com/aff.php?aff=107

Reset MySQL root password

2010-06-21T08:01:00.000-07:00

I will describe, one way to reset the MySQL root password.

turn off mysql

/etc/init.d/mysql -stop

start mysql without any authentication

mysqld --skip-grant-tables

now you can connect without a password or user

mysql -u root -p

now you can set the new password und flush it

UPDATE mysql.user SET Password=PASSWORD('yournewpassword') WHERE User='root';
FLUSH PRIVILEGES;

open a second terminal and stop the mysql server again

/etc/init.d/mysql stop

if you did that you can start the MySQL server

/etc/init.d/mysql start

external mysql access

2010-06-09T07:01:00.000-07:00

This has nothing to do with debian lenny

To grant an user the right to access to the mysql database from any other places than local you have add an entry to your user table:

INSERT INTO `mysql`.`user` (
`Host` ,
`User` ,
`Password` ,
`Select_priv` ,
`Insert_priv` ,
`Update_priv` ,
`Delete_priv` ,
`Create_priv` ,
`Drop_priv` ,
`Reload_priv` ,
`Shutdown_priv` ,
`Process_priv` ,
`File_priv` ,
`Grant_priv` ,
`References_priv` ,
`Index_priv` ,
`Alter_priv` ,
`Show_db_priv` ,
`Super_priv` ,
`Create_tmp_table_priv` ,
`Lock_tables_priv` ,
`Execute_priv` ,
`Repl_slave_priv` ,
`Repl_client_priv` ,
`Create_view_priv` ,
`Show_view_priv` ,
`Create_routine_priv` ,
`Alter_routine_priv` ,
`Create_user_priv` ,
`Event_priv` ,
`Trigger_priv` ,
`ssl_type` ,
`max_questions` ,
`max_updates` ,
`max_connections` ,
`max_user_connections`
)
VALUES (
'%', 'dbuser', 'md5pwhash', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '0', '0', '0', '0'
);

INSERT INTO `mysql`.`db` (
`Host` ,
`Db` ,
`User` ,
`Select_priv` ,
`Insert_priv` ,
`Update_priv` ,
`Delete_priv` ,
`Create_priv` ,
`Drop_priv` ,
`Grant_priv` ,
`References_priv` ,
`Index_priv` ,
`Alter_priv` ,
`Create_tmp_table_priv` ,
`Lock_tables_priv` ,
`Create_view_priv` ,
`Show_view_priv` ,
`Create_routine_priv` ,
`Alter_routine_priv` ,
`Execute_priv` ,
`Event_priv` ,
`Trigger_priv`
)
VALUES (
'%', 'database', 'dbuser', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N'
);

flush privileges;

http checker

2010-06-08T12:08:00.000-07:00

http://code.google.com/p/skipfish/

rkhunter install and use

2010-06-08T00:26:00.001-07:00

To install the Rootkit Hunter simply use this command:

apt-get install rkhunter

After it is installed you can use rkhunter if you type:

rkhunter -c

Warning: The SSH and rkhunter configuration options should be the same: SSH configuration option 'PermitRootLogin': yes

2010-06-02T01:28:00.000-07:00

Warning: The SSH and rkhunter configuration options should be the same:
SSH configuration option 'PermitRootLogin': yes
Rkhunter configuration option 'ALLOW_SSH_ROOT_USER': no

you can change the /etc/ssh/sshd_config and set:

PermitRootLogin no

http://debianforum.de/forum/viewtopic.php?f=37&t=109601

Find in Files

2010-05-31T05:31:00.000-07:00

A way to find a keyword in files on your system

find . | xargs grep 'keyword' -sl

Open port 587 in postfix

2010-04-29T07:23:00.000-07:00

The isp of some user were using port 587 instead of the standard port 25. In newer postfix versions it is very easy to make postfix listen on the submission port. To enable it I only had to change my /etc/postfix/master.cf and uncomment the following line:

submission inet n - n - - smtpd

Sorry, your helo has been denied

2010-04-14T16:01:00.000-07:00

This is the mail system at host server01.

I'm sorry to have to inform you that your message could not be delivered to one or more recipients. It's attached below.

For further assistance, please send mail to postmaster.

If you do so, please include this problem report. You can delete your own text from the attached returned message.

The mail system

host mx1.gmx.net[213.165.64.102] said: 550-5.7.1 {mx%}
Sorry, your helo has been denied. 550 5.7.1 (
http://portal.gmx.net/serverrules ) (in reply to RCPT TO command)

the solution was to edit the postfix main.cf change myhostname

openbsd-inetd

2010-04-08T09:39:00.000-07:00

After I tried to restart inetd with the following command:

/etc/init.d/openbsd-inetd restart

I received the message:

Not starting internet superserver: no services enabled

Then I typed this:

apt-get install xinetd

After the installation the restart works

ImageMagick & TYPO3 - AI and PDF problems

2010-03-22T08:14:00.000-07:00

I installed TYPO3 4.2 on my machine. If I pass the image test there was still a problem with Read PDF and Read AI files. A solution for me was to install ghostscript:

apt-get install gs

Now the TYPO3 image processing test was fullfilled sucessful

PHP Version

2010-03-08T10:02:00.000-08:00

very simple but you have to search if you are new in the whole linux thing:

to find out which version of PHP is running, type this in your shell:

php -v

WINE rocks

2010-02-15T10:10:00.000-08:00

wine rocks, it was no problem to install pokerstars. also I can play diablo2 after I copied the windows installation to avoid install with wine cause the "I agree" button was not clickable.

USB keyboard and mouse recognition

2010-02-15T10:01:00.000-08:00

on each start or reboot i wait more than 1 minute till I can not click or press a keyboard button

on start this lines are shown

unable to enumerate usb device on port

Sound device Problem

2010-02-15T09:54:00.000-08:00

on double click on the audio logo:

Es konnten keine Gstreamer-Plugins oder Geräte für Mischpultelemente gefunden werden.

on click test within the audio configuration:

audiotestsrc wave=sine freq=512 ! audioconvert ! audioresample ! gconfaudiosink: Could not open audio device for playback

lscpi

00:1b.0 Audio device: Intel Corporation 82801JI (ICH10 Family) HD Audio Controll

This Eclipse build doesn't have support for the integrated browser.

2010-02-13T12:52:00.000-08:00

This Eclipse build doesn't have support for the integrated browser.

on start of eclipse, to remove I installed:

apt-get install xulrunner