JForum re-install database problem.

[John Dorian]

Hi.

I have decided to use the JForum and I have got a big problem. Maybe solution is easy and obvious, but I have no experience with it.
When I want to use JForum i have to download it and deploy on my server. I choose a database, type a password etc. But ... for example, when i want to restart my server I have to walk through installation process again. So I have to create new database, so I lose my data in DB, because JForum creates new, empty DB.
I want to use "old" (not empty) DB when I re-install my JForum. Can I do it?
I've tried export my DB before restart server, and then import it, but it doesn't work. (For example i can't log-in because password isn't correct (hash is changed when I did re-install).
I use Wildfly server and PostgreSql DB.

Please, help me.

[Ulf Dittmer]

when i want to restart my server I have to walk through installation process again.

Why do you think you have to to do that? Installation is a one-time thing that you never need to do again (and should not do again, precisely for the reason that you lose your data).

By the way, you are using JForum 2.4.1, yes? All earlier versions have serious security issues and should be avoided. That version is supported in the forums at http://jforum.andowson.com/forums/list.page

[John Dorian]

thank you for reply.

yes I use 2.4.1 version.
I ask about it because, - for example - : when my server will crash and restart will be necassary i'll lose my data in DB, because i'll have to delploy JForum again, so walk through a installation process again. So i I want to do copy of my JForum's DB from time to time and import it to the JForum when it will be necessary. Can i do it?

Other case.

When new version of JForum will be avalible i'll download it, and i'll deploy it on my server. And i'll want to use my old DB, how Will I import it?

[John Dorian]

Why do you think you have to to do that? Installation is a one-time thing that you never need to do again (and should not do again, precisely for the reason that you lose your data).

Every time i restart my WildFly service and run my JForum, installation form is displayed and every time forum is created from scratch.

[Ulf Dittmer]

because i'll have to delploy JForum again

That's what I'm asking - why do you think you need to do that? You don't need to, and should not.

When new version of JForum will be avalible i'll download it, and i'll deploy it on my server. And i'll want to use my old DB, how Will I import it?

In that case you would run the upgrade procedure, not the installation procedure, so there's no need to export or import the DB. If a DB migration is necessary, then that version's wiki page (e.g. https://sourceforge.net/p/jforum2/wiki2/NewFeatures241/) would mention it, and there would be a DB script in the "upgrade" directory (see the source at https://sourceforge.net/p/jforum2/code/HEAD/tree/trunk/).

[Ulf Dittmer]

Every time i restart my WildFly service and run my JForum, installation form is displayed and every time forum is created from scratch.

Only just saw this. The installation form is displayed even if you access an URL like http://localhost:8080/jforum2/? That sounds odd. You should actually remove the mapping of the InstallServlet after the initial install, so that nobody accidentally accesses it.

[John Dorian]

The installation form is displayed even if you access an URL like http://localhost:8080/jforum2/?

Yes.

You should actually remove the mapping of the InstallServlet after the initial install, so that nobody accidentally accesses it.

How should I do it? In web.xml :

<!-- Mapping --> <servlet-mapping> <servlet-name>install</servlet-name> <url-pattern>/install/install.page</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>jforum</servlet-name> <url-pattern>*.page</url-pattern> </servlet-mapping>

remove these lines :
<servlet-mapping> <servlet-name>install</servlet-name> <url-pattern>/install/install.page</url-pattern> </servlet-mapping>
?

[Ulf Dittmer]

Yes, after the initial run that extracts the war file. Or does your servlet container a) not unpack the war file, or b) does it do so every time the server is started?

[John Dorian]

What Am I doing wrong?
1. Download JForum.2.4.1.war
2. Change its name on test.war
3. Copy it to a standalone/deployments directory on my server.
4. Waiting for a deployed status.
5. test.war file is deployed.
6. type in browser's url bar: localhost:8080/test
7. Installation form.
8. Installation is completed.
9. It works.
10. Turn off server.
11. Unpack test.war file locally (not in the server)
12. Remove "mapping" lines from web.xml
13. Create new test.war file : jar -cvf test.war * (in unpacked catalog)
14. Copy test.war file to a standalone/deployments directory on my server.
15. Run server
16. Waiting for deployed status
17 test.war file is deployed
18. type in browser's url bar: localhost:8080/test
19 ... and error occurs:

Context Path:/test
Servlet Path:/forums/list.page
Path Info:null
Query String:null
Stack Trace
net.jforum.exceptions.ForumStartupException: Error while starting jforum
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
net.jforum.C3P0PooledConnection.getConnection(C3P0PooledConnection.java:156)
net.jforum.JForum.init(JForum.java:121)
io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)
org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)
io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:230)
io.undertow.servlet.core.ManagedServlet.getServlet(ManagedServlet.java:169)
io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130)
net.jforum.csrf.CsrfFilter.doFilter(CsrfFilter.java:71)
io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)
io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51)
io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56)
io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)
io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:72)
io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)
io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:282)
io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:261)
io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:80)
io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:172)
io.undertow.server.Connectors.executeRootHandler(Connectors.java:199)
io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:774)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
java.lang.Thread.run(Thread.java:745)

[Ulf Dittmer]

Hard to say, you may want to ask the question over at http://jforum.andowson.com/forums/list.page where JForum 2.x is supported.

[John Dorian]

I completely don't understand.
Problem occurs when deploying process is run:
If I install JForum and then remove test.deployed file without restart server, and when i refresh page (after create new test.deployed file) page is loading about 5 minuts and error occurs.
If I dont walk through a install process page loads without errors.

Where is the problem?
WildFly configuration, JForum, anything else?

Is any alternative for JForum 2.4.1 which I can use?

[John Dorian]

Ok i solved my problem.
Manual installation helped.
Thanks guys for help.