/etc/rc.local and pure-ftp

pure-ftp already run in port 21 and other instance needed to make different server call

existing one controlled by /etc/rc.conf and I don’t know howto configure another one

after searching google I found clue about rc.local

by default rc.local not exist, I have to create one :

kongja# ee /etc/rc.local

put this lines :

#!/bin/sh

/usr/local/sbin/pure-ftpd -S 172.88.1.15,212 -A -c50 -j -l mysql:/home/alamster/ftp/pureftpd-mysql_login.conf &

save by press Esc button

either execute it by typing :

kongja# sh /etc/rc.local

or by restarting  server then I can see two ftp service running . One using port 21 and another one using port 212

kongja# ps -ax | grep ftp
 1063  ??  I      0:00.03 pure-ftpd (SERVER) (pure-ftpd)
64979  p0- I      0:00.02 pure-ftpd (SERVER) (pure-ftpd)

 to make sure :

kongja# netstat -an | grep LISTEN
tcp4       0      0  *.21                   *.*                    LISTEN
tcp4       0      0  172.88.1.15.212         *.*                    LISTEN

great, I hope I not breaking anything by putting this line in rc.local 🙂

in Unix | 257 Words

Configure FTP server in windows for quick class task

Chemistry class will be over and assignment need to collect  very soon. I have to set quick ftp server shared folder to accomplished that task.

Each student must send their task  via ftp. Filezilla already set in last meeting, now  must configure it for student, need quick and easy way.

1. Student save their task with winzip file with their name as file name

2. Using assigned user : class1 and password 123456

3. Shared folder in read and write mode,  they must honest, as md5 file of their task is the only proof for receipt 🙂

Here’s my steps for configure Filezilla FTP server :

Click FileZilla Server Interface to edit some configuration

Continue reading

Installing your favorite mysql version in FreeBSD

Ports offer more flexibility than package in general but when dealing with size I prefer using package 🙂

My common question when see this on freebsd ports page :

to get mysql support on php, I must install mysql-client-5.0.41 thats means I must install mysql5 server too if I decide to install mysql in my server, I prefer to install mysql4. Is it possible?

I’m luckly, freebsd ports offer flexible options, simple trick to use mysql 4.0.27 with php4 is installing mysql4 server first.

after installing mysql server version 4 then php4-mysql will use mysql4-client automatically.

with this option some options for favorit mysql version available, depend on you.

-bash-2.05b$ cd /usr/ports/databases/
-bash-2.05b$ ls | grep mysql

Continue reading

DNS service, freedom to manage your server

A lot of scenario in my mind with "free" things around domain, hosting and email which is DNS.

There is many provider offer DNS management for free like :

these provider offer dns management that you can use for  :

  1. Hosting your blog for free at awardspace, pointing your email at google apps plus other facility in google like gtalk etc.
  2. Hosting your blog in your own server, pointing your email at google apps
  3. Hosting your own email with free hosting from awardspace or other free hosting

Off course first scenario is the best, only need domain to start

Wait, if you wanna free domain then you can check out this thread :

"Win a year’s worth of hosting at BloggingTips.com"

Make sure to prepare yourself to win by reading this article :

 

in Blog | 158 Words

Some mysql sql basic command I must remember

I use phpmyadmin in daily environment, do I still know  sql command?

My sql file too large, it’s hard to import using phpmyadmin, please help me

Some question around mysql from my student, my false make them spoil using phpmyadmin all day long 🙂

Here’s my answers :

1. Command to create database

create database databasename

2. Delete database

drop database databasename

3. Import database

mysql -uusername -ppassword databasename < databasename.sql

4. Export database

mysqldump -uusername -ppassword databasename > databasename.sql

5. Pick database and choose one to manage

use databasename

6. List all table in database

show tables

 Illustration in mysql command line :

Continue reading