Falko help -Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Manage

Discussion in 'Installation/Configuration' started by bobbob, Apr 24, 2012.

  1. bobbob

    bobbob New Member

    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 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 !
  2. bobbob

    bobbob New Member

    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 !
  3. falko

    falko Super Moderator Howtoforge Staff

    Are there any errors in your logs?

    What are the outputs of
    ls -la /home/

Share This Page