Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 12th February 2010, 17:23
HARMANE HARMANE is offline
Junior Member
 
Join Date: Feb 2010
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Question Run pureftpd with multiple mysql databases (Ubuntu 9.10/ISPConfig 3/PureFTPd/Quota)?

I have followed the Perfect Server Ubuntu 9.10/ISPConfig 3 tutorial and everything works just fine. I am also wanting to use the Virtual Hosting with PureFTPd and MySQL on Ubuntu 9.10 tutorial (http://www.howtoforge.com/virtual-ho...on-ubuntu-9.10) on the same machine for exclusive ftp access. That works as well but I only know how to run pureftpd once with the respective mysql.conf for each setup and have been swapping them out and restarting pureftp to confirm both do in fact work.

So, is there a way that I can achieve this without too much hassle? I like the ability to control user accounts securely via mysql with the Virtual Hosting tutorial, limiting to just one local system account, but also want ftp access (obviously) on the web-hosting side AND would like to keep them completely separate. I'm not an advanced Linux user but from what I can tell it looks like I would only need a script to run pureftpd with separate mysql databases and configure different ports for each instance maybe? I have a second NIC on the server so multiple IP's would probably be the safest option as to not change ports on users.

Any help is appreciated!

Last edited by HARMANE; 12th February 2010 at 17:25. Reason: title
Reply With Quote
Sponsored Links
  #2  
Old 13th February 2010, 16:24
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,721 Times in 2,562 Posts
Default

You don't need multiple MySQL databases. You can add a new record in the ftpd table for each account.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 14th February 2010, 14:38
HARMANE HARMANE is offline
Junior Member
 
Join Date: Feb 2010
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko View Post
You don't need multiple MySQL databases. You can add a new record in the ftpd table for each account.
When I run the mysql.conf from the Virtual Hosting tutorial I can access ftp with accounts I create under phpmyadmin but cannot access ftp from the web-hosting side, and vice-versa. Each mysql.conf needs to be run separately. Unless I'm missing something. Do I have to create the ftp user in ISPConfig and in phpmyadmin?

I also have the server setup with the Ubuntu 9.10/ISPConfig 3 tutorial, not ISPConfig 2. Setup seems to be quite different.

Last edited by HARMANE; 14th February 2010 at 15:36.
Reply With Quote
  #4  
Old 16th February 2010, 18:45
HARMANE HARMANE is offline
Junior Member
 
Join Date: Feb 2010
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default

I've investigated further and can't seem to find a solution to this. I've separated mysql.confs from each tutorial, mysql.conf_ispconfig and mysql.conf_vhosting. From what I've gathered, there isn't one singular config file that governs pureftp but rather a wrapper that looks for single line pre-defined files in /etc/pure-ftp/conf. I restart pureftpd with the db I want as designated in /etc/pure-ftp/conf/MySQLConfigFile.

The info I did find that uses a pure-ftp.conf file doesn't seem to pertain to pure-ftpd-mysql. I've also looked into running a virtual ftp server but again, I can't see how it would fit into the configuration I am using. Only option I can see is separate machines altogether.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems installing LAMP - MySQL and PHP5 JosBR Server Operation 5 19th December 2009 21:00
Upgradeded to mysql4.1 breaks mysql client PoleCat Installation/Configuration 5 22nd April 2008 17:38
You cannot assign MySQL databases to this website. vaio1 General 3 15th August 2007 20:11
PureFTPD and Mysql Questions chrchcol Server Operation 1 3rd September 2006 23:07
Multiple MySQL Queries - with Postfix-mysql, courier-authmysql, maildrop-mysql... snowfly HOWTO-Related Questions 4 7th July 2006 04:19


All times are GMT +2. The time now is 19:36.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.