Installing VELO 1.4 on Ubuntu

[coocooche]

Hi guys,
here i come...right back where i started from ;)
So, finally i'm going to install VELO 1.4. I've noticed that version
1.4 exist only for Windows users.
I installed VELO under Windows Vista OS with the installer and
everything is ok. It works!
But i want to work on Ubuntu so i did as follow (i imported VELO's
installed files and MySQL data from Vista OS to Ubuntu):

- I did the copy of “velo.ear” and “velo-ds.xml” from Jboss on Vista
OS to Jboss on Ubuntu
- I did the copy of directory Velo and i changed various configuration
files such as run.sh,reconcile.sh,run.conf,...
- I made a dump of MySQL Velo's data from Mysql on Vista OS to MySQL
on Ubuntu
- I have Jboss-4.2.3.GA & jbossws-native-2.0.1.GA

At the end I run the Jboss and everything is ok. It works! Then when I
go to http://localhost:8080/velo/admin to login with the credentials
'admin' 'admin', the system gave me: “Login failed” and “Transaction
failed”. Why he didn't recognize the credentials?

Here is a piece of log file:

15:11:07,410 INFO [STDOUT] (!)Factoring Global Configuration
Object...
15:11:07,435 INFO [UserBean] msg
15:11:07,495 ERROR [STDERR] Jan 29, 2010 3:11:07 PM
velo.ejb.impl.CommonUtilsBean addEventLogEntry
INFO: Persisting EventLog entity: Module: SECURITY, Severity: INFO,
Message: User 'ADMIN' has logged in.
15:11:07,523 WARN [JDBCExceptionReporter] SQL Error: 1452, SQLState:
23000
15:11:07,523 ERROR [JDBCExceptionReporter] Cannot add or update a
child row: a foreign key constraint fails
(`velodb`.`VL_EVENT_LOG_DATA_ENTRY`, CONSTRAINT `FKB909F1C674420581`
FOREIGN KEY (`EVENT_LOG_ENTRY_ID`) REFERENCES `vl_event_log_entry`
(`EVENT_LOG_ENTRY_ID`))
15:11:07,526 ERROR [SeamLoginModule] Error invoking login method
javax.el.ELException: javax.ejb.EJBTransactionRolledbackException:
org.hibernate.exception.ConstraintViolationException: could not
insert: [velo.entity.EventLogDataEntry]
at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:
333)
at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:
342)
....

and.....

Caused by:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
Cannot add or update a child row: a foreign key constraint fails
(`velodb`.`VL_EVENT_LOG_DATA_ENTRY`, CONSTRAINT `FKB909F1C674420581`
FOREIGN KEY (`EVENT_LOG_ENTRY_ID`) REFERENCES `vl_event_log_entry`
(`EVENT_LOG_ENTRY_ID`))
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
.....

Thanks,
Gentjan

[Trouby]

Hey,

It seems like you have a problem with the foreign keys in the DB
I'm not sure why but it might be due to the export/import of the data
from win to linux,

Drop all tables, let Velo re-create the tables again,
Then just import the initial content again,

I think that is the right way to go,

Asaf.

On Jan 29, 4:26 pm, coocooche <gentja...@gmail.com> wrote:
> Hi guys,
> here i come...right back where i started from ;)
> So, finally i'm going to install VELO 1.4. I've noticed that version
> 1.4 exist only for Windows users.
> I installed VELO under Windows Vista OS  with the installer and
> everything is ok. It works!
> But i want to work on Ubuntu so i did as follow (i imported VELO's
> installed files and MySQL data from Vista OS to Ubuntu):
>
> - I did the copy of “velo.ear” and “velo-ds.xml” from Jboss on Vista
> OS to Jboss on Ubuntu
> - I did the copy of directory Velo and i changed various configuration
> files such as run.sh,reconcile.sh,run.conf,...
> - I made a dump of MySQL Velo's data from Mysql on Vista OS to MySQL
> on Ubuntu
> - I have Jboss-4.2.3.GA & jbossws-native-2.0.1.GA
>
> At the end I run the Jboss and everything is ok. It works! Then when I

> go tohttp://localhost:8080/velo/adminto login with the credentials

[coocooche]

On Jan 29, 4:35 pm, Trouby <asaf...@gmail.com> wrote:
> Hey,
>
> It seems like you have a problem with the foreign keys in the DB
> I'm not sure why but it might be due to the export/import of the data
> from win to linux,
>
> Drop all tables, let Velo re-create the tables again,
> Then just import the initial content again,
>
> I think that is the right way to go,
>
> Asaf.
>

Hi Asaf,
I already resolved. It's a little bit complicated explain in a few
words how I did. I used the webapp method “http://localhost:8080/velo/
Setup.seam” as for windows for importing the default data. I think my
problem was with “VELO_HOME/tools/conf.sh -C createInitialData” that
didn't populate the repository as I expected.

Thank you for helping me,
Gentjan