[Oreka-user] Oreka Open source Installation Problem.

Hi,
I've installed Oreka RT on Ubuntu 14, and i cannot login to the web
interface using the username /password admin/admin.

*Plus I cannot find the orkaudio service ! after installing the DEB files.*

root@ubuntu:~# tail -f /var/log/tomcat7/catalina.out
619864 [http-bio-8080-exec-5] ERROR net.sf.oreka.services.UserServiceHbn  -
login: exception:
net.sf.oreka.OrkException: HibernateManager.getSession: application must
configure hibernate before using it.

I created an empty database and granted the MySQL user all privileges on it

mysql> SHOW GRANTS FOR 'root'@'localhost';
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost
                                                             |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD
'*B240022AE36BF6A3517C6554E24F51F497458BF9' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `oreka`.* TO 'root'@'localhost'
                                                             |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
                                                              |
+----------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)


root@ubuntu:~# less /etc/oreka/database.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
                "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
                "
http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property
name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
        <property name="hibernate.connection.maxconnections">100</property>
        <property
name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.url">jdbc:mysql://
10.4.4.1/oreka</property>
        <property name="hibernate.connection.password">webdeysql</property>
        <property name="hibernate.connection.username">root</property>

        <property name="hibernate.hbm2ddl.auto">update</property> <!--
update, create, create-drop -->
        <property name="hibernate.show_sql">false</property>

        <property
name="hibernate.jdbc.use_scrollable_resultset">true</property>
        <property name="hibernate.max_fetch_depth">1</property>
        <property
name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
    </session-factory>
</hibernate-configuration>



Best Regards,

Mahmoud Ramadan Ali

Network and VOIP Specialist.

Mobil: (+2) 01276877112

Blog | Website | LinkedIn