ubuntu 18_04 fresh install, app won't start

[rawon]

Greetings,
I’ve installed openboxes on ubuntu 18.04 in VM.
i’m very new to linux
i followed Overview - OpenBoxes exactly and i don’t think i missed anything.

tomcat is displaying normal default page on port 8080 and apache2 is also displaying normal default page on port 80.

when i go to localhost:8080/openboxes, it gives off 404 error. i think it’s just the server cannot find the app in the directory, so,

i tried to put the openboxes.war in opt/tomcat/webapp/openboxes/openboxes.war

still won’t work

please point me at the direction i should look at

thank you so much

[jmiranda]

@rawon Please include catalina.out here.

[rawon]

Hi @jmiranda,

thanks for the prompt response,

attached is the catalina out file
catalina.out (2.5 MB)

thank you beforehand

[jmiranda]

What version of OpenBoxes are you trying to use?

[rawon]

Hi @jmiranda,

i downloaded the Release 0.8.17 Hotfix 4

[jmiranda]

So the following error seems to be causing the issue.

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'openboxes.product_demand_details' doesn't exist
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449)
	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
	at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78)
	at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
	... 17 more

Others have encountered this issue as well (see the following thread for a temporary solution).

How to run openboxes in Apache Netbeans?

To elaborate, we have a view that depends on a derived data table that is created at runtime. If the view definition is executed before that table is run, we’ll run into this bug. The temporary fix was to allow the view creation to fail as it would be recreated on the next restart. https://github.com/openboxes/openboxes/blob/develop/grails-app/migrations/views/changelog.xml#L81 I’m not super happy with that solution, so I would recommend manually executing the following SQL script on your dat…

I’m confused because I was under the impression that 0.8.17-hotfix4 included a hotfix for this issue. But I’m starting to think that it was actually fixed in 0.8.18 (which is to be released in the next week or two). So for now, you’ll need run the SQL in the thread referenced above.

Apologies for the inconvenience.

Justin

[jmiranda]

By the way, you also had a few odd errors occurring earlier last week that allude to a permission issue with your Tomcat installation. You need to make sure that Tomcat owns everything and has permission to create files and directories under the Tomcat home directory.

INFO: Deploying web application archive /opt/tomcat/webapps/openboxes.war
Jun 07, 2022 10:06:12 AM org.apache.catalina.startup.ContextConfig beforeStart
SEVERE: Exception fixing docBase for context [/openboxes]
java.io.IOException: Unable to create the directory [/opt/tomcat/webapps/openboxes]

and

2022-06-07 10:06:36,153 [localhost-startStop-1] WARN  support.PathMatchingResourcePatternResolver  - Cannot search for matching files underneath ServletContext resource [/WEB-INF/plugins/plugin-config-0.1.5/grails-app/i18n/] because it does not correspond to a directory in the file system
java.io.FileNotFoundException: ServletContext resource [/WEB-INF/plugins/plugin-config-0.1.5/grails-app/i18n/] cannot be resolved to absolute file path - web application archive not expanded?
	at org.springframework.web.util.WebUtils.getRealPath(WebUtils.java:232)

[rawon]

Hi @jmiranda,

thank you for the support
i’ll read the link up and try the temporary solution.
really looking forward for the new version that will solve this.

once its out i’ll try a clean install

thanks again

[rawon]

Hi @jmiranda,

thanks for pointing that out. as i said i’m a newbie on linux

awesome job btw, and good support

thank you again

[jmiranda]

Thanks so much @rawon.

[rawon]

Hi @jmiranda

i’ve finally get the app to work and are now exploring the use case
thank you for previous notice and help.

best regards