Ernst,
this turned to be an actual bug affecting 1.0.2-incubating and even the
not-yet-released 1.0.3-incubating.
I've opened SYNCOPE-232 and fixed this in 1.0.4-incubating-SNAPSHOT.
As workaround:
1. download JobInstanceLoader.java ([1] for 1.0.2-incubating, [2] for
1.0.3-incubating)
2. put it under your overlay's
core/src/main/java/org/apache/syncope/core/init
3. replace
- @Transactional(readOnly = true)
+ @Transactional
public void load() {
This should solve the bug until 1.0.4-incubating is released.
Regards.
[1]
https://svn.apache.org/repos/asf/incubator/syncope/tags/syncope-1.0.2-incubating/core/src/main/java/org/apache/syncope/core/init/JobInstanceLoader.java
[2]
https://svn.apache.org/repos/asf/incubator/syncope/tags/syncope-1.0.3-incubating/core/src/main/java/org/apache/syncope/core/init/JobInstanceLoader.java
On 02/11/2012 14:04, ernst Developer wrote:
> Here's a clean set of log files.
>
>
> 2012/11/2 Francesco Chicchiriccò <[email protected]
> <mailto:[email protected]>>
>
> On 02/11/2012 13:54, ernst Developer wrote:
>> I did a test with the user that connects to the databse. Find
>> below the things I did.
>>
>> [...]
>>
>> So it looks like it works fine with the user on the MySQL prompt.
>
> Ok, could you please check in all Syncope and especially Tomcat
> log files if there is any initialization error?
>
> Regards.
>
>
>> 2012/11/2 Francesco Chicchiriccò <[email protected]
>> <mailto:[email protected]>>
>>
>> On 02/11/2012 13:41, ernst Developer wrote:
>> > Hi,
>> > Today I started using 1.0.2-incubating.
>> > I followed the steps in the
>> > wiki:
>>
>> https://cwiki.apache.org/confluence/display/SYNCOPE/Create+a+new+Syncope+project
>> >
>> > I installed tomcat: apache-tomcat-7.0.32.
>> >
>> > Then I did the changes suggested
>> > in:
>>
>> https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+real+environments#RunSyncopeinrealenvironments-MySQL
>> > Because we are using MySQL.
>> >
>> > I started with an empty database. I got the error:
>> >
>> > [...]
>> >
>> > Does somebody have any suggestions?
>>
>> This:
>>
>> > org.apache.ibatis.exceptions.PersistenceException: ###
>> Error updating
>> > database. Cause:
>> org.apache.openjpa.lib.jdbc.ReportingSQLException:
>> > Connection is read-only
>>
>> sounds very strange to me: can you please check that the
>> configured user
>> is allowed to write on the database or if the db is put in
>> read-only for
>> some weird reason?
>>
>> Regards.
>>
--
Francesco Chicchiriccò
ASF Member, Apache Cocoon PMC and Apache Syncope PPMC Member
http://people.apache.org/~ilgrosso/
