[prev in list] [next in list] [prev in thread] [next in thread]
List: wsas-java-dev
Subject: Re: [Dev] Error when setting up API Manager with MySQL
From: Júnior <fjunior87 () gmail ! com>
Date: 2017-06-28 12:53:43
Message-ID: CAOk1a-SgEOnMaphmc-BOUkcM79OwrOMkdxTYe3yfW78r-kNuYw () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi Thomas,
I have renamed the folder during the installation process and it worked.
Thanks,
2017-06-28 3:07 GMT-03:00 Thomas LEGRAND <thomas.legrand@versusmind.eu>:
> Hello,
>
> Have you tried to execute manually this SQL script on your DBMS and start
> the AM without the -Dsetup?
>
>
> Le mercredi 28 juin 2017, Júnior <fjunior87@gmail.com> a écrit :
>
>> Hi,
>>
>> I have setup the CarbonDB to use the MySQL, and changed the identity.xml
>> to use the Carbon db.
>>
>> But when we run the -Dsetup we receive this error:
>>
>>
>> [
>>
>> 2017-06-27 22:53:51,644] INFO - APIKeyMgtServiceComponent Started
>> thrift key mgt service at port:10398
>> [2017-06-27 22:53:51,799] ERROR - IdentityCoreServiceComponent Error
>> occurred while populating identity configuration properties
>> org.wso2.carbon.identity.base.IdentityRuntimeException:
>> java.io.FileNotFoundException: E:\soft\wso2am-2.1.0\bin\..\dbscripts\identity\mysql.sql
>> (The system cannot find the path specified)
>> at org.wso2.carbon.identity.base.IdentityRuntimeException.error
>> (IdentityRuntimeException.java:71)
>> at org.wso2.carbon.identity.core.persistence.IdentityDBInitiali
>> zer.executeSQLScript(IdentityDBInitializer.java:273)
>> at org.wso2.carbon.identity.core.persistence.IdentityDBInitiali
>> zer.createIdentityDatabase(IdentityDBInitializer.java:141)
>> at org.wso2.carbon.identity.core.persistence.JDBCPersistenceMan
>> ager.initializeDatabase(JDBCPersistenceManager.java:112)
>> at org.wso2.carbon.identity.core.internal.IdentityCoreServiceCo
>> mponent.activate(IdentityCoreServiceComponent.java:130)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
>> ssorImpl.java:62)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>> thodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:498)
>> at org.eclipse.equinox.internal.ds.model.ServiceComponent.activ
>> ate(ServiceComponent.java:260)
>> at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.a
>> ctivate(ServiceComponentProp.java:146)
>> at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.b
>> uild(ServiceComponentProp.java:345)
>> at org.eclipse.equinox.internal.ds.InstanceProcess.buildCompone
>> nt(InstanceProcess.java:620)
>> at org.eclipse.equinox.internal.ds.InstanceProcess.buildCompone
>> nts(InstanceProcess.java:197)
>> at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolve
>> r.java:343)
>> at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SC
>> RManager.java:222)
>> at org.eclipse.osgi.internal.serviceregistry.FilteredServiceLis
>> tener.serviceChanged(FilteredServiceListener.java:107)
>> at org.eclipse.osgi.framework.internal.core.BundleContextImpl.d
>> ispatchEvent(BundleContextImpl.java:861)
>> at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEve
>> nt(EventManager.java:230)
>> at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEv
>> entSynchronous(ListenerQueue.java:148)
>> at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.pu
>> blishServiceEventPrivileged(ServiceRegistry.java:819)
>> at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.pu
>> blishServiceEvent(ServiceRegistry.java:771)
>> at org.eclipse.osgi.internal.serviceregistry.ServiceRegistratio
>> nImpl.register(ServiceRegistrationImpl.java:130)
>> at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.re
>> gisterService(ServiceRegistry.java:214)
>> at org.eclipse.osgi.framework.internal.core.BundleContextImpl.r
>> egisterService(BundleContextImpl.java:433)
>> at org.eclipse.osgi.framework.internal.core.BundleContextImpl.r
>> egisterService(BundleContextImpl.java:451)
>> at org.wso2.carbon.core.init.CarbonServerManager.initializeCarb
>> on(CarbonServerManager.java:514)
>> at org.wso2.carbon.core.init.CarbonServerManager.removePendingI
>> tem(CarbonServerManager.java:290)
>> at org.wso2.carbon.core.init.PreAxis2ConfigItemListener.bundleC
>> hanged(PreAxis2ConfigItemListener.java:118)
>> at org.eclipse.osgi.framework.internal.core.BundleContextImpl.d
>> ispatchEvent(BundleContextImpl.java:847)
>> at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEve
>> nt(EventManager.java:230)
>> at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread
>> .run(EventManager.java:340)
>> *Caused by: java.io.FileNotFoundException:
>> E:\soft\wso2am-2.1.0\bin\..\dbscripts\identity\mysql.sql (The system cannot
>> find the path specified)*
>> at java.io.FileInputStream.open0(Native Method)
>> at java.io.FileInputStream.open(FileInputStream.java:195)
>> at java.io.FileInputStream.<init>(FileInputStream.java:138)
>> at java.io.FileInputStream.<init>(FileInputStream.java:93)
>> at org.wso2.carbon.identity.core.persistence.IdentityDBInitiali
>> zer.executeSQLScript(IdentityDBInitializer.java:235)
>> ... 30 more
>>
>> Is this expected? Any workaround?
>>
>> Thanks,
>>
>> --
>> Francisco Ribeiro
>> *SCEA|SCJP|SCWCD|IBM Certified SOA Associate*
>>
>
--
Francisco Ribeiro
*SCEA|SCJP|SCWCD|IBM Certified SOA Associate*
[Attachment #5 (text/html)]
<div dir="ltr">Hi Thomas,<div><br></div><div>I have renamed the folder during the \
installation process and it worked.</div><div><br></div><div>Thanks,</div></div><div \
class="gmail_extra"><br><div class="gmail_quote">2017-06-28 3:07 GMT-03:00 Thomas \
LEGRAND <span dir="ltr"><<a href="mailto:thomas.legrand@versusmind.eu" \
target="_blank">thomas.legrand@versusmind.eu</a>></span>:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">Hello,<div><br></div><div>Have you tried to execute manually \
this SQL script on your DBMS and start the AM without the -Dsetup?<div><div \
class="h5"><br><br>Le mercredi 28 juin 2017, Júnior <<a \
href="mailto:fjunior87@gmail.com" target="_blank">fjunior87@gmail.com</a>> a \
écrit :<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"><div dir="ltr">Hi,<div><br></div><div>I have setup the \
CarbonDB to use the MySQL, and changed the identity.xml to use the Carbon \
db.</div><div><br></div><div>But when we run the -Dsetup we receive this \
error:</div><div><br></div><div><br clear="all"><div><div>[</div><br><div><div \
style="display:block;overflow-x:auto;padding:0.5em;color:rgb(51,51,51);background:rgb(248,248,248);font-family:monospace"><div><span \
style="color:rgb(136,0,0)">2017</span><span \
style="color:rgb(136,0,0)">-06</span><span style="color:rgb(136,0,0)">-27</span> \
<span style="color:rgb(136,0,0)">22</span>:<span \
style="color:rgb(136,0,0)">53</span>:<span style="color:rgb(136,0,0)">51</span>,<span \
style="color:rgb(136,0,0)">644</span>] INFO - APIKeyMgtServiceComponent Started \
thrift key mgt service at port:<span \
style="color:rgb(136,0,0)">10398</span></div><div>[<span \
style="color:rgb(136,0,0)">2017</span><span \
style="color:rgb(136,0,0)">-06</span><span style="color:rgb(136,0,0)">-27</span> \
<span style="color:rgb(136,0,0)">22</span>:<span \
style="color:rgb(136,0,0)">53</span>:<span style="color:rgb(136,0,0)">51</span>,<span \
style="color:rgb(136,0,0)">799</span>] ERROR - IdentityCoreServiceComponent Error \
occurred <span style="font-weight:bold">while</span> populating identity \
configuration properties</div><div>org.wso2.carbon.identity.<span \
style="font-weight:bold">base</span>.<wbr>IdentityRuntimeException: \
java.io.FileNotFoundException: E:\soft\wso2am<span \
style="color:rgb(136,0,0)">-2.1</span><span \
style="color:rgb(136,0,0)">.0</span>\bin\..\db<wbr>scripts\identity\mysql.sql (The \
system cannot find the path specified)</div><div> at \
org.wso2.carbon.identity.<span \
style="font-weight:bold">base</span>.<wbr>IdentityRuntimeException.error<wbr>(IdentityRuntimeException.<wbr>java:<span \
style="color:rgb(136,0,0)">71</span>)</div><div> at \
org.wso2.carbon.identity.core.<wbr>persistence.IdentityDBInitiali<wbr>zer.executeSQLScript(IdentityD<wbr>BInitializer.java:<span \
style="color:rgb(136,0,0)">273</span>)</div><div> at \
org.wso2.carbon.identity.core.<wbr>persistence.IdentityDBInitiali<wbr>zer.createIdentityDatabase(Ide<wbr>ntityDBInitializer.java:<span \
style="color:rgb(136,0,0)">141</span>)</div><div> at \
org.wso2.carbon.identity.core.<wbr>persistence.JDBCPersistenceMan<wbr>ager.initializeDatabase(JDBCPe<wbr>rsistenceManager.java:<span \
style="color:rgb(136,0,0)">112</span>)</div><div> at \
org.wso2.carbon.identity.core.<span \
style="font-weight:bold"><wbr>internal</span>.IdentityCoreServiceCo<wbr>mponent.activate(IdentityCoreS<wbr>erviceComponent.java:<span \
style="color:rgb(136,0,0)">130</span>)</div><div> at \
sun.reflect.NativeMethodAccess<wbr>orImpl.invoke0(Native Method)</div><div> \
at sun.reflect.NativeMethodAccess<wbr>orImpl.invoke(NativeMethodAcce<wbr>ssorImpl.java:<span \
style="color:rgb(136,0,0)">62</span>)</div><div> at \
sun.reflect.DelegatingMethodAc<wbr>cessorImpl.invoke(DelegatingMe<wbr>thodAccessorImpl.java:<span \
style="color:rgb(136,0,0)">43</span>)</div><div> at \
java.lang.reflect.Method.invok<wbr>e(Method.java:<span \
style="color:rgb(136,0,0)">498</span>)</div><div> at \
org.eclipse.equinox.<span \
style="font-weight:bold">internal</span>.d<wbr>s.model.ServiceComponent.activ<wbr>ate(ServiceComponent.java:<span \
style="color:rgb(136,0,0)">260</span>)</div><div> at \
org.eclipse.equinox.<span \
style="font-weight:bold">internal</span>.d<wbr>s.model.ServiceComponentProp.a<wbr>ctivate(ServiceComponentProp.j<wbr>ava:<span \
style="color:rgb(136,0,0)">146</span>)</div><div> at \
org.eclipse.equinox.<span \
style="font-weight:bold">internal</span>.d<wbr>s.model.ServiceComponentProp.b<wbr>uild(ServiceComponentProp.java<wbr>:<span \
style="color:rgb(136,0,0)">345</span>)</div><div> at \
org.eclipse.equinox.<span \
style="font-weight:bold">internal</span>.d<wbr>s.InstanceProcess.buildCompone<wbr>nt(InstanceProcess.java:<span \
style="color:rgb(136,0,0)">620</span>)</div><div> at \
org.eclipse.equinox.<span \
style="font-weight:bold">internal</span>.d<wbr>s.InstanceProcess.buildCompone<wbr>nts(InstanceProcess.java:<span \
style="color:rgb(136,0,0)">197</span>)</div><div> at \
org.eclipse.equinox.<span \
style="font-weight:bold">internal</span>.d<wbr>s.Resolver.getEligible(Resolve<wbr>r.java:<span \
style="color:rgb(136,0,0)">343</span>)</div><div> at \
org.eclipse.equinox.<span \
style="font-weight:bold">internal</span>.d<wbr>s.SCRManager.serviceChanged(SC<wbr>RManager.java:<span \
style="color:rgb(136,0,0)">222</span>)</div><div> at \
org.eclipse.osgi.<span \
style="font-weight:bold">internal</span>.serv<wbr>iceregistry.FilteredServiceLis<wbr>tener.serviceChanged(FilteredS<wbr>erviceListener.java:<span \
style="color:rgb(136,0,0)">107</span>)</div><div> at \
org.eclipse.osgi.framework.<span \
style="font-weight:bold">int<wbr>ernal</span>.core.BundleContextImpl.d<wbr>ispatchEvent(BundleContextImpl<wbr>.java:<span \
style="color:rgb(136,0,0)">861</span>)</div><div> at \
org.eclipse.osgi.framework.eve<wbr>ntmgr.EventManager.dispatchEve<wbr>nt(EventManager.java:<span \
style="color:rgb(136,0,0)">230</span>)</div><div> at \
org.eclipse.osgi.framework.eve<wbr>ntmgr.ListenerQueue.dispatchEv<wbr>entSynchronous(ListenerQueue.<wbr>java:<span \
style="color:rgb(136,0,0)">148</span>)</div><div> at \
org.eclipse.osgi.<span \
style="font-weight:bold">internal</span>.serv<wbr>iceregistry.ServiceRegistry.pu<wbr>blishServiceEventPrivileged(Se<wbr>rviceRegistry.java:<span \
style="color:rgb(136,0,0)">819</span>)</div><div> at \
org.eclipse.osgi.<span \
style="font-weight:bold">internal</span>.serv<wbr>iceregistry.ServiceRegistry.pu<wbr>blishServiceEvent(ServiceRegis<wbr>try.java:<span \
style="color:rgb(136,0,0)">771</span>)</div><div> at \
org.eclipse.osgi.<span \
style="font-weight:bold">internal</span>.serv<wbr>iceregistry.ServiceRegistratio<wbr>nImpl.register(ServiceRegistra<wbr>tionImpl.java:<span \
style="color:rgb(136,0,0)">130</span>)</div><div> at \
org.eclipse.osgi.<span style="font-weight:bold">internal</span>.serv<wbr><a \
href="http://iceregistry.ServiceRegistry.re">iceregistry.ServiceRegistry.re</a><wbr>gisterService(ServiceRegistry.<wbr>java:<span \
style="color:rgb(136,0,0)">214</span>)</div><div> at \
org.eclipse.osgi.framework.<span \
style="font-weight:bold">int<wbr>ernal</span>.core.BundleContextImpl.r<wbr>egisterService(BundleContextIm<wbr>pl.java:<span \
style="color:rgb(136,0,0)">433</span>)</div><div> at \
org.eclipse.osgi.framework.<span \
style="font-weight:bold">int<wbr>ernal</span>.core.BundleContextImpl.r<wbr>egisterService(BundleContextIm<wbr>pl.java:<span \
style="color:rgb(136,0,0)">451</span>)</div><div> at \
org.wso2.carbon.core.init.Carb<wbr>onServerManager.initializeCarb<wbr>on(CarbonServerManager.java:<span \
style="color:rgb(136,0,0)">51<wbr>4</span>)</div><div> at \
org.wso2.carbon.core.init.Carb<wbr>onServerManager.removePendingI<wbr>tem(CarbonServerManager.java:<span \
style="color:rgb(136,0,0)">2<wbr>90</span>)</div><div> at \
org.wso2.carbon.core.init.PreA<wbr>xis2ConfigItemListener.bundleC<wbr>hanged(PreAxis2ConfigItemListe<wbr>ner.java:<span \
style="color:rgb(136,0,0)">118</span>)</div><div> at \
org.eclipse.osgi.framework.<span \
style="font-weight:bold">int<wbr>ernal</span>.core.BundleContextImpl.d<wbr>ispatchEvent(BundleContextImpl<wbr>.java:<span \
style="color:rgb(136,0,0)">847</span>)</div><div> at \
org.eclipse.osgi.framework.eve<wbr>ntmgr.EventManager.dispatchEve<wbr>nt(EventManager.java:<span \
style="color:rgb(136,0,0)">230</span>)</div><div> at \
org.eclipse.osgi.framework.eve<wbr>ntmgr.EventManager$EventThread<wbr>.run(EventManager.java:<span \
style="color:rgb(136,0,0)">340</span>)</div><div><b>Caused by: \
java.io.FileNotFoundException: E:\soft\wso2am<span \
style="color:rgb(136,0,0)">-2.1</span><span \
style="color:rgb(136,0,0)">.0</span>\bin\..\db<wbr>scripts\identity\mysql.sql (The \
system cannot find the path specified)</b></div><div> at \
java.io.FileInputStream.open0(<wbr>Native Method)</div><div> at \
java.io.FileInputStream.open(F<wbr>ileInputStream.java:<span \
style="color:rgb(136,0,0)">195</span>)</div><div> at \
java.io.FileInputStream.<init><wbr>(FileInputStream.java:<span \
style="color:rgb(136,0,0)">138</span>)</div><div> at \
java.io.FileInputStream.<init><wbr>(FileInputStream.java:<span \
style="color:rgb(136,0,0)">93</span>)</div><div> at \
org.wso2.carbon.identity.core.<wbr>persistence.IdentityDBInitiali<wbr>zer.executeSQLScript(IdentityD<wbr>BInitializer.java:<span \
style="color:rgb(136,0,0)">235</span>)</div><div> ... <span \
style="color:rgb(136,0,0)">30</span> \
more</div></div></div><br><div></div></div><div>Is this expected? Any \
workaround?</div><div><br></div><div>Thanks,</div><div><br></div>-- \
<br><div>Francisco Ribeiro<br><b><span \
style="color:rgb(153,153,153)">SCEA|SCJP|SCWCD|IBM Certified SOA \
Associate</span></b></div> </div></div>
</blockquote></div></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div \
class="gmail_signature" data-smartmail="gmail_signature">Francisco \
Ribeiro<br><b><span style="color:rgb(153,153,153)">SCEA|SCJP|SCWCD|IBM Certified SOA \
Associate</span></b></div> </div>
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic