Page 1 of 1

LogicalDOC 7 CE MySQL schema?

Posted: Tue Aug 19, 2014 2:00 pm
by hdv_erasmus
I've installed LogicalDOC 7 CE on Ubuntu and startup works.

Login on http://localhost:8080/ with admin/admin does NOT work (access denied).
http://localhost:8080/setup gives a weird layout; radio buttons not active, missing images, etc.

dms.log gives errors like "can't find object LD_GENERIC" etc.

I *have* created an empty logicaldoc database and configured JDBC to connect to my MySQL server and all that.

Must I manually create the tables in the logicaldoc database?
If so, where can I get the database schema?

UPDATE: i found the SQL initialization script hidden away somewhere and used it. The "missing object" errors are now gone, but I'm still getting "Access denied" and the weird layout in /setup...

Re: LogicalDOC 7 CE MySQL schema?

Posted: Tue Aug 19, 2014 2:19 pm
by mmeschieri
The database schema is available here:
WEB-INF/lib/logicaldoc-core-7.0.1.jar!sql/logicaldoc-core-sql

Re: LogicalDOC 7 CE MySQL schema?

Posted: Tue Aug 19, 2014 2:56 pm
by hdv_erasmus
Yes, but I'm still getting "Access denied" on /logicaldoc and weird layout on /logicaldoc/setup...

Re: LogicalDOC 7 CE MySQL schema?

Posted: Thu Aug 21, 2014 8:32 am
by agaspa
Yes, you're right,
we will release today (21 Augurst 2014) a new 7.0.2RC version of LogicalDOC CE.
Unfortunately, the version 7.0.1 of LogicalDOC CE has come up with a css setting completely wrong in the setup, and this makes it less usable.
We'll fix it as soon as possible

Re: LogicalDOC 7 CE MySQL schema?

Posted: Thu Aug 21, 2014 2:07 pm
by agaspa
Hi hdv_erasmus,
I suggest you to start with a fresh LogicalDOC CE, today we released LogicalDOC CE 7.0.2-RC.

Here is the link to the download:
http://sourceforge.net/projects/logical ... p/download

Also there are specific instructions for the installation
http://sourceforge.net/projects/logical ... t/download

Note: we fixed the setup skin issue

Alex

Re: LogicalDOC 7 CE MySQL schema?

Posted: Mon Aug 25, 2014 1:32 pm
by hdv_erasmus
Thank you, this worked.