Please check the place where it creates this database. Seems like it's not properly replaced.
On Wed, Sep 17, 2014 at 3:22 PM, Thushara Ranawaka <[email protected]> wrote: > Hi Manula, > Yes it is. > > > On Wed, Sep 17, 2014 at 3:18 PM, Manula Chathurika Thantriwatte < > [email protected]> wrote: > >> 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 <[email protected]> >> 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 <[email protected]> >>> 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 < >>>> [email protected]> 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 <[email protected]> >>>>> 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 <[email protected] >>>>>> > 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 < >>>>>>> [email protected]> 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 < >>>>>>>> [email protected]> wrote: >>>>>>>> >>>>>>>>> Hi Udara, >>>>>>>>> Yes, We will do the needful. >>>>>>>>> >>>>>>>>> Thanks, >>>>>>>>> Thushara. >>>>>>>>> >>>>>>>>> On Wed, Sep 17, 2014 at 12:43 PM, Udara Liyanage <[email protected]> >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Wed, Sep 17, 2014 at 12:16 PM, Suhan Dharmasuriya < >>>>>>>>>> [email protected]> 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 < >>>>>>>>>>> [email protected]> 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 < >>>>>>>>>>>> [email protected]> 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 < >>>>>>>>>>>>> [email protected]> 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 >>>>>>>>>>>>> [email protected] >>>>>>>>>>>>> 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>* >>>>>>>>> *[email protected] <[email protected]>* >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Dev mailing list >>>>>>>>> [email protected] >>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Regards, >>>>>>>> Manula Chathurika Thantriwatte >>>>>>>> Software Engineer >>>>>>>> WSO2 Inc. : http://wso2.com >>>>>>>> lean . enterprise . middleware >>>>>>>> >>>>>>>> email : [email protected] / [email protected] >>>>>>>> phone : +94 772492511 >>>>>>>> blog : http://manulachathurika.blogspot.com/ >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Dev mailing list >>>>>>>> [email protected] >>>>>>>> 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 >>>>>>> [email protected] >>>>>>> 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 : [email protected] / [email protected] >>>>> phone : +94 772492511 >>>>> blog : http://manulachathurika.blogspot.com/ >>>>> >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Dev mailing list >>>>> [email protected] >>>>> 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>* >>>> *[email protected] <[email protected]>* >>>> >>> >>> >>> >>> -- >>> Thushara Kasun Ranawaka >>> Software Engineer >>> WSO2 Inc.; <http://www.wso2.com> >>> lean.enterprise.middleware >>> Mobile : *+94 (0) 773438949 <%2B94%20%280%29%20773438949>* >>> *[email protected] <[email protected]>* >>> >> >> >> >> -- >> Regards, >> Manula Chathurika Thantriwatte >> Software Engineer >> WSO2 Inc. : http://wso2.com >> lean . enterprise . middleware >> >> email : [email protected] / [email protected] >> phone : +94 772492511 >> blog : http://manulachathurika.blogspot.com/ >> >> >> >> > > > -- > Thushara Kasun Ranawaka > Software Engineer > WSO2 Inc.; <http://www.wso2.com> > lean.enterprise.middleware > Mobile : *+94 (0) 773438949 <%2B94%20%280%29%20773438949>* > *[email protected] <[email protected]>* > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Thanks & regards, Nirmal Senior Software Engineer- Platform Technologies Team, WSO2 Inc. Mobile: +94715779733 Blog: http://nirmalfdo.blogspot.com/
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
