Re: [otrs] OTRS 2.4.2 first login

2009-07-31 Thread Alan McKay
On Thu, Jul 30, 2009 at 10:44 AM, Alan McKayalan.mc...@gmail.com wrote: Hey folks, I wiped my DB and started over, and am to the point in the install where I am testing the first login. The instructions for 2.4.2 are the same as 2.3.4 and say to use r...@localhost and root, but that is not

Re: [otrs] OTRS 2.4.2 first login

2009-07-31 Thread Martin Edenhofer
Hi Alan, On Jul 30, 2009, at 17:23 , Alan McKay wrote: roK20XGbWEsSM I'll remove it and see what happens I have phpPGadmin running and could use it to set the PW. But googling is not helping me. Just removing will not help. You need to set it. Just use shell bin/otrs.setPassword

Re: [otrs] OTRS 2.4.2 first login

2009-07-31 Thread Alan McKay
This would seem to be my base issue. BTW, I'm using Postgres. And I did manage to get this working just fine on 2.3.4 -bash-3.2$ bin/otrs.setPassword r...@localhost root DBD::Pg::st execute failed: ERROR: permission denied for relation users at /opt/otrs-2.4.2/Kernel/System/DB.pm line 559.

Re: [otrs] OTRS 2.4.2 first login

2009-07-31 Thread Alan McKay
On Fri, Jul 31, 2009 at 12:23 PM, Alan McKayalan.mc...@gmail.com wrote: This would seem to be my base issue.  BTW, I'm using Postgres.   And I did manage to get this working just fine on 2.3.4 OK, I did this : otrs=# GRANT ALL PRIVILEGES ON DATABASE otrs to otrs; And I still have the issue.

Re: [otrs] OTRS 2.4.2 first login / postgresql issue

2009-07-31 Thread Martin Edenhofer
Hi Alan, On Jul 31, 2009, at 18:23 , Alan McKay wrote: This would seem to be my base issue. BTW, I'm using Postgres. And I did manage to get this working just fine on 2.3.4 -bash-3.2$ bin/otrs.setPassword r...@localhost root DBD::Pg::st execute failed: ERROR: permission denied for

Re: [otrs] OTRS 2.4.2 first login / postgresql issue

2009-07-31 Thread Alan McKay
It looks really like an database permission problem. I'm not a postgres guru, so I do not know how to grand this permissions in postgresql. :-/ See my follow up - I granted them and still no go. And I'm no DB guru either - and my DB Admin is away on vacation. I think he is back next week so

Re: [otrs] OTRS 2.4.2 first login

2009-07-31 Thread Alan McKay
OK, I just went into psql otrs And did \d to show all tables. They were all still owned by user postgres, so I did this to change them all to owner otrs first I just did psql otrs -c \d somefile Then edited somefile to remove headers and footers cat somefile | awk '{print $3}' otherfile

Re: [otrs] OTRS 2.4.2 first login / postgresql problem

2009-07-31 Thread Martin Edenhofer
Hi Alan, On Jul 31, 2009, at 21:06 , Alan McKay wrote: OK, I just went into psql otrs And did \d to show all tables. They were all still owned by user postgres, so I did this to change them all to owner otrs first I just did [...] psql otrs -c ALTER TABLE $table OWNER TO otrs; done And it

Re: [otrs] OTRS 2.4.2 first login / postgresql problem

2009-07-31 Thread Alan McKay
Fine! :) Also all the other stuff like dashboard? I'm not that far yet - doing many different things at once Will keep you posted. I got logged in OK. [...] OK, dashboard does not crash at least - so that seems to be a good start :-) -- “Don't eat anything you've ever seen advertised on

[otrs] OTRS 2.4.2 first login

2009-07-30 Thread Alan McKay
Hey folks, I wiped my DB and started over, and am to the point in the install where I am testing the first login. The instructions for 2.4.2 are the same as 2.3.4 and say to use r...@localhost and root, but that is not working. Maybe it is not connecting to the DB properly? Something else?

Re: [otrs] OTRS 2.4.2 first login

2009-07-30 Thread Aquiles Cohen
i'ts seem a bug on default installation because i tried thins twice with the same problem. Aquiles Cohen.- Homepage : http://aqcohen.blogspot.com On Thu, Jul 30, 2009 at 9:44 AM, Alan McKay alan.mc...@gmail.com wrote: Hey folks, I wiped my DB and started over, and am to the point in the

Re: [otrs] OTRS 2.4.2 first login

2009-07-30 Thread Alan McKay
So how do I get in? Hack my DB? On Thu, Jul 30, 2009 at 10:50 AM, Aquiles Cohenaqco...@gmail.com wrote: i'ts seem a bug on default installation because i tried thins twice with the same problem. Aquiles Cohen.- -- “Don't eat anything you've ever seen advertised on TV” - Michael

Re: [otrs] OTRS 2.4.2 first login

2009-07-30 Thread Alan McKay
Here is what is in the PW field roK20XGbWEsSM I'll remove it and see what happens On Thu, Jul 30, 2009 at 11:02 AM, Alan McKayalan.mc...@gmail.com wrote: So how do I get in? Hack my DB? On Thu, Jul 30, 2009 at 10:50 AM, Aquiles Cohenaqco...@gmail.com wrote: i'ts seem a bug on default

Re: [otrs] OTRS 2.4.2 first login

2009-07-30 Thread Alan McKay
On Thu, Jul 30, 2009 at 11:03 AM, Alan McKayalan.mc...@gmail.com wrote: Here is what is in the PW field roK20XGbWEsSM I'll remove it and see what happens I have phpPGadmin running and could use it to set the PW. But googling is not helping me. Anyone? Deleting it did not work --