[SBEAMS-devel] Re: SBEAMS install

[Jeff H. <pea...@ve...>]

Hi, Dave -

Sorry for the delay in getting back on this.  My mistake.  I was
assuming I could override the DBPREFIX{xxx} values to "sbeams." in the [
mysql ] block of SBEAMS.conf.  Apparently not.  I went back and changed
all the values from "sbeams.dbo." to "sbeams." in the main section, and
now Core_CREATTABLES.mysql, etc. get created with the appropriate table
names for mysql.

If I had put the override in the [ dev1 ] block instead, I suspect it
might have worked, but I didn't try it.

Jeff

#######################################################

Dave -

Thanks for the reply.  I did recently overhaul my SBEAMS.conf using the
new template, and set all the DBPREFIX{xxx} = sbeams., i.e. without
.dbo.  I thought I did this before running generate_schema, but perhaps
not.  I'll check and get back to you.

Jeff

########################################################

-----Original Message-----
From: sbe...@li...
[mailto:sbe...@li...] On Behalf Of Dave
Campbell
Sent: Monday, February 27, 2006 10:22 AM
To: sbe...@li...
Cc: Brian Pratt
Subject: [SBEAMS-devel] Re: SBEAMS install

Jeff;

To follow up on my previous message, I checked out the latest codebase 
and set up my SBEAMS.conf file to specify a mysql database as follows:

DBPREFIX{Core}  =  dcampbel.

I then ran generate_schema.pl with these options:

$SBEAMS/lib/scripts/Core/generate_schema.pl --table_p 
Core_table_property.txt --table_c Core_table_column.txt --schema 
../../sql/Core/Core -m Core --dest Core

The resultant Core_CREATETABLES.mysql had table specifiers of the form:

dcampbel.table_name

This runs without error vs. mysql (5.0.18). 

FYI, when I was testing installs around the last release, I wrote a few 
shell scripts, one which sets up sbeamcommons and other directories and 
symlinks for the Core install, and another which will build and install 
the schema and initial data for Core, BioLink, and any specified 
modules.  It has been on my todo list to check these in; I will try to 
do so in the next couple of days, in the hopes that they might help 
anyone doing a fresh install.

-Dave


>I am reinstalling SBEAMS under MySQL 5.0 on my Linux machine.  When I
>run Core_CREATETABLES.mysql, I get the following SQL error:
>
>@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
>
>[jhowbert@localhost Core]$ $SBEAMS/lib/scripts/Core/runsql.pl
> -u sbeamsadmin -s Core_CREATETABLES.mysql
>Enter password, followed by [Enter] (cntl-C to quit):
>   
>DBD::mysql::db do failed: You have an error in your SQL syntax;
>check the manual that corresponds to your MySQL server version
>for the right syntax to use near
>	'.organization_type ( organization_type_id int AUTO_INCRE at
>	/var/www/html/dev1/sbeams/lib/scripts/Core/runsql.pl
>	line 130, <FIL> line 587.
>
>@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
>
>When looking at Core_CREATETABLES.mysql, I notice that all the CREATE
>TABLE commands are of the form:
>
>CREATE TABLE sbeams.dbo.<table_name> (
>
>Table names in MySQL do not use the qualifier .dbo, so this may be the
>problem.
>
>Jeff Howbert
>