Forum LAMS for Tech-Heads - General Forum: A stupid, stupid mistake

By: Ernie Ghiglione

[ Reply | Forward ]

Hi Mat,

I think that you can fix this by doing some changes on the db directly. Login into the MySQL database and run this script.

insert into lams_user_organisation_role set user_organisation_role_id = 1, user_organisation_id = 1, role_id =1 ;

That should restate sysadmin rights to your sysadmin user.

Thanks,

Ernie

Posted by Ernie Ghiglione

By: Matthew Topp

[ Reply | Forward ]

Thanks Ernie, I tried it, but...

I get this error:

Cannot add or update a child row: a foreign key constraint fails (`lams2/lams_user_organisation_role`, CONSTRAINT `FK_lams_user_organisation_role_3` FOREIGN KEY (`user_organisation_id`) REFERENCES `lams_user_organisation` (`user_organisation_id`) ON DELETE N)

Any ideas?

Matt.

Posted by Matthew Topp

By: Jun-Dir Liew

[ Reply | Forward ]

You need to fulfill the constraint before running that script.  Do this first:

insert into lams_user_organisation (organisation_id, user_id) values (1,1);

then do:

select user_organisation_id from lams_user_organisation where organisation_id=1 and user_id=1;

you'll get a number back.  in the following script replace <the number> with this number.

insert into lams_user_organisation_role (user_organisation_id, role_id) values (<the number>, 1);

then restart lams.  if you run these 3 commands, don't run Ernie's one.  also, insert usual warning here about modifying data, make sure you have backups, etc.

Posted by Jun-Dir Liew

By: Jun-Dir Liew

[ Reply | Forward ]

If you're using Apache with mod_jk, it maybe possible to use mod_rewrite as well to achieve what you want. Or you could edit the index.html in jboss' root folder, which has the path /path/to/jboss-4.0.2/server/default/deploy/jbossweb-tomcat55.sar/ROOT.war; in there you can use a meta refresh tag to redirect people to /lams. I don't think an .htaccess file will work.

Posted by Jun-Dir Liew