<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Thanks Ian, I'm already following your advice on this, as we
started the whole process on a Proxmox VM and we continue to
tinker with things by using a snapshot of the VM and leaving the
production version alone. <br>
</p>
<p>The actual answer to my question was to go to
Configuration->Employees->Employees (as my original
Superuser account, of course), and then re-enable the username
"root". Once you can log in as root again, you can grant access to
the RT system to allow other users in the Employees list to get
the access rights they need. <br>
</p>
<p>I would like to put these details into the Wiki, since searching
it for "Change root password" got me nowhere. There's actually
quite a lot of other things I would like to document in the Wiki,
if I could only get a new account to make changes.<br>
</p>
<br>
<div class="moz-cite-prefix">On 2017-05-17 01:27 PM, Ian Fraser
wrote:<br>
</div>
<blockquote
cite="mid:d0e8dbfc-0b4a-366b-f822-6fd9d15525ce@gozoom.ca"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<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 moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:freeside-users@freeside.biz">freeside-users@freeside.biz</a>
<a moz-do-not-send="true" 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>
<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>
</body>
</html>