Cannot login to fresh install of 3.0.5.3

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

  1. demofreak

    demofreak New Member

    Hi,

    I followed the tutorial at http://www.howtoforge.com/perfect-server-opensuse-12.2-x86_64-apache2-dovecot-ispconfig-3 and installed ISPConfig 3.0.5.3 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.

    [​IMG]

    First the Apache error log showed some "Permission denied" lines
    Code:
    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,

    /Hannes
     
  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).

    Code:
    diff -ur ispconfig3_install/install/sql/ispconfig3.sql ispconfig3_install.new/install/sql/ispconfig3.sql
    --- ispconfig3_install/install/sql/ispconfig3.sql       2013-08-09 13:13:40.000000000 +0200
    +++ ispconfig3_install.new/install/sql/ispconfig3.sql   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. :)

    /Hannes
     
  3. demofreak

    demofreak New Member

Share This Page