Forum Problems Installing LAMS: Re: Re: Re: Re: Re: Re: Re: Re: LAMS 2.1 + jBoss 4.0.2 + Reinstall != Login

By: Marc Fournier

[ Reply | Forward ]

See my comment further on ... I suspect something else is involved here ... logging in as one of the test? users that are created seems to work, just not sysadmin ...

Posted by Marc Fournier

By: Jun-Dir Liew

[ Reply | Forward ]

Yes, that is weird. Do you see any exceptions in the logs when you try to login as sysadmin? If you're not sure, can you post them anyway?

Can you have a look at the lams_user table (possibly something invalid there?):

select * from lams_user where login='sysadmin' or login='test2';

Posted by Jun-Dir Liew

By: Marc Fournier

[ Reply | Forward ]

they have slight differences:

| 1 | sysadmin | a159b7ae81ba3552af61e9731b20870515944538 | The | System | Administrator | NULL | NULL | NULL | Sydney | NSW | NULL | Australia | NULL | NULL | NULL | NULL | sysadmin@x.x | 0 | 2008-06-13 10:57:05 | 1 | 51 | 1 | 2 | NULL | NULL | NULL | 0 | 1 |
| 6 | test2 | a159b7ae81ba3552af61e9731b20870515944538 | Dr | Two | Test | 2 | Test Ave | NULL | Nowhere | NSW | NULL | Australia | 0211111111 | 0211111112 | 0411111111 | 0211111113 | test2@xx.os | 0 | 2004-12-23 00:00:00 | 1 | 6 | 1 | 2 | NULL | 1 | NULL | 0 | 1 |

Posted by Marc Fournier

By: Jun-Dir Liew

[ Reply | Forward ]

There we have a problem in sysadmin, locale_id is null. Not sure how it happened, but do this and it should fix it:

update lams_user set locale_id=1 where user_id=1;

Posted by Jun-Dir Liew

By: Marc Fournier

[ Reply | Forward ]

Woo hoo ... we have lift off ... will pass it back over to Geoff to find the 'next issue' :)

Thx

Posted by Marc Fournier

By: Geoffrey S Davidson

[ Reply | Forward ]

Marc, are you suggesting that I'm good a breaking things, or just warning folks HOW good I am at finding and breaking things ;)

Thanks to everyone here in the forum who helped us. This gives us what we need to begin beating up the apps to make sure they'll do everything we need both internally and for our external clients. Hopefully I won't be pushing the limits so far that I break it too badly with my efforts.

Geoff

Posted by Geoffrey S Davidson

By: Ernie Ghiglione

[ Reply | Forward ]

Ah, Right!

Marc, what was the language and locale you have set up in your configuration file? If it a language and locale that LAMS wouldn't support, then I believe the NULL value is set. I believe we fixed this for the next 2.2 installer.

Thanks,

Ernie

Posted by Ernie Ghiglione

By: Marc Fournier

[ Reply | Forward ]

# Default language locale and text direction for LAMS, see section 3 of the readme
LOCALE=en_US
LOCALE_DIRECTION=LTR

Posted by Marc Fournier

By: Ernie Ghiglione

[ Reply | Forward ]

Precisely!

> LOCALE=en_US

en_US as language does not exist in LAMS. The English translation we have is LAMS so far is the Australia version (en_AU).

The installer when trying to create the sysadmin user, couldn't find the id for the en_US language so it left it as NULL... causing all this problem.

We make sure we fix this and set the language to a default language in the case that the language set at configuration is not supported.

Thanks Marc!

Ernie

Posted by Ernie Ghiglione