Learning On Demand Learning anything from anywhere

Archive for July, 2007

ERROR 2003: Can’t connect to MySQL server

07.31.2007 · Posted in Database

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 ...

Using Sanesecurity Signatures for pdf email

07.30.2007 · Posted in Unix

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 ...

maia-mailguard and mimeDecode

07.28.2007 · Posted in Unix

[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 ...

Migrating from courier-imap to dovecot

07.27.2007 · Posted in Unix

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 ...

Migrating from mysql 4.0 to mysql 5.0 in FreeBSD

07.26.2007 · Posted in Database, Unix

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 ...

Adding tls support to pure-ftp in FreeBSD

07.25.2007 · Posted in Unix

Log for adding tls support in ure-ftp in FreeBSD : >>>>=================  Make directory for certificate edp# mkdir -p /etc/ssl/private >>>>=================  Make certificate edp# openssl req -x509 -nodes -newkey rsa:1024 -keyout /etc/ssl/private/pure-ftpd.pem -out /etc/ssl/private/pure-ftpd.pem Generating a 1024 bit RSA private key ……..++++++ ……++++++ writing new private key to ‘/etc/ssl/private/pure-ftpd.pem’ —– You are about to be asked ...

Updating Clamav

07.24.2007 · Posted in Unix

I install clamav from ports and get error message that said my definition older than 7 days. After trying manual update, I see something jedimaster# /usr/local/bin/freshclam –verbose Current working dir is /var/db/clamav Max retries == 3 ClamAV update process started at Mon Jul 23 16:44:22 2007 Querying current.cvd.clamav.net TTL: 300 WARNING: DNS record is older ...

trying portsnap

07.23.2007 · Posted in Unix

With recent freebsd 6.2 stable installation I like to try portsnap. Since it’s already in base, no need to install this program Just trying it alamster# portsnap fetch Looking up portsnap.FreeBSD.org mirrors… 3 mirrors found. Fetching public key from portsnap3.FreeBSD.org… done. Fetching snapshot tag from portsnap3.FreeBSD.org… done. Fetching snapshot metadata… done. Fetching snapshot generated at ...

Install gd support in php without xorg

07.22.2007 · Posted in PHP, Unix

Recent upgrade to php 5.2.3 require to install gd support too but it always need xorg. Here’s a lttle note on how to add gd support in php5 ports in freebsd without xorg. 1. Checking installed php extension proxy# pkg_info | grep php5 php5-5.2.3          PHP Scripting Language (Apache Module and CLI) php5-bz2-5.2.3      The bz2 shared ...

PC-BSD 1.4 beta – Release name: da Vinci

07.21.2007 · Posted in Unix

After months of hard work, the PC-BSD team is pleased to make available the 1.4 BETA release. This version includes many exciting new features and software, such as: 3D desktop support via Beryl KDE 3.5.7 FreeBSD 6.2 Xorg 7.2 New GUI tools & utilities Optional Components, and much more Changelog : PCBSD 1.4 BETA  – ...

php 5.2.3 upgrade more issue

07.21.2007 · Posted in PHP

Warning: session_save_path() [ href="function.session-save-path">function.session-save-path]: open_basedir restriction in effect. with error reporting set, blank page won’t give anything A little work need to be done since session not working properly after upgrade php from php 4.4.7 to php 5.2.3. After doing install and uninstall php5 ports in freebsd 6.2 box. I can see that error. Googling ...