Unable to log in to operative mode

Exxica

I made a new application, namely "Exxica" and it showed up fine on the Business Space Manager list. But when I deleted the "DefaultApplication" and logged back in the system tells me that I have an invalid user name or password. When I look into the database, it still shows signs of DefaultApplication being there in the BAS_SYSTEM table. But there's no other signs of it. There used to be a few tables connected to it which have apparently been dropped, but there are a few new ones like: EXXICA_REGULARUSER and such.

My first guess would be that the users were registered to the DEFAULTAPPLICATION_REGULARUSER table and as I deleted the Business Space, it deleted the logins as well. What would be the correct SQL string to insert a new user into the table?

Would this be correct?

INSERT INTO EXXICA_REGULARUSER(BASVERSION,AccessLevel,Password,LoginName) VALUES (1,'Administrator',md5('password'),'admin');

Exxica

I tried a:

UPDATE `EXXICA_REGULARUSER` SET `Password`=md5('password') WHERE ID=4

And tried to log back in, but no luck.

How do I reset the admin password?

Exxica

Correction: How do I reset the admin user and password to the new Exxica application?

Exxica

BAS_SYSTEM table:

EXXICA_REGULARUSER table:

Exxica

Fixed it.

Did:

DROP DATABASE BASDB;
DROP DATABASE BASDBTEST;

Then restarted the server, and it installed initial values.

Exxica

Though I am having a problem with not getting to use the Business space I have sat up. It always logs into the DefaultApplication.

tford

Probably best to purchase a support ticket and email support about this. I'm guessing they are not going to post on public forums the method to change an administrator password.

Exxica

Problem is that my associate has the account and refuses to give me the password as he uses it on his personal stuff.