Menu
▾
▴
Re: [Openinteract-help] Installation
|
From: Bill M. <mo...@ha...> - 2001-12-20 19:45:42
|
At 08:44 AM 12/20/01 -0500, Chris Winters wrote:
>Can you drop the database and create a new one? (I'd recommend
>something other than 'test' since that frequently gets used by other
>programs.)
Sure. On my dev box I tend to use test for everything.
>And instead of running 'install_sql' by itself, try:
>
> $ export OIWEBSITE=/path/to/mysite
> $ oi_manage install_sql --package=INITIAL --sql_action=structure
That looks somewhat OK, but I'm not sure what's an error and what isn't:
base_security (1.53)
OK:
Structure:
* Cannot execute table SQL
CREATE TABLE sys_security (
...
)
Error: DBD::mysql::db do failed: Column 'object_id'
is used with UNIQUE or INDEX but is not defined as
NOT NULL at
No data installation done.
No security installation done.
/usr/local/lib/perl5/site_perl/5.6.0/OpenInteract/SQL
Install.pm line 136.
I'll append the full session below.
>If that works ok, then try:
>
> $ oi_manage install_sql --package=INITIAL --sql_action=all_data
>
>The message you included seems to indicate that the 'sys_security' table
>isn't getting created properly. If that isn't getting created then
>you'll have tons of problems. So separating the steps like this will
>make it easier to debug.
And again, with a new database called "oione" we get:
Error: DBD::mysql::st execute failed: Table 'oione.sys_security' doesn't
exist at /usr/local/lib/perl5/site_perl/5.6.0/SPOPS/SQLInterface.pm line 506.
With lots of error output (which I didn't append below -- let me know if
you want it and I'll mail it off list).
Linux mardy 2.2.13 #1 Mon Nov 8 15:51:29 CET 1999 i686 unknown
I installed everything from CPAN yesterday. (I had quit a few dependencies
to install, too.)
> oi_manage --website_dir=/data/_g/lii/OItest test_db
Running test_db...
=========================
Status of the database test:
OK:
Status of connection <<main>> (default connection)
=========================
-- Basic connect: ok
-- Use database: ok
-- Create table: ok
=========================
Finished test_db!
lii@mardy:~ > export OIWEBSITE=/data/_g/lii/OItest
lii@mardy:~ > oi_manage install_sql --package=INITIAL --sql_action=structure
[oi_manage]: Using (/data/_g/lii/OItest) for 'website_dir'.
Running install_sql...
=========================
Status of the packages requested for SQL install:
base (1.63)
OK:
Structure:
* Created table from (sessions.sql): ok
* Cannot execute table SQL
CREATE TABLE object_keys (
object_key char(32) not null,
class varchar(75) not null,
object_id varchar(255) not null,
primary key ( object_key ),
unique ( class, object_id )
)
Error: DBD::mysql::db do failed: Specified key was
too long. Max key length is 256 at
No data installation done.
No security installation done.
/usr/local/lib/perl5/site_perl/5.6.0/OpenInteract/SQL
Install.pm line 136.
=========================
base_box (0.41)
OK: No installer defined, no changes made for package.
=========================
base_component (1.30)
OK: No installer defined, no changes made for package.
=========================
base_error (1.37)
OK:
Structure:
* Created table from (error.sql): ok
No data installation done.
No security installation done.
=========================
base_group (1.30)
OK:
Structure:
* Created table from (group_table.sql): ok
* Created table from (link_table.sql): ok
No data installation done.
No security installation done.
=========================
base_page (0.40)
OK:
Structure:
* Created table from (page.sql): ok
* Created table from (page_content.sql): ok
* Created table from (content_type.sql): ok
No data installation done.
No security installation done.
=========================
base_security (1.53)
OK:
Structure:
* Cannot execute table SQL
CREATE TABLE sys_security (
sid INT NOT NULL AUTO_INCREMENT,
class varchar(60) not null,
object_id varchar(150) default '0',
scope char(1) not null,
scope_id varchar(150) default 'world',
security_level char(1) not null,
primary key ( sid ),
unique ( object_id, class, scope, scope_id )
)
Error: DBD::mysql::db do failed: Column 'object_id'
is used with UNIQUE or INDEX but is not defined as
NOT NULL at
No data installation done.
No security installation done.
/usr/local/lib/perl5/site_perl/5.6.0/OpenInteract/SQL
Install.pm line 136.
=========================
base_template (1.27)
OK:
Structure:
* Created table from (template.sql): ok
No data installation done.
No security installation done.
=========================
base_theme (1.29)
OK:
Structure:
* Created table from (theme.sql): ok
* Created table from (theme_prop.sql): ok
No data installation done.
No security installation done.
=========================
base_user (1.45)
OK:
Structure:
* Created table from (user.sql): ok
No data installation done.
No security installation done.
=========================
lookup (0.18)
OK:
Structure:
No data installation done.
No security installation done.
=========================
object_activity (0.10)
OK:
Structure:
* Cannot execute table SQL
CREATE TABLE object_track (
objtrack_id INT NOT NULL AUTO_INCREMENT,
class varchar(50) not null,
object_id varchar(150) not null,
action varchar(10) default 'create',
action_by INT not null,
action_on datetime not null,
notes text null,
primary key ( objtrack_id ),
unique ( class, object_id, action, action_by,
action_on )
)
Error: DBD::mysql::db do failed: Column 'action' is
used with UNIQUE or INDEX but is not defined as NOT
NULL at
No data installation done.
No security installation done.
/usr/local/lib/perl5/site_perl/5.6.0/OpenInteract/SQL
Install.pm line 136.
=========================
results_manage (0.06)
OK: No installer defined, no changes made for package.
=========================
system_doc (1.28)
OK:
Structure:
* create_structure for mysql: no action taken
No data installation done.
No security installation done.
Important Notes
-------------------------
none
=========================
Finished install_sql!
Bill Moseley
mailto:mo...@ha...
|
