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* *thusha...@wso2.com <thusha...@wso2.com>*
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
