I did a test with the user that connects to the databse. Find below the
things I did.
mysql> describe UserRequest;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| id | bigint(20) | NO | PRI | NULL | |
| payload | text | YES | | NULL | |
| type | varchar(20) | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> insert into UserRequest values (100, "test", "100");
Query OK, 1 row affected (0.08 sec)
mysql> commit
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from UserRequest;
+-----+---------+------+
| id | payload | type |
+-----+---------+------+
| 100 | test | 100 |
+-----+---------+------+
1 row in set (0.00 sec)
mysql> delete from UserRequest;
Query OK, 1 row affected (0.05 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql>
So it looks like it works fine with the user on the MySQL prompt.
Regards,
Ernst
2012/11/2 Francesco Chicchiriccò <[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/
>
>
