Solved

FreeBSD + ProFTPD + MySQL

Posted on 2004-08-10
13
1,474 Views
Last Modified: 2008-02-01
Hi there.

How do I install ProFTPD with MySQL support, so I can administrat my users through my MySQL database installed on the same server?
0
Comment
Question by:medions
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
13 Comments
 
LVL 62

Expert Comment

by:gheist
ID: 11764003
By creating web forms in Perl or PHP.
0
 

Author Comment

by:medions
ID: 11764070
That does not have anything to do with my problem...
What I want, is how to install the ProFTP, with MySQL Support, and how to set it op so it work!
0
 
LVL 62

Expert Comment

by:gheist
ID: 11765220
/usr/ports/ftp/proftpd ; make install
0
The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

 
LVL 62

Expert Comment

by:gheist
ID: 11765227
cd  /usr/ports/ftp/proftpd ; make WITH_MYSQL=yes install
0
 

Author Comment

by:medions
ID: 11765588
It looks good... But before i'm starting, what version of MySQL do you perfer to install for this opputunity?
0
 

Author Comment

by:medions
ID: 11765602
And how do i set the configurationfile op so it works with the MySQL tables?
0
 
LVL 62

Accepted Solution

by:
gheist earned 250 total points
ID: 11766602
This example is all you need to use ProFTPD with MySQL auth and logging
http://www.proftpd.org/docs/configs/mysql_simple.conf
Not sure about underlying table structure...

Not sure bout versions, you have multiple choices for MySQL
As from MySQL site: 3.x is old 4.0 is stable, 4.1 is testing 5.0 is experimental.
If you have plans to launch your service later than in a month, you can use 4.1 and upgrade when it becomes stable (and your test period is over)
If you launch tomorrow, then 4.0 is suggested

databases/mysql323-client
databases/mysql323-scripts
databases/mysql323-server
databases/mysql40-client
databases/mysql40-scripts
databases/mysql40-server
databases/mysql41-client
databases/mysql41-scripts
databases/mysql41-server
databases/mysql50-client
databases/mysql50-scripts
databases/mysql50-server

Look here too for ways to patch FreeBSD ports to get safer versions of MySQL and kernel
http://www.experts-exchange.com/Operating_Systems/FreeBSD/Q_21084480.html
0
 

Author Comment

by:medions
ID: 11786043
I installed PureFTPD insted of ProFTPD.

But thanks for your help.
0
 

Author Comment

by:medions
ID: 11786052
Hmm how do i give you 50 points, and take the 200 for myself?
0
 
LVL 62

Expert Comment

by:gheist
ID: 11787151
There is no way
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tech tip describes how to install the Solaris Operating System from a tape backup that was created using the Solaris flash archive utility. I have used this procedure on the Solaris 8 and 9 OS, and it shoudl also work well on the Solaris 10 rel…
My previous tech tip, Installing the Solaris OS From the Flash Archive On a Tape (http://www.experts-exchange.com/articles/OS/Unix/Solaris/Installing-the-Solaris-OS-From-the-Flash-Archive-on-a-Tape.html), discussed installing the Solaris Operating S…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question