Hi aman, Once you create the database, you can source the existing sql script to create relevant tables inside this database as follows.
*use sampledatabase;* *source <EI_HOME>/dbscripts/mysql.sql; * (if you are using MySQL version 5.7 *source <EI_HOME>/dbscripts/mysql5.7.sql;*) Thanks On Wed, Nov 21, 2018 at 9:04 AM Aman Singh <[email protected]> wrote: > Dear Shakila, > > Hope you are doing well. > I am trying to setup MySQL in WSO2 so that I can use MySQL instead if H2 > database. The steps which I followed is below:- > 1) In "MySQL workbench" I created a database called "sampledatabase". Then > I granted permission to it using "GRANT ALL PRIVILEGES ON sampledatabase TO > username@localhost;". The I created a table in it, named "sampletable". > 2)By referring to doc , in my master-datasource.xml file I edited it as > below:- > <datasource> > <name>WSO2_CARBON_DB</name> > <description>The datasource used for registry and user > manager</description> > <jndiConfig> > <name>jdbc/WSO2CarbonDB</name> > </jndiConfig> > <definition type="RDBMS"> > <configuration> > <url>jdbc:mysql://localhost:3306/sampledatabase</url> > <username>username</username> > <password>password</password> > > <driverClassName>com.mysql.cj.jdbc.Driver</driverClassName> > <maxActive>50</maxActive> > <maxWait>60000</maxWait> > <testOnBorrow>true</testOnBorrow> > <validationQuery>SELECT 1</validationQuery> > <validationInterval>30000</validationInterval> > <defaultAutoCommit>false</defaultAutoCommit> > </configuration> > </definition> > </datasource> > > Now when ever I start my integrator.bat, I get error saying :- > > ERROR - DatabaseUtil Database Error - Table 'sampledatabase.um_dialect' > doesn't exist > java.sql.SQLSyntaxErrorException: Table 'sampledatabase.um_dialect' > doesn't exist > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) > at > com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) > at > com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:974) > at > com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1024) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) > at com.sun.proxy.$Proxy18.executeQuery(Unknown Source) > at > org.wso2.carbon.user.core.claim.dao.ClaimDAO.getDialectCount(ClaimDAO.java:162) > at > org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:448) > at > org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:124) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:264) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:102) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:115) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:68) > at > org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) > at java.security.AccessController.doPrivileged(Native Method) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) > at > org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) > at > org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390) > at > org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1176) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1) > at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > at > org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) > [2018-11-20 10:54:34,906] [] ERROR - Activator Cannot start User Manager > Core bundle > org.wso2.carbon.user.core.UserStoreException: Cannot initialize the realm. > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:274) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:102) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:115) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:68) > at > org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) > at java.security.AccessController.doPrivileged(Native Method) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) > at > org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) > at > org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390) > at > org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1176) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1) > at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > at > org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) > Caused by: org.wso2.carbon.user.core.UserStoreException: Database Error - > Table 'sampledatabase.um_dialect' doesn't exist > at > org.wso2.carbon.user.core.claim.dao.ClaimDAO.getDialectCount(ClaimDAO.java:168) > at > org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:448) > at > org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:124) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:264) > ... 19 more > Caused by: java.sql.SQLSyntaxErrorException: Table > 'sampledatabase.um_dialect' doesn't exist > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) > at > com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) > at > com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:974) > at > com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1024) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) > at com.sun.proxy.$Proxy18.executeQuery(Unknown Source) > at > org.wso2.carbon.user.core.claim.dao.ClaimDAO.getDialectCount(ClaimDAO.java:162) > ... 22 more > [2018-11-20 10:55:09,900] [] INFO - TaglibUriRule TLD skipped. URI: > http://tiles.apache.org/tags-tiles is already define > > Your help would be appreciated in resolving this. -) > > Thank you, > Aman. > -- Shakila Sasikaran Software Engineer Mobile :+94 (0) 77 526 6848 [email protected] WSO2, Inc. lean . enterprise . middleware http://www.wso2.com/
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
