Configure PostgreSQL Defaults with SCInterface

From SCInterface Wiki

Jump to: navigation, search

The following provides instructions for reconfiguring the PostgreSQL database from scratch to function with your SCM. If doing this for the first time, you may want to refer to HowTo: Install PostgreSQL. The SCM must be able to communicate with the database in order to operate correctly.

Additional Related Articles:

[edit] Reconfiguring the SCM to Use the Database

To get started:

  1. Run the Linux installer to reinstall the SCM.
    1. First run it and when you get to the screen where you have the option to install/remove each component
    2. Set it to remove the SCM component (by typing -SCM until you get a [R] next to SCM.
    3. Then type done to uninstall the SCM.
  2. Then re-run the installer to install the SCM, and during the questioning process, make sure to accept all the default values by simply hitting the enter key at each question (which will accept the proposed defaults)

If this doesn't work, you'll need to setup md5 authentication for your scmuser.

[edit] Setting up MD5 Authentication

  • Connect to your db server as root: 
su -c "psql SCM_ServerDB" postgres
  • Generate a random password. When you see 'SCM_ServerDB=#', type: 
select md5(random());<prev>
...followed by the enter key.  This will output a long string of letters and numbers. 
* Copy and paste this number into notepad or remember it somehow. 

* Assign that password to your db user.  Replace '''blah''' with your new password at that same # prompt : 

<pre>ALTER USER scmuser WITH password 'blah';
  • Disconnect from db server: 
\q

...followed by the enter key .

  • Tell the SCM to use that password by opening /home/scmuser/runme.sh in your favorite editor

and add: 

export DB_PASSWORD='blah';

...with the other exports near the top of the file

  • Restart your scm as root by typing: 
/etc/init.d/SCM stop; /etc/init.d/SCM start

Your SCM should not be configured to connect into your PostgreSQL database.

Related:

Retrieved from "http://wiki.scinterface.com/index.php/Configure_PostgreSQL_Defaults_with_SCInterface"
Personal tools