Re: Clean project install syncope 1.2.5 not working
Hi both, Hmm, well now I know at least the project itself is functioning properly and got to investigate why mysql aint then.. only things different from default configuration is: datadir = /mnt/disk2/mysql innodb_file_per_table=1 The reason for that is my current mysql instance has a syncope 1.1.8 installation of 70+GB syncope db with ACT_GE_BYTEARRAY.ibd being 63+gb (3800users defined). Which doesn't fit on my SSD... Ill revert these 2 changes back to /var/lib/mysql and run it again today. Thanks for the time again On 09-10-15 08:53, Francesco Chicchiriccò wrote: Hi Ralph, I confirm what Marco said below: barely decompressing your own apache-tomcat-7.0.64.tar.gz from https://www.dropbox.com/sh/u13p574i58frrc8/AACh0uvxuy268doqvoRU7Zxha?dl=0 and starting, everything works (naturally Syncope complains about some paths it could not find, but this is a consequence of not using -Dconf* params when building, as suggested). I did this on my laptop, Kubuntu 15.04 with latest MySQL 5.6 from standard packages and no special configuration. A couple of questions to you: 1. did you make any special configuration for MySQL (like as lower_case_table_names [1] or InnoDB)? 2. can you try to build your own project on a different machine? Regards. [1] http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_lower_case_table_names On 08/10/2015 18:49, Ralph de Boom wrote: A followup, yes, embedded mode works. But with mysql 5.6, the target aimed database we're running on, it's not working. Running on java 7 or 8 doesn't make a difference at all. On 08-Oct-15 18:41, Ralph de Boom wrote: Before running tomcat, delete the database and recreate it. I've been doing this for the past 2 days now... Where should core.log, core-rest.log, console.log be generated? I can't find them... Cheers again. On 08-Oct-15 18:27, Marco Di Sabatino Di Diodoro wrote: Hi Ralph, I used your Apache Tomcat with the deployed wars and it works. After, I runned your src in embedded mode and it works properly. In your uploaded files I can't find syncope logs (core.log, core-rest.log, console.log ...). Before running tomcat, delete the database and recreate it. Marco Il 08/10/2015 14:28, PhoenixtheII ha scritto: I added mysqlquery.log to the same dropbox link. It seems that the syncope tables are never queried if the exists by openjpa. But for the activity tables it does do that, and finds out it needs to make them. -- View this message in context:http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708150.html Sent from the syncope-user mailing list archive at Nabble.com. -- Francesco Chicchiriccò Tirasa - Open Source Excellence http://www.tirasa.net/ Involved at The Apache Software Foundation: member, Syncope PMC chair, Cocoon PMC, Olingo PMC http://people.apache.org/~ilgrosso/
Re: Clean project install syncope 1.2.5 not working
Hi Ralph, I confirm what Marco said below: barely decompressing your own apache-tomcat-7.0.64.tar.gz from https://www.dropbox.com/sh/u13p574i58frrc8/AACh0uvxuy268doqvoRU7Zxha?dl=0 and starting, everything works (naturally Syncope complains about some paths it could not find, but this is a consequence of not using -Dconf* params when building, as suggested). I did this on my laptop, Kubuntu 15.04 with latest MySQL 5.6 from standard packages and no special configuration. A couple of questions to you: 1. did you make any special configuration for MySQL (like as lower_case_table_names [1] or InnoDB)? 2. can you try to build your own project on a different machine? Regards. [1] http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_lower_case_table_names On 08/10/2015 18:49, Ralph de Boom wrote: A followup, yes, embedded mode works. But with mysql 5.6, the target aimed database we're running on, it's not working. Running on java 7 or 8 doesn't make a difference at all. On 08-Oct-15 18:41, Ralph de Boom wrote: Before running tomcat, delete the database and recreate it. I've been doing this for the past 2 days now... Where should core.log, core-rest.log, console.log be generated? I can't find them... Cheers again. On 08-Oct-15 18:27, Marco Di Sabatino Di Diodoro wrote: Hi Ralph, I used your Apache Tomcat with the deployed wars and it works. After, I runned your src in embedded mode and it works properly. In your uploaded files I can't find syncope logs (core.log, core-rest.log, console.log ...). Before running tomcat, delete the database and recreate it. Marco Il 08/10/2015 14:28, PhoenixtheII ha scritto: I added mysqlquery.log to the same dropbox link. It seems that the syncope tables are never queried if the exists by openjpa. But for the activity tables it does do that, and finds out it needs to make them. -- View this message in context:http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708150.html Sent from the syncope-user mailing list archive at Nabble.com. -- Francesco Chicchiriccò Tirasa - Open Source Excellence http://www.tirasa.net/ Involved at The Apache Software Foundation: member, Syncope PMC chair, Cocoon PMC, Olingo PMC http://people.apache.org/~ilgrosso/
Re: Clean project install syncope 1.2.5 not working
Oh, And if you wonder why I was using 'mvn clean package', I had run earlier into different problems with 'mvn clean package -Dconf.directory=/opt/syncope/conf -Dbundles.directory=/opt/syncope/bundles -Dlog.directory=/opt/syncope/log ', in which syncope did do even less. So hence, i started running mvn clean package ^_^ On 09-10-15 13:46, Ralph de Boom wrote: On 09-10-15 13:20, Francesco Chicchiriccò wrote: mvn clean package -Dconf.directory=/opt/syncope/conf -Dbundles.directory=/opt/syncope/bundles -Dlog.directory=/opt/syncope/log Huzzah, I finally found the cause. using mvn clean package, the eventual war generated will contain references to load stuff from the project source directory. Which causes stuff to be loaded on runtime that breaks deploying the war properly. strace -f -e trace=open bin/catalina.sh run 2>>strace2.log 3>>strace2.log cat strace.log | grep open | grep /home/ralph/projects/ [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/log/core.log", O_RDWR|O_CREAT, 0666) = 200 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/log/core-persistence.log", O_RDWR|O_CREAT, 0666) = 201 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/log/core-rest.log", O_RDWR|O_CREAT, 0666) = 202 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/log/core-connid.log", O_RDWR|O_CREAT, 0666) = 203 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/persistence.properties", O_RDONLY) = 204 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/persistence.properties", O_RDONLY) = 204 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/rest.properties", O_RDONLY) = -1 ENOENT (No such file or directory) [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/security.properties", O_RDONLY) = -1 ENOENT (No such file or directory) [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/connid.properties", O_RDONLY) = 204 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/workflow.properties", O_RDONLY) = -1 ENOENT (No such file or directory) [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/mail.properties", O_RDONLY) = 204 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.ldap-1.4.0.jar", O_RDONLY) = 205 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.soap-1.3.0.jar", O_RDONLY) = 205 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.db.table-2.2.2.jar", O_RDONLY) = 205 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.ad-1.2.3.jar", O_RDONLY) = 205 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.csvdir-0.8.2.jar", O_RDONLY) = 205 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.ldap-1.4.0.jar", O_RDONLY) = 205 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.soap-1.3.0.jar", O_RDONLY) = 207 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.db.table-2.2.2.jar", O_RDONLY) = 246 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.ad-1.2.3.jar", O_RDONLY) = 248 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.csvdir-0.8.2.jar", O_RDONLY) = 252 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/console/target/log/console.log", O_RDWR|O_CREAT, 0666) = 107 [pid 27424] open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/console/target/test-classes/console.properties", O_RDONLY) = 108 I don't know which of these files causes the problems I had. But my case is solved. I might add a note that even with 'mvn clean package
Re: Clean project install syncope 1.2.5 not working
https://www.dropbox.com/sh/u13p574i58frrc8/AACh0uvxuy268doqvoRU7Zxha?dl=0 This is all the logs tomcat generates. Included are the apache tomcat directory totally and the maven project src. .wars were generated with mvn clean package Yes, without the -D bundles/logs/conf properties additions to /opt/syncope, because that would give me a different error. (Something with "audit/null"). Thanks for the time in advance ;) -- View this message in context: http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708149.html Sent from the syncope-user mailing list archive at Nabble.com.
Re: Clean project install syncope 1.2.5 not working
I added mysqlquery.log to the same dropbox link. It seems that the syncope tables are never queried if the exists by openjpa. But for the activity tables it does do that, and finds out it needs to make them. -- View this message in context: http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708150.html Sent from the syncope-user mailing list archive at Nabble.com.
Re: Clean project install syncope 1.2.5 not working
Before running tomcat, delete the database and recreate it. I've been doing this for the past 2 days now... Where should core.log, core-rest.log, console.log be generated? I can't find them... Cheers again. On 08-Oct-15 18:27, Marco Di Sabatino Di Diodoro wrote: > Hi Ralph, > > I used your Apache Tomcat with the deployed wars and it works. After, > I runned your src in embedded mode and it works properly. > In your uploaded files I can't find syncope logs (core.log, > core-rest.log, console.log ...). > > Before running tomcat, delete the database and recreate it. > > Marco > > > Il 08/10/2015 14:28, PhoenixtheII ha scritto: >> I added mysqlquery.log to the same dropbox link. It seems that the syncope >> tables are never queried if the exists by openjpa. But for the activity >> tables it does do that, and finds out it needs to make them. >> >> -- >> View this message in context: >> http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708150.html >> Sent from the syncope-user mailing list archive at Nabble.com. > > -- > Dott. Marco Di Sabatino Di Diodoro > Tel. +39 3939065570 > > Tirasa S.r.l. > Viale D'Annunzio 267 - 65127 Pescara > Tel +39 0859116307 / FAX +39 085973 > http://www.tirasa.net > > Apache Syncope PMC Member > http://people.apache.org/~mdisabatino/
Re: Clean project install syncope 1.2.5 not working
A followup, yes, embedded mode works. But with mysql 5.6, the target aimed database we're running on, it's not working. Running on java 7 or 8 doesn't make a difference at all. On 08-Oct-15 18:41, Ralph de Boom wrote: > Before running tomcat, delete the database and recreate it. > > I've been doing this for the past 2 days now... > > Where should core.log, core-rest.log, console.log be generated? I > can't find them... > > Cheers again. > > On 08-Oct-15 18:27, Marco Di Sabatino Di Diodoro wrote: >> Hi Ralph, >> >> I used your Apache Tomcat with the deployed wars and it works. After, >> I runned your src in embedded mode and it works properly. >> In your uploaded files I can't find syncope logs (core.log, >> core-rest.log, console.log ...). >> >> Before running tomcat, delete the database and recreate it. >> >> Marco >> >> >> Il 08/10/2015 14:28, PhoenixtheII ha scritto: >>> I added mysqlquery.log to the same dropbox link. It seems that the syncope >>> tables are never queried if the exists by openjpa. But for the activity >>> tables it does do that, and finds out it needs to make them. >>> >>> -- >>> View this message in context: >>> http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708150.html >>> Sent from the syncope-user mailing list archive at Nabble.com. >> >> -- >> Dott. Marco Di Sabatino Di Diodoro >> Tel. +39 3939065570 >> >> Tirasa S.r.l. >> Viale D'Annunzio 267 - 65127 Pescara >> Tel +39 0859116307 / FAX +39 085973 >> http://www.tirasa.net >> >> Apache Syncope PMC Member >> http://people.apache.org/~mdisabatino/ >