<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<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>
</body>
</html>