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 24th April 2012, 10:20
bobbob bobbob is offline
Junior Member
 
Join Date: Nov 2010
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default Falko help -Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Manage

Falko help ,

I installed "Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Management) On Fedora 14" , but on FEDORA 15 with last MySQL ...and I received an error :

USE pureftpd;

CREATE TABLE ftpd (
User varchar(16) NOT NULL default '',
status enum('0','1') NOT NULL default '0',
Password varchar(64) NOT NULL default '',
Uid varchar(11) NOT NULL default '-1',
Gid varchar(11) NOT NULL default '-1',
Dir varchar(128) NOT NULL default '',
ULBandwidth smallint(5) NOT NULL default '0',
DLBandwidth smallint(5) NOT NULL default '0',
comment tinytext NOT NULL,
ipaccess varchar(15) NOT NULL default '*',
QuotaSize smallint(5) NOT NULL default '0',
QuotaFiles int(11) NOT NULL default 0,
PRIMARY KEY (User),
UNIQUE KEY User (User)
) TYPE=MyISAM;


ERROR MESSAGE :

"ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 16 '

WHAT IS THE RIGHT SYNTAX ? Please help !
Reply With Quote
Sponsored Links
  #2  
Old 24th April 2012, 14:56
bobbob bobbob is offline
Junior Member
 
Join Date: Nov 2010
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Found the right syntax " ) ENGINE=MyISAM; " ...it created me the table ...so inserted some user , but here are some problemms ...don't create me in /home/www.example.com right dir. I thought if I access the new user, the directory will be created automatically, but that directory did not appear. How do I do?

Falko help !
Reply With Quote
  #3  
Old 25th April 2012, 13:47
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,724 Times in 2,564 Posts
 
Default

Quote:
Originally Posted by bobbob View Post
I thought if I access the new user, the directory will be created automatically, but that directory did not appear. How do I do?

Falko help !
Are there any errors in your logs?

What are the outputs of
Code:
ls -la /home/
and
Code:
getenforce
?
__________________
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
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 with Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Mana ikkem HOWTO-Related Questions 33 8th June 2012 18:27
Virtual Hosting With PureFTPd And MySQL quota problem GaulHahn Server Operation 3 29th July 2008 14:32
Saving data on other disk with “Virtual Hosting With PureFTPd And MySQL Ubuntu 7.10" yoyoman HOWTO-Related Questions 1 19th February 2008 06:45
Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Management) sEby HOWTO-Related Questions 3 22nd January 2008 03:21
Virtual Hosting With Proftpd And MySQL (Incl. Quota) - user/group issue shaft_manlike HOWTO-Related Questions 7 16th July 2007 10:27


All times are GMT +2. The time now is 01:12.


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