<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>I cannot advise you on this directly but, after having done
many, many, many battles while originally installing Freeside 3.x
and many more first trying to upgrade to 4.x and then giving up
and just installing 4.x from source, I can advise that your Best
bet is to start again and use a VirtualBox VM. Make VB snasphots
before you change <b><i><u>anything</u> </i></b>as you work
through getting it to production status. Once you have your
production image ready then write it to a LVM partition and use
LVM snapshots to generate nightly backups. RUBackup is a good
tool for that. If you decide you want to upgrade, then create a
copy of a LVM snapshot on another partition/VB Machine and work
through the upgrade on the Copy. Never directly upgrade
Production version of FS.<br>
</p>
<p>Ian<br>
</p>
<br>
<div class="moz-cite-prefix">On 17/05/2017 3:35 PM, Ernie Dunbar
wrote:<br>
</div>
<blockquote
cite="mid:00891fab-de18-7866-b0d8-c78420fd5142@lightspeed.ca"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=windows-1252">
<p>Due to the last issue we had with creating tickets in
Request-Tracker, it's become apparent that we need to log into
Freeside and RT with the Root account to change the user
permissions. <br>
</p>
<p>But now the root password I have recorded isn't working, or
perhaps I've disabled the root user because I'm an idiot. <br>
</p>
<p>So now I need to change the root password, or re-create the
root account to be able to move forward on this. However, there
appears to be no freeside-passwd command, nor even a
freeside-deluser command or anything equivalent. My next avenue
would be to try to modify the current password in Postgres,
although I'm apparently doing that *all* wrong:<br>
<br>
<b>update users set password =
crypt('somerandompassword',gen_salt('bf')) where user='root';</b><b><br>
</b><b>ERROR: function gen_salt(unknown) does not exist</b><b><br>
</b><b>LINE 1: ...e users set password =
crypt('somerandompassword',gen_salt('...</b><b><br>
</b><b>
^</b><b><br>
</b><b>HINT: No function matches the given name and argument
types. You might need to add explicit type casts.</b></p>
<p>Aside from the fact that Postgres apparently doesn't like the
crypt() function on this version of Postgres, I'm probably doing
this entirely wrong, to the wrong database table anyway. I just
need a method for changing the Freeside Root password that
doesn't involve a complete re-install of Freeside.<br>
</p>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
freeside-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:freeside-users@freeside.biz">freeside-users@freeside.biz</a>
<a class="moz-txt-link-freetext" href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Ian Fraser
goZoom.ca Inc.
195 Libby's Rd. McNab-Braeside
K7S0E1
877(613) 622 0093 ext 21
</pre>
</body>
</html>