Re: np-setup error

Wes Hardaker <[email protected]> Wed, 11 May 2005 15:22:48 -0700
Newsgroups gmane.network.net-policy.user
Organization Sparta
Message-ID <[email protected]>
>>>>> On Sun, 8 May 2005 11:53:37 -0700 (PDT), Le Dang Khoa <kenji_le-/[email protected]> said:

Le> # /usr/local/bin/np-setup -u sqluser -p sqlpass -M

Le> DBI connect('host=172.16.196.196','sqluser',...) failed: FATAL: database "sqluser" does not exist

Le> at /usr/local/bin/np-setup line 49

If you ran np-install to install everything, then you shouldn't need
to run np-setup as it did this for you.

If you didn't run np-install, then you didn't create the 'sqluser'
user in your postgres database...  np-install would have asked you
what you wanted to name your user and would have both created this
user for you, as well as run np-setup with the correct arguments.

you can actually go back and make np-install re-set your database
using *ONLY* the following checkboxes on the second page:

       Pick a database user name and password
       Set up the postgres database for Net-Policy
       Create the Net-Policy specific database structures

If you turn off everything else, you can completely reset the postgres
database and start fresh.  Assuming you have no other important data
in your database, I do recommend you check the option on the postgres
setup screen that asks if you want to complete erase the old database.


-- 
Wes Hardaker
Sparta, Inc.


-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click