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!
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;
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
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(idint(11) NOT NULL AUTO_INCREMENT,loginvarchar(50) DEFAULT NULL,pwdvarchar(50) DEFAULT NULL,fullNamevarchar(100) DEFAULT NULL,emailvarchar(70) DEFAULT NULL,languagevarchar(32) NOT NULL,themevarchar(32) NOT NULL,commenttext NOT NULL,rolesmallint(1) NOT NULL DEFAULT '0',hiddensmallint(1) NOT NULL DEFAULT '0',pwdExpirationdatetime NOT NULL DEFAULT '0000-00-00 00:00:00',loginfailurestinyint(4) NOT NULL DEFAULT '0',disabledsmallint(1) NOT NULL DEFAULT '0',quotabigint(20) DEFAULT NULL,homefolderint(11) DEFAULT NULL,PRIMARY KEY (
id),UNIQUE KEY
login(login),KEY
tblUsers_homefolder(homefolder),CONSTRAINT
tblUsers_homefolderFOREIGN KEY (homefolder) REFERENCEStblFolders(id)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;
--
-- Dumping data for table
tblUsers--
LOCK TABLES
tblUsersWRITE;/!40000 ALTER TABLE
tblUsersDISABLE KEYS /;INSERT INTO
tblUsersVALUES (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
tblUsersENABLE KEYS /;UNLOCK TABLES;
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