Installation of CE on Windows server

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

Moderator: car031

sjropiak
Posts: 23
Joined: Wed Nov 09, 2011 1:59 pm

Re: Installation of CE on Windows server

Fri Dec 09, 2011 4:54 pm

So, here is my configuration:

Server 2008 R2
Java installed
java_home variable set, MySQL server installed and a logicaldoc database created.

My installation is sitting at this prompt in the script:
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Dec 9, 2011 10:23:36 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 5557 ms

It does not seem to go any further. Can anyone offer any troubleshooting suggestions?
mmeschieri
Posts: 242
Joined: Mon Apr 19, 2010 3:40 pm

Re: Installation of CE on Windows server

Fri Dec 09, 2011 5:14 pm

Do you have some port already locked by other processes?
sjropiak
Posts: 23
Joined: Wed Nov 09, 2011 1:59 pm

Re: Installation of CE on Windows server

Fri Dec 09, 2011 6:00 pm

It's a fresh server with only Java and Mysql installed. When I scroll back through the script output, I do see errors saying that a table was not found.
mmeschieri
Posts: 242
Joined: Mon Apr 19, 2010 3:40 pm

Re: Installation of CE on Windows server

Fri Dec 09, 2011 6:16 pm

Ok, post the log telling you about what is not found
sjropiak
Posts: 23
Joined: Wed Nov 09, 2011 1:59 pm

Re: Installation of CE on Windows server

Fri Dec 09, 2011 6:22 pm

... 29 more
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL gram
mar [select ld_id from ld_document where ld_deleted=1 order by ld_lastmodified d
esc]; nested exception is java.sql.SQLException: Table not found in statement [s
elect ld_id from ld_document]
mmeschieri
Posts: 242
Joined: Mon Apr 19, 2010 3:40 pm

Re: Installation of CE on Windows server

Fri Dec 09, 2011 6:35 pm

The reason is that you have an empty database. Please exectute the web setup page and make sure to put the correct connection parameters. take care to have a free and empty database schema, and use this one.
sjropiak
Posts: 23
Joined: Wed Nov 09, 2011 1:59 pm

Re: Installation of CE on Windows server

Mon Dec 12, 2011 1:39 pm

Now I'm confused. My understanding of the process is:

1. install Java
2. install MySql server,
3. Set the variables the Catalina batch files needs
4. From the appropriate directory, execute catalina run

If these steps are incorrect or if I have omitted something, please tell me the proper order. I see in an earlier post to execute a web based setup. At what point is that done?

Thanks,

Steve
mmeschieri
Posts: 242
Joined: Mon Apr 19, 2010 3:40 pm

Re: Installation of CE on Windows server

Mon Dec 12, 2011 2:09 pm

the correct sequence would be:
1. install Java
2. install MySql server
3. prepare an empty database schema into the MySql sercer
4. Set the variables the Catalina batch files needs
5. From the appropriate directory, execute catalina run
6. Execute the web setup (http://localhost:8080/logicaldoc/setup)
sjropiak
Posts: 23
Joined: Wed Nov 09, 2011 1:59 pm

Re: Installation of CE on Windows server

Mon Dec 12, 2011 3:04 pm

If i need to wait for Catalina to finish prior to running the web setup, that is an issue as Catalina does not finish. I did password protect the mySQL instance per our company's security policy. Is that a problem for Catalina? If so, I can remove the password and apply for a security exception.
mmeschieri
Posts: 242
Joined: Mon Apr 19, 2010 3:40 pm

Re: Installation of CE on Windows server

Mon Dec 12, 2011 3:21 pm

No this is not an issue.
Please try to run Tomcat on another server, to check if you have something strange into the actual environment.

Return to “Installation”

Who is online

Users browsing this forum: No registered users and 34 guests