Installing CE 7.3 on ubuntu not working

[karlhui]

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]

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]

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]

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]

Thank you car031

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