Hello,
i've found about the error :
http://www.ispirer.com/wiki/sqlways/troubleshooting-guide/mysql/import/binlog_mode_statement
is necessarry to change the binlog:
mysql> SET GLOBAL binlog_format = 'ROW';
Now i got this changed and i dont get the error, but while starting the WSO2
GS it keeps freezing at starting registry:
[2010-07-28 07:49:26,787] INFO - Initializing system...
{org.wso2.carbon.server.Main}
[2010-07-28 07:49:33,163] INFO - Starting WSO2 Carbon...
{org.wso2.carbon.core.internal.CarbonCoreActivator}
[2010-07-28 07:49:33,164] INFO - Operating System : Linux 2.6.32-305-ec2,
i386 {org.wso2.carbon.core.internal.CarbonCoreActivator}
[2010-07-28 07:49:33,164] INFO - Java Home : /usr/java/jre1.6.0_20
{org.wso2.carbon.core.internal.CarbonCoreActivator}
[2010-07-28 07:49:33,164] INFO - Java Version : 1.6.0_20
{org.wso2.carbon.core.internal.CarbonCoreActivator}
[2010-07-28 07:49:33,165] INFO - Java VM : Java HotSpot(TM)
Server VM 16.3-b01,Sun Microsystems Inc.
{org.wso2.carbon.core.internal.CarbonCoreActivator}
[2010-07-28 07:49:33,165] INFO - Carbon Home : /opt/wso2gs-1.1.0/.
{org.wso2.carbon.core.internal.CarbonCoreActivator}
[2010-07-28 07:49:33,165] INFO - Java Temp Dir : tmp
{org.wso2.carbon.core.internal.CarbonCoreActivator}
[2010-07-28 07:49:33,165] INFO - User : root, en-GB, Etc/UTC
{org.wso2.carbon.core.internal.CarbonCoreActivator}
Same as if i make a wso2server.sh -Dsetup...
this is my registry config:
<currentDBConfig>mysql-db</currentDBConfig>
<readOnly>false</readOnly>
<registryRoot>/</registryRoot>
<dbConfig name="mysql-db">
<url>jdbc:mysql://xxxxxxx/regdbGS</url>
<userName>regadmin</userName>
<password>xxxxxx</password>
<driverName>com.mysql.jdbc.Driver</driverName>
<maxActive>50</maxActive>
<maxWait>60000</maxWait>
<minIdle>5</minIdle>
</dbConfig>
Any other idea?
Thanks!
On Tue, Jul 27, 2010 at 10:00 PM, Sumedha Rubasinghe <sume...@wso2.com>wrote:
> Is it possible to check this on a previous version of MySQL?
> eg: v 5.1.28
>
> /sumedha
>
>
>
> 2010/7/27 Víctor Álvarez <spa...@gmail.com>
>
>> is plain new installation over ubuntu:
>>
>> server version: 5.1.41-3ubuntu12.3-log
>>
>> Thanks. need some help, im really stucked at this.
>>
>> it only happends if i set the msyql on the registry.xml, no problem to set
>> it up on the user-mgt.xml
>>
>> is necessary to configure it on both isn't it?
>>
>> Thanks
>>
>> On Tue, Jul 27, 2010 at 4:56 PM, Dimuthu Gamage <dimu...@wso2.com> wrote:
>>
>>> Hi,
>>>
>>> Did you do a myserver upgrade recently?. Just checking,
>>> http://bugs.mysql.com/bug.php?id=40360
>>>
>>> Dimuthu
>>>
>>> 2010/7/27 Víctor Álvarez <spa...@gmail.com>:
>>> > this is the registry configuration i use:
>>> > <dbConfig name="mysql-db">
>>> > <url>jdbc:mysql://xxx.xxx.xxx.xxx/regdbGS</url>
>>> > <userName>regadmin</userName>
>>> > <password>xxxxxxxxxx</password>
>>> > <driverName>com.mysql.jdbc.Driver</driverName>
>>> > <maxActive>50</maxActive>
>>> > <maxWait>60000</maxWait>
>>> > <minIdle>5</minIdle>
>>> > </dbConfig>
>>> > Thanks
>>> > ---------- Forwarded message ----------
>>> > From: Víctor Álvarez <spa...@gmail.com>
>>> > Date: 2010/7/27
>>> > Subject: error with mysql db in registry.xml
>>> > To: carbon-dev@wso2.org
>>> >
>>> >
>>> > Hello,
>>> > i'm trying to setup a MySQL on registry for Gadget Server and i get
>>> this
>>> > when i try to start the server with the -Dsetup
>>> > vator}
>>> > [2010-07-27 14:35:22,594] INFO - Carbon Home : /opt/wso2gs-1.1.0
>>> > {org.wso2.carbon.core.internal.CarbonCoreActivator}
>>> > [2010-07-27 14:35:22,594] INFO - Java Temp Dir :
>>> /opt/wso2gs-1.1.0/tmp
>>> > {org.wso2.carbon.core.internal.CarbonCoreActivator}
>>> > [2010-07-27 14:35:22,594] INFO - User : root, en-GB,
>>> Etc/UTC
>>> > {org.wso2.carbon.core.internal.CarbonCoreActivator}
>>> > [2010-07-27 14:35:40,258] ERROR - Failed to insert resource to /.
>>> Binary
>>> > logging not possible. Message: Transaction level 'READ-COMMITTED' in
>>> InnoDB
>>> > is not
>>> > safe for binlog mode 'STATEMENT'
>>> > {org.wso2.carbon.registry.core.jdbc.dao.ResourceDAO}
>>> > java.sql.SQLException: Binary logging not possible. Message:
>>> Transaction
>>> > level 'READ-COMMITTED' in InnoDB is not safe for binlog mode
>>> 'STATEMENT'
>>> > at
>>> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
>>> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
>>> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
>>> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
>>> > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
>>> > at
>>> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
>>> > at
>>> >
>>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
>>> > at
>>> >
>>> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2409)
>>> > at
>>> >
>>> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2327)
>>> > at
>>> >
>>> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2312)
>>> > at
>>> >
>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
>>> > at
>>> >
>>> org.wso2.carbon.registry.core.jdbc.dao.PathCache.addEntry(PathCache.java:133)
>>> > at
>>> >
>>> org.wso2.carbon.registry.core.jdbc.dao.ResourceDAO.createResourceID(ResourceDAO.java:628)
>>> > at
>>> >
>>> org.wso2.carbon.registry.core.jdbc.dao.ResourceDAO.createAndApplyResourceID(ResourceDAO.java:594)
>>> > at
>>> >
>>> org.wso2.carbon.registry.core.jdbc.dao.ResourceDAO.addRoot(ResourceDAO.java:550)
>>> > at
>>> >
>>> org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:307)
>>> >
>>> > If i try to start the service it keeps freezing there:
>>> > [2010-07-27 14:37:53,476] INFO - Java VM : Java HotSpot(TM)
>>> > Server VM 16.3-b01,Sun Microsystems Inc.
>>> > {org.wso2.carbon.core.internal.CarbonCoreActivator}
>>> > [2010-07-27 14:37:53,476] INFO - Carbon Home :
>>> /opt/wso2gs-1.1.0/.
>>> > {org.wso2.carbon.core.internal.CarbonCoreActivator}
>>> > [2010-07-27 14:37:53,476] INFO - Java Temp Dir : tmp
>>> > {org.wso2.carbon.core.internal.CarbonCoreActivator}
>>> > [2010-07-27 14:37:53,476] INFO - User : root, en-GB,
>>> Etc/UTC
>>> > {org.wso2.carbon.core.internal.CarbonCoreActivator}
>>> >
>>> > also i got this mysql configured properly on the user-mgt.xml file.
>>> >
>>> > Any help please?
>>> > --
>>> > Víctor Álvarez
>>> > Incoming IT www.incomingIT.com
>>> > www.twitter.com/incomingIT
>>> > Escribiendo en y sobre Accesibilidad Web:
>>> http://accesibilidad.blogspot.com
>>> >
>>> >
>>> >
>>> >
>>> >
>>> > --
>>> > Víctor Álvarez
>>> > Incoming IT www.incomingIT.com
>>> > www.twitter.com/incomingIT
>>> > Escribiendo en y sobre Accesibilidad Web:
>>> http://accesibilidad.blogspot.com
>>> >
>>> >
>>> >
>>> > _______________________________________________
>>> > Carbon-dev mailing list
>>> > Carbon-dev@wso2.org
>>> > https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>>> >
>>> >
>>>
>>> _______________________________________________
>>> Carbon-dev mailing list
>>> Carbon-dev@wso2.org
>>> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>>>
>>
>>
>>
>> --
>> Víctor Álvarez
>> Incoming IT www.incomingIT.com
>> www.twitter.com/incomingIT
>> Escribiendo en y sobre Accesibilidad Web:
>> http://accesibilidad.blogspot.com
>>
>>
>>
>> _______________________________________________
>> Carbon-dev mailing list
>> Carbon-dev@wso2.org
>> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>>
>>
>
> _______________________________________________
> Carbon-dev mailing list
> Carbon-dev@wso2.org
> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>
>
--
Víctor Álvarez
Incoming IT www.incomingIT.com
www.twitter.com/incomingIT
Escribiendo en y sobre Accesibilidad Web: http://accesibilidad.blogspot.com
_______________________________________________
Carbon-dev mailing list
Carbon-dev@wso2.org
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
