Re: AW: [Openinteract-help] Trouble getting an old server up

[Chris W. <ch...@cw...>]

On Oct 1, 2004, at 3:56 PM, Vijai Rao wrote:
> well, I have had no luck.
>
> I tried reinstalling the whole thing and now get a whole bunch of
> errors with INITIAL install_sql
>
>  Structure:
>         * create_structure for mysql: no action taken
>       Data:
>         * Error: Cannot create SPOPS object!
>       Basic: DBD::mysql::st execute failed: Duplicate entry
>
> A lot of these...

Here's the standard way I run an install for PostgreSQL:

  # dropdb foo
  # createdb foo
  # ...edit conf/server.ini with db params...
  # ...edit conf/global_override.ini to set Postgres as db...
  # oi_manage install_sql --package=INITIAL

As Salve said, you might want to make sure you don't have an existing 
database with tables.

Then again, if you want to keep the data you don't need to run the 
'install_sql' piece at all.

Chris

--
Chris Winters
Creating enterprise-capable snack systems since 1988