HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   Falko help -Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Manage (http://www.howtoforge.com/forums/showthread.php?t=57045)

bobbob 24th April 2012 10:20

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 !

bobbob 24th April 2012 14:56

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 !

falko 25th April 2012 13:47

Quote:

Originally Posted by bobbob (Post 278109)
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
?


All times are GMT +2. The time now is 06:03.

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