Installing CE 7.3 on ubuntu not working

Problems with installing LogicalDOC? No problems, the solution is closer than you think.

Moderator: car031

karlhui
Posts: 4
Joined: Fri Oct 23, 2015 11:12 am

Installing CE 7.3 on ubuntu not working

Mon Oct 26, 2015 10:39 am

Dear all,

I exactly follow the same steps on this site: http://www.unixmen.com/setup-logicaldoc-ubuntu-15-04/ however it shows "database not connected" on localhost:8080, even the admin/admin couldn't login.

I checked the install log, it said:
dbinit:
[echo] Database schema not created, perhaps it already exists
[echo] Executing sql file sql/logicaldoc-core.sql.mysql
[echo] Unable to import data
[echo] The following error occurred while executing this line:
[echo] /LogicalDOC/loader/build.xml:79: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

I really don't know what I'm missing, please help, thank you.
car031
Posts: 154
Joined: Tue Apr 17, 2012 8:27 am

Re: Installing CE 7.3 on ubuntu not working

Tue Oct 27, 2015 1:55 pm

It seems that MySQL is up and running but you are using a wrong password. Please try to connect to MySQL with the root user.
karlhui
Posts: 4
Joined: Fri Oct 23, 2015 11:12 am

Re: Installing CE 7.3 on ubuntu not working

Wed Oct 28, 2015 9:30 am

I tried with root user but no luck.

Later I tried access http://localhost:8080/setup and the error is gone, I have no idea why.

After the installation I found that the Administration -> Reports -> Last Changes no matter what event I choose to search there is no result, will it be related to the MySQL issue?

Thanks.
car031
Posts: 154
Joined: Tue Apr 17, 2012 8:27 am

Re: Installing CE 7.3 on ubuntu not working

Wed Oct 28, 2015 10:58 am

execute this against your DB:

create table ld_workflowhistory (ld_id bigint not null, ld_lastmodified timestamp not null, ld_recordversion bigint not null,
ld_deleted int not null, ld_tenantid bigint not null, ld_date timestamp, ld_event varchar(255),
ld_comment varchar(4000), ld_docid bigint, ld_userid bigint,
ld_username varchar(255), ld_templateid bigint not null,
ld_instanceid varchar(255), ld_sessionid varchar(255),
ld_new int, ld_filename varchar(255), primary key (ld_id));
karlhui
Posts: 4
Joined: Fri Oct 23, 2015 11:12 am

Re: Installing CE 7.3 on ubuntu not working

Thu Oct 29, 2015 9:37 am

Thank you car031

I have executed those line in mysql, waiting to have the report!

Return to “Installation”

Who is online

Users browsing this forum: No registered users and 1 guest