[wsf-c-dev] [jira] Created: (WSFC-39) IF_EXISTS command needed in the file mysql_schema.txt file located inside WSF_C_HOME\sandesha2c\config

[Evanthika Amarasiri (JIRA)]

IF_EXISTS command needed in the file mysql_schema.txt file located inside WSF_C_HOME\sandesha2c\config
------------------------------------------------------------------------------------------------------

                 Key: WSFC-39
                 URL: http://www.wso2.org/jira/browse/WSFC-39
             Project: WSO2 WSF/C
          Issue Type: Bug
          Components: Apache Sandesha/C (RM)
    Affects Versions: 1.0alpha2
         Environment: Microsoft Visual Studio 8, MySQL Server 5.0, Windows XP
            Reporter: Evanthika Amarasiri
         Assigned To: Samisa Abeysinghe
            Priority: Minor


Below are the steps to reproduce the issue

1. Assume that you need to build WSF/C with MySQL enabled. Therefore, first install MySQL, set the correct paths in the config file and run the commands specified in the "create_mysql_user.txt" file
2. Next run the command "init_mysql.bat" and you will be given an error message saying that the sandesha2 database does not exist. 
The reason for this is that the first command in the "mysql_schema.txt" is to drop databases [E.g.:- drop database sandesha2_svr_db; drop database sandesha2_client_db;] but since my system is a fresh one, and no such databases exist, the script fails.
3. Therefore change the "mysql_schema.txt" where it drops the databases only if they exists in the system 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://www.wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira