Menu

Admin user is not working

daChiller
2016-12-01
2016-12-02
  • daChiller

    daChiller - 2016-12-01

    Hi there,
    first, thanks to ank99 for his great installation manual.

    I tried to run this on my present Ubuntu Webserver and after all, the login with admin/admin is not possible.
    The tables in the database have been created successfully, as far as i can tell. I expected a user table somewhere, right?

    I'm sure you guys know that well, don't you? Otherwise, don't hesitate to ask for details!

    Thanks a lot

     

    Last edit: daChiller 2016-12-01
  • ank-99

    ank-99 - 2016-12-02

    Sorry but did not really understand the problem. Are you suspecting that the Users table (tblUsers) has not been created in the SeedDMS db? This is how my test DB looks (if it helps):

    -- Table structure for table tblUsers

    --

    DROP TABLE IF EXISTS tblUsers;
    /!40101 SET @saved_cs_client = @@character_set_client /;
    /!40101 SET character_set_client = utf8 /;
    CREATE TABLE tblUsers (
    id int(11) NOT NULL AUTO_INCREMENT,
    login varchar(50) DEFAULT NULL,
    pwd varchar(50) DEFAULT NULL,
    fullName varchar(100) DEFAULT NULL,
    email varchar(70) DEFAULT NULL,
    language varchar(32) NOT NULL,
    theme varchar(32) NOT NULL,
    comment text NOT NULL,
    role smallint(1) NOT NULL DEFAULT '0',
    hidden smallint(1) NOT NULL DEFAULT '0',
    pwdExpiration datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    loginfailures tinyint(4) NOT NULL DEFAULT '0',
    disabled smallint(1) NOT NULL DEFAULT '0',
    quota bigint(20) DEFAULT NULL,
    homefolder int(11) DEFAULT NULL,
    PRIMARY KEY (id),
    UNIQUE KEY login (login),
    KEY tblUsers_homefolder (homefolder),
    CONSTRAINT tblUsers_homefolder FOREIGN KEY (homefolder) REFERENCES tblFolders (id)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
    /!40101 SET character_set_client = @saved_cs_client /;

    --
    -- Dumping data for table tblUsers
    --

    LOCK TABLES tblUsers WRITE;
    /!40000 ALTER TABLE tblUsers DISABLE KEYS /;
    INSERT INTO tblUsers VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3','Administrator','address@server.com','en_GB','bootstrap','',1,0,'0000-00-00 00:00:00',0,0,0,NULL),(2,'guest',NULL,'Guest User',NULL,'','','',2,0,'0000-00-00 00:00:00',0,0,0,NULL);
    /!40000 ALTER TABLE tblUsers ENABLE KEYS /;
    UNLOCK TABLES;

     
  • daChiller

    daChiller - 2016-12-02

    Hi Ank99,
    thanks for reply!
    Meanwhile I've found, that there are way more threads here in the "General Discussion". So I found the solution for the initial login with the help of optimalus' thread.

    Now I'm trying to gambling around a little bit.

    Greetings

     

Log in to post a comment.

MongoDB Logo MongoDB