Results 1 to 3 of 3

Thread: Database setup in SUSEStudio

  1. #1
    Join Date
    Jun 2008
    Location
    Düsseldorf/Germany
    Posts
    248

    Default Database setup in SUSEStudio

    Hi all,

    SUSEStudio offers the option to set up a postgres-database. According to the documentation, I have created a dump of the database and bz2'd it:
    gnuhealth24.sql.bz2
    I set up the users and authorisations in Studio. When I build and run the appliance, and issue the command:
    su postgres
    psql gnuhealth24

    This results in an error 'database does not exist'.

    Any idea how to fix this?

    (This question was posted in teh SUSEStudio Forum as well)

  2. #2
    Magic31 NNTP User

    Default Re: Database setup in SUSEStudio


    DocB;19884 Wrote:
    > Hi all,
    >
    > SUSEStudio offers the option to set up a postgres-database. According
    > to
    > the documentation, I have created a dump of the database and bz2'd it:
    > gnuhealth24.sql.bz2
    > I set up the users and authorisations in Studio. When I build and run
    > the appliance, and issue the command:
    > su postgres
    > psql gnuhealth24
    >
    > This results in an error 'database does not exist'.
    >
    > Any idea how to fix this?
    >
    > (This question was posted in teh SUSEStudio Forum as well)
    >
    >
    > --
    >


    Hi Doc,

    I've only done this with MySQL so far... and that was nothing more than
    installing the packages in the appliance.
    Then on a development system using the same versions of the mysql
    packages, built up the databases & users as needed and tar.zipped
    "/var/lib/mysql" preserving path, and finally add it to the appliance as
    files to be placed in the appliance.

    Probably not as the documentation lays it out, but it has worked
    perfectly for two appliances I've built.

    Cheers,
    Willem


    --
    Knowledge Partner (voluntary sysop)
    ---
    If you find a post helpful and are logged into the web interface,
    please show your appreciation and click on the star below it. Thanks!
    ------------------------------------------------------------------------
    Magic31's Profile: http://forums.suse.com/member.php?userid=73
    View this thread: http://forums.suse.com/showthread.php?t=4269


  3. #3
    Join Date
    Jun 2008
    Location
    Düsseldorf/Germany
    Posts
    248

    Default Re: Database setup in SUSEStudio

    Hi Willem,

    indeed, that is a very feasible way to get the database up and running.
    After fiddeling around for some time with scripts after installation and boot, that worked 'out of the box'.

    Thanks a lot for the hint!
    Axel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •