On Fri, Jan 25, 2013 at 12:40 PM, Heshan Suriyaarachchi < [email protected]> wrote:
> Hi Devs, > > I fixed the issue for AIRAVATA-741. I ran the integration tests as well. > All tests pass without any issue. Shall I commit the change to the trunk? > +1 This fix is vital for users who plan to use older versions of mysql servers. Saminda > > On Fri, Jan 25, 2013 at 11:46 AM, Lahiru Gunathilake <[email protected] > >wrote: > > > On Fri, Jan 25, 2013 at 11:37 AM, Suresh Marru <[email protected]> > wrote: > > > > > > > > >> this is because you haven't created database tables. > > > >> > > > > Yes, but when I try to manually run the scripts I'm getting following > > > error > > > > while creating tables. > > > > > > > > $ mysql -u root -p --database=persistent_data < > > > > > > > > > > ../webapps/airavata-server/WEB-INF/classes/database_scripts/data-mysql.sql > > > > Enter password: > > > > ERROR 1146 (42S02) at line 37: Table 'persistent_data.CONFIGURATION' > > > > doesn't exist > > > > > > Can we look at automating table creation in mysql if they don't exist? > We > > > probably can reuse the XRegistry code [1] which checks if the relevant > > > tables exist if not run the sql script which creates them. > > > > > We create tables.. sorry its my bad ! > > > > Lahiru > > > > > > > > Suresh > > > [1] - https://svn.apache.org/repos/asf/airavata/attic/xregistry/ > > > > > > > > > > -- > > System Analyst Programmer > > PTI Lab > > Indiana University > > > > > > -- > Regards, > Heshan Suriyaarachchi > > http://heshans.blogspot.com/ > http://www.linkedin.com/in/heshan >
