Cannot login to fresh install of

Discussion in 'Installation/Configuration' started by demofreak, Oct 13, 2013.

  1. demofreak

    demofreak New Member


    I followed the tutorial at and installed ISPConfig to a fresh installed OpenSUSE 12.3/Tumbleweed system.
    All seemed to work fine, despite the fact that the login screen is incomplete i.e. shows some debug text.


    First the Apache error log showed some "Permission denied" lines
    Permission denied: file permissions deny server access: /srv/www/ispconfig[...]
    and I changed the permissions of /srv/www/ispconfig to 777 for testing. After that the log files stay clean (no error messages, only access log), but the login prompt is still incomplete.

    I don't know where to look further, could you give me some hint please? ;-)

    Thanks and regards,

  2. demofreak

    demofreak New Member

    Finally found the solution: the database was incompletely initialized because of an error in the SQL syntax in install/sql/ispconfig3.sql (see patch below).

    diff -ur ispconfig3_install/install/sql/ispconfig3.sql
    --- ispconfig3_install/install/sql/ispconfig3.sql       2013-08-09 13:13:40.000000000 +0200
    +++   2013-10-13 02:36:50.127884579 +0200
    @@ -223,7 +223,7 @@
       `language` char(2) NOT NULL DEFAULT 'en',
       `usertheme` varchar(32) NOT NULL DEFAULT 'default',
       `template_master` int(11) unsigned NOT NULL DEFAULT '0',
    -  `template_additional` text NOT NULL DEFAULT '',
    +  `template_additional` text NOT NULL, -- DEFAULT '',
       `created_at` bigint(20) DEFAULT NULL,
       `id_rsa` varchar(2000) NOT NULL DEFAULT '',
       `ssh_rsa` varchar(600) NOT NULL DEFAULT '',
    @@ -1589,7 +1589,7 @@
       `typ` varchar(16) NOT NULL default 'user',
       `active` tinyint(1) NOT NULL default '1',
       `language` varchar(2) NOT NULL default 'en',
    -  `groups` TEXT NOT NULL default '',
    +  `groups` TEXT NOT NULL, -- default '',
       `default_group` int(11) unsigned NOT NULL default '0',
       `client_id` int(11) unsigned NOT NULL default '0',
       `id_rsa` VARCHAR( 2000 ) NOT NULL default '',
    Now the login prompt appears and all seems to work fine. :)

  3. demofreak

    demofreak New Member

Share This Page