Hi, It might be a problem. Then it create the database as "USERSTORE_DB_SCHEMA". Isn't it ?
On Wed, Sep 17, 2014 at 3:10 PM, Thushara Ranawaka <thusha...@wso2.com> wrote: > Hi, > > Issue was the database name. > I did the following changes in the setup.conf and now clean.sh is working > properly. > > # export userstore_db_schema="userstore" > export userstore_db_schema="USERSTORE_DB_SCHEMA" # for mac osx > > Is there any issue or conflict in above setup? > > Thanks, > Thushara > > On Wed, Sep 17, 2014 at 2:50 PM, Thushara Ranawaka <thusha...@wso2.com> > wrote: > >> Hi Manula, >> >> FYI >> >> In mac when we run mysql -u $mysql_user -p$mysql_pass -e "DROP DATABASE >> IF EXISTS $userstore_db_schema;" it works without any issue. we will >> debug the shell script and let you know. >> >> mysql> show databases; >> >> +---------------------+ >> >> | Database | >> >> +---------------------+ >> >> | information_schema | >> >> | USERSTORE_DB_SCHEMA | >> >> | mysql | >> >> | performance_schema | >> >> | test | >> >> +---------------------+ >> >> 5 rows in set (0.00 sec) >> >> >> mysql> exit >> >> Bye >> >> Thusharas-MacBook-Pro:~ thushara$ mysql -u root -ppassword -e "DROP >> DATABASE IF EXISTS USERSTORE_DB_SCHEMA;" >> >> Warning: Using a password on the command line interface can be insecure. >> >> Thusharas-MacBook-Pro:~ thushara$ mysql >> >> Welcome to the MySQL monitor. Commands end with ; or \g. >> >> Your MySQL connection id is 28 >> >> Server version: 5.6.20 MySQL Community Server (GPL) >> >> >> Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights >> reserved. >> >> >> Oracle is a registered trademark of Oracle Corporation and/or its >> >> affiliates. Other names may be trademarks of their respective >> >> owners. >> >> >> Type 'help;' or '\h' for help. Type '\c' to clear the current input >> statement. >> >> >> mysql> show databases; >> >> +--------------------+ >> >> | Database | >> >> +--------------------+ >> >> | information_schema | >> >> | mysql | >> >> | performance_schema | >> >> | test | >> >> +--------------------+ >> >> 4 rows in set (0.00 sec) >> >> >> >> On Wed, Sep 17, 2014 at 2:41 PM, Manula Chathurika Thantriwatte < >> manu...@wso2.com> wrote: >> >>> Hi Suhan, >>> >>> Can you please debug and see the username and the password is actually >>> there in the database cleanup function. You can simply use echo statement >>> inside the drop database function and verify that. clean.sh script work >>> perfectly in ubuntu. I'm not sure is there any impact on MAC. >>> >>> Thanks ! >>> >>> >>> On Wed, Sep 17, 2014 at 2:29 PM, Suhan Dharmasuriya <suh...@wso2.com> >>> wrote: >>> >>>> Hi Manula, >>>> >>>> Nirmal, Thushara and I did try running clean.sh script but had no luck. >>>> Sample output is as follows. >>>> Note that mysql root password is 'pass'. >>>> Suhans-MacBook-Pro:stratos-installer suhanr$ sudo ./clean.sh -u root -p >>>> pass >>>> Please confirm that you want to remove stratos databases, servers and >>>> logs [y/n] y >>>> Stopping all java processes >>>> No matching processes were found >>>> Waiting for applications to exit >>>> Removing userstore database >>>> Warning: Using a password on the command line interface can be insecure. >>>> Removing Stratos >>>> Removing logs >>>> Suhans-MacBook-Pro:stratos-installer suhanr$ >>>> >>>> According to the mysql server output the database is still there. >>>> mysql> show databases; >>>> +---------------------+ >>>> | Database | >>>> +---------------------+ >>>> | information_schema | >>>> | USERSTORE_DB_SCHEMA | >>>> | mysql | >>>> | performance_schema | >>>> | test | >>>> +---------------------+ >>>> 5 rows in set (0.00 sec) >>>> >>>> mysql> show databases; >>>> +---------------------+ >>>> | Database | >>>> +---------------------+ >>>> | information_schema | >>>> | USERSTORE_DB_SCHEMA | >>>> | mysql | >>>> | performance_schema | >>>> | test | >>>> +---------------------+ >>>> 5 rows in set (0.00 sec) >>>> >>>> Thanks, >>>> Suhan >>>> >>>> On Wed, Sep 17, 2014 at 1:38 PM, Prasanna Dangalla <prasa...@wso2.com> >>>> wrote: >>>> >>>>> HI, >>>>> >>>>> The sed issue came to me also. I modifed the scripts and changed all >>>>> sed to gsed. >>>>> >>>>> >>>>> On Wed, Sep 17, 2014 at 12:52 PM, Manula Chathurika Thantriwatte < >>>>> manu...@wso2.com> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> The $subject error occurs because in the first time the script fails, >>>>>> and at that time it already create the database. Since you didn't run the >>>>>> clean.sh databases are already in the environment. After you run the >>>>>> setup.sh in second time you will get the $subject error. >>>>>> >>>>>> Thanks ! >>>>>> >>>>>> >>>>>> On Wed, Sep 17, 2014 at 12:46 PM, Thushara Ranawaka < >>>>>> thusha...@wso2.com> wrote: >>>>>> >>>>>>> Hi Udara, >>>>>>> Yes, We will do the needful. >>>>>>> >>>>>>> Thanks, >>>>>>> Thushara. >>>>>>> >>>>>>> On Wed, Sep 17, 2014 at 12:43 PM, Udara Liyanage <ud...@wso2.com> >>>>>>> wrote: >>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Wed, Sep 17, 2014 at 12:16 PM, Suhan Dharmasuriya < >>>>>>>> suh...@wso2.com> wrote: >>>>>>>> >>>>>>>>> Thanks Lasindu, >>>>>>>>> >>>>>>>>> Thushara and I are in the process of modifying the shell scripts >>>>>>>>> suitable for osx. >>>>>>>>> We contacted Nirmal, Lakmal, Waruna and Udara and had a quick >>>>>>>>> discussion. >>>>>>>>> >>>>>>>>> After the discussion, the solution we found was to delete the >>>>>>>>> USERSTORE_DB_SCHEMA database from mysql manually. >>>>>>>>> >>>>>>>>> As mentioned earlier, once $ sudo ./setup.sh -p "default" -s command >>>>>>>>> is run we get the following error. >>>>>>>>> <outputEventAdaptor name="JMSOutputAdaptor" statistics="disable" >>>>>>>>> trace="enable" type="jms" xmlns=" >>>>>>>>> http://wso2.org/carbon/eventadaptormanager"> >>>>>>>>> <!--property >>>>>>>>> name="java.naming.provider.url">CEP_HOME/repository/conf/jndi.properties</property--> >>>>>>>>> <property name="java.naming.provider.url">tcp:// >>>>>>>>> 10.100.5.175:61616</property> >>>>>>>>> <property >>>>>>>>> name="java.naming.factory.initial">org.apache.activemq.jndi.ActiveMQInitialContextFactory</property> >>>>>>>>> <property >>>>>>>>> name="transport.jms.ConnectionFactoryJNDIName">TopicConnectionFactory</property> >>>>>>>>> <property name="transport.jms.DestinationType">topic</property> >>>>>>>>> </outputEventAdaptor> >>>>>>>>> End configuring the Complex Event Processor >>>>>>>>> /WSO2/Products/stratos/opt/stratos-installer >>>>>>>>> Changing owner of /WSO2/Products/stratos/opt/stratos to >>>>>>>>> suhanr:suhanr >>>>>>>>> chown: suhanr: illegal group name >>>>>>>>> >>>>>>>>> What it tries to do is changing the ownership of installer to user >>>>>>>> suhanr that he can start Stratos. I guess the user group "suhanr" is >>>>>>>> not >>>>>>>> present in your environment. Please check with the command "groups". >>>>>>>> >>>>>>>> *After the second attempt we were getting the said error. $subject.* >>>>>>>>> >>>>>>>>> As a temporary solution we deleted the said database from mysql. >>>>>>>>> mysql> show databases; >>>>>>>>> +---------------------+ >>>>>>>>> | Database | >>>>>>>>> +---------------------+ >>>>>>>>> | information_schema | >>>>>>>>> | *USERSTORE_DB_SCHEMA* | >>>>>>>>> | mysql | >>>>>>>>> | performance_schema | >>>>>>>>> | test | >>>>>>>>> +---------------------+ >>>>>>>>> 5 rows in set (0.00 sec) >>>>>>>>> >>>>>>>>> mysql> drop database *USERSTORE_DB_SCHEMA*; >>>>>>>>> Query OK, 39 rows affected (0.05 sec) >>>>>>>>> >>>>>>>>> mysql> show databases; >>>>>>>>> +--------------------+ >>>>>>>>> | Database | >>>>>>>>> +--------------------+ >>>>>>>>> | information_schema | >>>>>>>>> | mysql | >>>>>>>>> | performance_schema | >>>>>>>>> | test | >>>>>>>>> +--------------------+ >>>>>>>>> 4 rows in set (0.00 sec) >>>>>>>>> >>>>>>>>> Then we were able to avoid the mentioned error in $subject. >>>>>>>>> >>>>>>>>> Thanks, >>>>>>>>> Suhan >>>>>>>>> >>>>>>>>> On Wed, Sep 17, 2014 at 11:21 AM, Lasindu Charith < >>>>>>>>> lasi...@wso2.com> wrote: >>>>>>>>> >>>>>>>>>> Hi Thushara and Suhan, >>>>>>>>>> >>>>>>>>>> Better if you can discuss the issues related to Apaches Stratos >>>>>>>>>> in stratos-dev list ( >>>>>>>>>> http://stratos.apache.org/community/mailing-lists.html) >>>>>>>>>> But for now, regarding the issues you have when setting up >>>>>>>>>> Stratos in osx, Nirmal, Reka or Prasanna might be able to help >>>>>>>>>> (Added). >>>>>>>>>> >>>>>>>>>> Thanks, >>>>>>>>>> >>>>>>>>>> On Tue, Sep 16, 2014 at 3:57 PM, Suhan Dharmasuriya < >>>>>>>>>> suh...@wso2.com> wrote: >>>>>>>>>> >>>>>>>>>>> We have installed mysql for OSX 10.9 [1] >>>>>>>>>>> >>>>>>>>>>> [1] http://www.macminivault.com/mysql-mavericks/ >>>>>>>>>>> >>>>>>>>>>> On Tue, Sep 16, 2014 at 3:55 PM, Suhan Dharmasuriya < >>>>>>>>>>> suh...@wso2.com> wrote: >>>>>>>>>>> >>>>>>>>>>>> Hi, >>>>>>>>>>>> >>>>>>>>>>>> Myself and Thushara were following the tutorial [1] installing >>>>>>>>>>>> apache Stratos and came to the following section. >>>>>>>>>>>> >>>>>>>>>>>> - Run the stratos-setup.sh file as the root. >>>>>>>>>>>> >>>>>>>>>>>> $ sudo ./setup.sh -p "default" >>>>>>>>>>>> >>>>>>>>>>>> After running the command we got the following error in our mac >>>>>>>>>>>> book pros. >>>>>>>>>>>> Detail terminal output is attached in the mail for reference. >>>>>>>>>>>> >>>>>>>>>>>> /WSO2/Products/stratos/opt/stratos-installer >>>>>>>>>>>> Warning: Using a password on the command line interface can be >>>>>>>>>>>> insecure. >>>>>>>>>>>> *ERROR 1061 (42000) at line 57: Duplicate key name >>>>>>>>>>>> 'REG_PATH_IND_BY_PATH_VALUE'* >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>> This issue occurs when you try to install Stratos for the second >>>>>>>> time since database values are already there. Ideally clean.sh should >>>>>>>> delete the database. If databases are not cleaned correctly by >>>>>>>> clean.sh it >>>>>>>> is a bug. Please create a jira and report it. Before that try >>>>>>>> following and >>>>>>>> check whether databases are deleted >>>>>>>> >>>>>>>> ./clean.sh -u<db_username> -p<db_pass> or >>>>>>>> ./clean.sh -u <db_username> -p <db_pass> . >>>>>>>> (Please mind the space in second option) >>>>>>>> >>>>>>>> Installer scripts are not tested very much in MAC environment as >>>>>>>> per my knowledge. It is highly appreciated if you can add your finding >>>>>>>> (installer scripts for MAC) to Stratos. It will be helpful for future >>>>>>>> MAC >>>>>>>> users. >>>>>>>> >>>>>>>>> >>>>>>>>>>>> We also followed the apache stratos wiki [3]. >>>>>>>>>>>> Please provide a direction to proceed from here. >>>>>>>>>>>> >>>>>>>>>>>> *Note*: *earlier setup.sh file gave an error saying,* >>>>>>>>>>>> sed: illegal option --r >>>>>>>>>>>> *Then the shell script was changed accordingly[2].* >>>>>>>>>>>> *Please note that we are using Mac OSX 10.9.4* >>>>>>>>>>>> >>>>>>>>>>>> *Then again an error appeared stating -i switch is not >>>>>>>>>>>> supported.* >>>>>>>>>>>> >>>>>>>>>>>> *Therefore the following shell script files were modified >>>>>>>>>>>> removing -i switch.* >>>>>>>>>>>> *ec2.sh* >>>>>>>>>>>> *openstack.sh* >>>>>>>>>>>> *setup.sh* >>>>>>>>>>>> *setup.conf* >>>>>>>>>>>> >>>>>>>>>>>> sed -i <pattern> <file> will modify the original file which you >>>>>>>> can achieve the same as below without -i option >>>>>>>> sed <pattern> <file> > <file> >>>>>>>> >>>>>>>> >>>>>>>> *Scripts are attached for reference. * >>>>>>>>>>>> >>>>>>>>>>>> [1] >>>>>>>>>>>> http://blog.ravihansa3000.com/2014/04/installing-apache-stratos-40-with.html >>>>>>>>>>>> [2] http://www.flashesofpanic.com/panic/002596.php >>>>>>>>>>>> [3] >>>>>>>>>>>> https://cwiki.apache.org/confluence/display/STRATOS/4.0.0+Cloud+Controller+Configuration >>>>>>>>>>>> >>>>>>>>>>>> Thanks, >>>>>>>>>>>> Suhan and Thushara >>>>>>>>>>>> -- >>>>>>>>>>>> Suhan Dharmasuriya >>>>>>>>>>>> Software Engineer - Test Automation >>>>>>>>>>>> >>>>>>>>>>>> *WSO2, Inc. * >>>>>>>>>>>> >>>>>>>>>>>> lean . enterprise . middleware >>>>>>>>>>>> Tel: +94 112 145345 >>>>>>>>>>>> Mob: +94 779 869138 >>>>>>>>>>>> Blog: http://suhancoold.blogspot.com/ >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> Suhan Dharmasuriya >>>>>>>>>>> Software Engineer - Test Automation >>>>>>>>>>> >>>>>>>>>>> *WSO2, Inc. * >>>>>>>>>>> >>>>>>>>>>> lean . enterprise . middleware >>>>>>>>>>> Tel: +94 112 145345 >>>>>>>>>>> Mob: +94 779 869138 >>>>>>>>>>> Blog: http://suhancoold.blogspot.com/ >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> Dev mailing list >>>>>>>>>>> Dev@wso2.org >>>>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> *Lasindu Charith* >>>>>>>>>> Software Engineer, WSO2 Inc. >>>>>>>>>> Mobile: +94714427192 >>>>>>>>>> Web: blog.lasindu.com >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Suhan Dharmasuriya >>>>>>>>> Software Engineer - Test Automation >>>>>>>>> >>>>>>>>> *WSO2, Inc. * >>>>>>>>> >>>>>>>>> lean . enterprise . middleware >>>>>>>>> Tel: +94 112 145345 >>>>>>>>> Mob: +94 779 869138 >>>>>>>>> Blog: http://suhancoold.blogspot.com/ >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> >>>>>>>> Udara Liyanage >>>>>>>> Software Engineer >>>>>>>> WSO2, Inc.: http://wso2.com >>>>>>>> lean. enterprise. middleware >>>>>>>> >>>>>>>> web: http://udaraliyanage.wordpress.com >>>>>>>> phone: +94 71 443 6897 >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Thushara Kasun Ranawaka >>>>>>> Software Engineer >>>>>>> WSO2 Inc.; <http://www.wso2.com> >>>>>>> lean.enterprise.middleware >>>>>>> Mobile : *+94 (0) 773438949 <%2B94%20%280%29%20773438949>* >>>>>>> *thusha...@wso2.com <thusha...@wso2.com>* >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Dev mailing list >>>>>>> Dev@wso2.org >>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Regards, >>>>>> Manula Chathurika Thantriwatte >>>>>> Software Engineer >>>>>> WSO2 Inc. : http://wso2.com >>>>>> lean . enterprise . middleware >>>>>> >>>>>> email : manu...@wso2.com / man...@apache.org >>>>>> phone : +94 772492511 >>>>>> blog : http://manulachathurika.blogspot.com/ >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Dev mailing list >>>>>> Dev@wso2.org >>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Prasanna Dangalla >>>>> Software Engineer, WSO2, Inc.; http://wso2.com/ >>>>> lean.enterprise.middleware >>>>> >>>>> cell: +94 777 55 80 30 | +94 718 11 27 51 >>>>> twitter: @prasa77 >>>>> >>>>> _______________________________________________ >>>>> Dev mailing list >>>>> Dev@wso2.org >>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> Suhan Dharmasuriya >>>> Software Engineer - Test Automation >>>> >>>> *WSO2, Inc. * >>>> >>>> lean . enterprise . middleware >>>> Tel: +94 112 145345 >>>> Mob: +94 779 869138 >>>> Blog: http://suhancoold.blogspot.com/ >>>> >>> >>> >>> >>> -- >>> Regards, >>> Manula Chathurika Thantriwatte >>> Software Engineer >>> WSO2 Inc. : http://wso2.com >>> lean . enterprise . middleware >>> >>> email : manu...@wso2.com / man...@apache.org >>> phone : +94 772492511 >>> blog : http://manulachathurika.blogspot.com/ >>> >>> >>> >>> >>> _______________________________________________ >>> Dev mailing list >>> Dev@wso2.org >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> Thushara Kasun Ranawaka >> Software Engineer >> WSO2 Inc.; <http://www.wso2.com> >> lean.enterprise.middleware >> Mobile : *+94 (0) 773438949 <%2B94%20%280%29%20773438949>* >> *thusha...@wso2.com <thusha...@wso2.com>* >> > > > > -- > Thushara Kasun Ranawaka > Software Engineer > WSO2 Inc.; <http://www.wso2.com> > lean.enterprise.middleware > Mobile : *+94 (0) 773438949 <%2B94%20%280%29%20773438949>* > *thusha...@wso2.com <thusha...@wso2.com>* > -- Regards, Manula Chathurika Thantriwatte Software Engineer WSO2 Inc. : http://wso2.com lean . enterprise . middleware email : manu...@wso2.com / man...@apache.org phone : +94 772492511 blog : http://manulachathurika.blogspot.com/
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev