ERROR 2003: Can’t connect to MySQL server

I Need to add remote user for add, select, update and delete in mysql.

grant select,insert,update,delete on postfix.* to "postfix_rc"@"%" identified by "postfix_xxxxyyy" with grant option;

try to access :

-bash-2.05b$ mysql -upostfix_rc -p -h 172.88.1.5
Enter password:
ERROR 2003: Can’t connect to MySQL server on ‘172.88.1.5’ (61)

according to this, that means no tcp/ip support.

checking firewall. OK.

after check for mysql

jedimaster# ps -ax | grep mysql
  739 con- I      0:00.01 /bin/sh /usr/local/bin/mysqld_safe –defaults-extra-file=/var/db/mysql/my.cnf –user=mysql –datadi
  834 con- S      0:04.86 /usr/local/libexec/mysqld –defaults-extra-file=/var/db/mysql/my.cnf –basedir=/usr/local –datadir
59745  p1  I      0:00.01 /bin/sh /usr/local/bin/mysqld_safe –defaults-extra-file=/var/db/mysql/my.cnf –user=mysql –datadi
59769  p1  S      0:04.98 /usr/local/libexec/mysqld –defaults-extra-file=/var/db/mysql/my.cnf –basedir=/usr/local –datadir
jedimaster# ee /var/db/mysql/my.cnf

check  this line :

#skip-networking

removing # will add security as connection only allowed from localhost but in my case I need tcp/ip so I put # back.

try again :

-bash-2.05b$ mysql -upostfix_rc -p -h 172.88.1.5
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 414 to server version: 5.0.45-log

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql>

make sure minimum mysql client : mysql-client-4.1.21 Multithreaded SQL database (client)

If I use from other server :

$ mysql -upostfix_rc -p -h 172.88.1.5
Enter password:
ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client
$

I use mysql 4.0.27 client :-)

got new mysql error :-). My old friend is 127 error heheheheehehe.

Using Sanesecurity Signatures for pdf email

A lot of pdf mail arrive in mailbox and maia can’t detect that. After googling I found in howtoforge about Filtering PDF-/XLS-/Image-Spam With ClamAV (And ISPConfig) On Debian/Ubuntu.

I wanna try it for FreeBSD, after red last section I try to update the scripts.

Changing two lines as suggested based on clamav installation on FreeBSD 6.2

clam_sigs="/var/db/clamav/"

clam_user="vscan"

run the script :

jedimaster# sh ss-msrbl.sh
=================================
SaneSecurity SCAM Database Update
=================================

curl: not found

my bad, Installing curl first :-)

jedimaster# cd /usr/ports/ftp/curl && make install

jedimaster# whereis curl
curl: /usr/local/bin/curl /usr/local/man/man1/curl.1.gz /usr/ports/ftp/curl
Continue reading

maia-mailguard and mimeDecode

[Sat Jul 28 13:59:10 2007] [error] [client 172.88.1.4] PHP Fatal error: 

require_once() [<a href=’function.require’>function.require</a>]:

Failed opening required ‘Mail/mimeDecode.php’

(include_path=’.:/usr/local/share/pear:/usr/local/share/smarty:./libs:’) in

/usr/local/www/maia-mailguard/mime.php on line 79, referer:    

http://172.88.1.5/maia-mailguard/welcome.php

try install pear mail

jedimaster# pear install mail
downloading Mail-1.1.14.tgz …
Starting to download Mail-1.1.14.tgz (17,537 bytes)
……done: 17,537 bytes
install ok: channel://pear.php.net/Mail-1.1.14
jedimaster# pear install mail_mime
Ignoring installed package pear/mail_mime
Nothing to install

Find other "mail" family :

jedimaster# pear search mime
Retrieving data…0%..Matched packages, channel pear.php.net:
=======================================
Package         Stable/(Latest) Local
Mail_Mime       1.5.2 (stable)  1.5.1 Mail_Mime provides classes to create mime messages.
Mail_mimeDecode 1.5.0 (stable)        Provides a class to decode mime messages.
MIME_Type       1.0.0 (stable)        Utility class for dealing with MIME types
jedimaster# pear install Mail_mimeDecode
downloading Mail_mimeDecode-1.5.0.tgz …
Starting to download Mail_mimeDecode-1.5.0.tgz (9,281 bytes)
…..done: 9,281 bytes
install ok: channel://pear.php.net/Mail_mimeDecode-1.5.0
jedimaster#

My bad :-)

Its Mail_mimeDecode

Migrating from courier-imap to dovecot

Our email system need to refresh :-)

Vmailmgr + courier-imap + qmail no longer suitable

Mostly with increasing user and complex operation. I need database support to integrate with other system.

Need to migrating from courier-imap to dovecot system, googling lead me to this migration script.

Need to check it in FreeBSD 6.2 stable. I’ll let you know if it work in FreeBSD 6.2

See the code here : Bendiken
 

Migrating from mysql 4.0 to mysql 5.0 in FreeBSD

Final decision has been made, upgrade to mysql 5.0 is a must.

But how to do that?

How about user data?

After doing it by myself I found it’s easy. I try to share my experience in sbs (step by step) form :-)

Situation :

I have two server kongja and proxy :

Server kongja has mysql 4.0.27 installed

Server proxy don’t have mysql server installed.

I wanna try migration in server proxy before doing it in kongja.

Here’s the steps :

1. Install mysql40-server in proxy

cd /usr/ports/databases/mysql40-server/ && make install

2. Compress mysql directory in kongja

cd /var/db

tar cvzf mysql.tar.gz mysql

export this file (mysql.tar.gz) to proxy.

Continue reading