Password Access

[Oswall Verny AC]

Hello,
Which is the username and password to enter to the system.
Attempt to enter in Windows, but I do not have this information.
Where I can obtain more documentation.
Thanks.

[Shamsul Bahrin Abd Mutalib]

Try these username/passwords

administrator = admin/admin
student = student/student
teacher = teacher/teacher

[Oswall Verny AC]

The error is the console:
Run the portal at http://localhost:7502/educate
ConnectionSource -SQLException :  - Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused: connect
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
        at com.mysql.jdbc.Connection.<init>(Connection.java:405)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at lebah.db.ConnectionSource.createConnection(ConnectionSource.java:123)
        at lebah.db.ConnectionSource.newConnection(ConnectionSource.java:81)
        at lebah.db.ConnectionSource.getConnection(ConnectionSource.java:152)
        at lebah.db.Db.<init>(Db.java:88)
        at lebah.db.Db.<init>(Db.java:55)
        at lebah.portal.TabDb.getTabs(TabDb.java:63)
        at lebah.portal.TabDb.getRoleTabs(TabDb.java:48)
        at lebah.portal.Tabber.prepareEnvironment(Tabber.java:67)
        at lebah.portal.Tabber.<init>(Tabber.java:46)
        at lebah.portal.DesktopController.createPortalPage(DesktopController.java:524)
        at lebah.portal.DesktopController.doBody(DesktopController.java:352)
        at lebah.portal.DesktopController.doPost(DesktopController.java:46)
        at lebah.portal.DesktopController.doGet(DesktopController.java:42)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
        at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
        at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
        at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:286)
        at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:127)
        at lebah.portal.handler.DesktopHandler.process(DesktopHandler.java:38)
        at lebah.portal.InterceptorServlet.service(InterceptorServlet.java:68)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
        at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
        at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
        at org.mortbay.jetty.Server.handle(Server.java:324)
        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
        at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:829)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
        at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
        at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)
** END NESTED EXCEPTION **

[Shamsul Bahrin Abd Mutalib]

That was my mistake!

The download package actually comes bundled with HSQL database, and it should use the HSQL instead of MySQL, as shown in the exceptions.

So, what u need to do...

In folder educate/WEB-INF/classes

you will find a file dbconnection.properties

the content of the file is about how to connect to a database, and now the database is MySQL.  Replace the whole content with below:

ConnectionPool=true

##--- for HYPERSONIC SQL

driver=org.hsqldb.jdbcDriver
user=sa
password=
url=jdbc:hsqldb:file:F:/educate/data/lebah_db

But, be careful, with the url above, the folder F:/, change it to your own directory.

Regards..
Shamsul Bahrin

[Oswall Verny AC]

I already install it,  works very well with HSQL.
Very I am interested in installing it for Linux server and Mysql.
If you can help me. Do you have more documentation?

[Shamsul Bahrin Abd Mutalib]

The system should run well in linux without any modification.

For the database, the only things you need to configure is the dbconnection.properties file.  Every database have their own properties values, you can check these in folder WEB-INF/properties.  Here, there are a bunch of .properties files for different database servers.

We have already implement this web application in a linux environment, using postgesql as the database.

Shamsul Bahrin.