[freeside-users] Changing root password for Freeside.

[Ian Fraser]

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 */_anything_ 
/*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.

Ian


On 17/05/2017 3:35 PM, Ernie Dunbar wrote:
>
> 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.
>
> But now the root password I have recorded isn't working, or perhaps 
> I've disabled the root user because I'm an idiot.
>
> 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:
>
> *update users set password = 
> crypt('somerandompassword',gen_salt('bf')) where user='root';**
> **ERROR:  function gen_salt(unknown) does not exist**
> **LINE 1: ...e users set password = 
> crypt('somerandompassword',gen_salt('...**
> **^**
> **HINT:  No function matches the given name and argument types. You 
> might need to add explicit type casts.*
>
> 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.
>
>
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users

-- 
Ian Fraser
goZoom.ca Inc.
195 Libby's Rd. McNab-Braeside
K7S0E1
877(613) 622 0093 ext 21

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://freeside.biz/pipermail/freeside-users/attachments/20170517/fd5533b8/attachment.html>