So how do I get in? Hack my DB? On Thu, Jul 30, 2009 at 10:50 AM, Aquiles Cohen 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 Pollan, author of "In Defense of Food"

On Thu, Jul 30, 2009 at 11:03 AM, Alan McKay 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 -- “Don't eat anything you've ever seen advertised on TV” - Michael Pollan, author of "In Defense of Food"

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 root@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. ERROR: otrs.setPassword-10 Perl: 5.8.8 OS: linux Time: Fri Jul 31 12:22:40 2009 Message: ERROR: permission denied for relation users, SQL: 'SELECT id, login, salutation, first_name, last_name, pw, valid_id FROM users WHERE LOWER(login) = ?' Traceback (13149): Module: Kernel::System::User::GetUserData (v1.93) Line: 172 Module: Kernel::System::User::SetPassword (v1.93) Line: 555 Module: bin/otrs.setPassword (unknown version) Line: 80 ERROR: otrs.setPassword-10 Perl: 5.8.8 OS: linux Time: Fri Jul 31 12:22:40 2009 Message: No such User! Traceback (13149): Module: Kernel::System::User::SetPassword (v1.93) Line: 557 Module: bin/otrs.setPassword (unknown version) Line: 80 -- “Don't eat anything you've ever seen advertised on TV” - Michael Pollan, author of "In Defense of Food"

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 Yes, that was a gratuitous cat :-) Then just for table in `cat otherfile` do psql otrs -c "ALTER TABLE $table OWNER TO otrs;" done And it worked! -- “Don't eat anything you've ever seen advertised on TV” - Michael Pollan, author of "In Defense of Food"

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 TV” - Michael Pollan, author of "In Defense of Food"

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 this may have to wait til then. I recall that he helped me set up the permissions for 2.3.4 THough I have my SQL dump for the whole 2.3.4 installation so I may be able to look through there to see what it does. Because when I restored that DB and moved back to 2.3.4 everything seemed to be OK. Will report back ... -- “Don't eat anything you've ever seen advertised on TV” - Michael Pollan, author of "In Defense of Food"