User not active(!?) after deployment

Scriptcase 9 General
#1

Over the last month I revisited a project (SC8.1) we started a couple of years ago. Eventually we gave up because it seemed impossible to deploy.

Anyway, I managed to get it partly deployed along with the database & tables we used during development and testing locally. Passwords are using MD5 hash. The remote server is a virtual host (LAMP PHP 5.5. mysql 5.6) server.

We got as far as establishing the database connection and reaching the app_login page.

At log in we get a “user not activated” fatal error message. Looking into the sec_users table the activated fields are set to “Y”.

Reading elsewhere one suggestion was to clear the browsing history and cookies, but that’s not our the issue.

Before I finally give up, if there is a helpful troubleshooting suggestion or two to be found I’d be grateful.

Thanks

#2

First of all set all the right checkboxes in your development environment so that the security applies. If that works well then deploy to a local wamp and test. Then upload and copy the exported wamp database into production. Have you tested the synchronize option? Depending on your SC version there might be some issues there, we have found bugs. Look over in your security tables if it reveils the correct application names, we have found issues there. But to be honest the are pretty old and so far we never had real issues deploying applications. So don’t give up, it must be something very obvious.

#3

We’re using LAMP. That aside, what you have outlined we’ve done and more, i.e. we deployed the project and its database to a Ubuntu Server (16.04.1 LTS) on our local network. Everything worked as expected.

We than deployed the project to the remote virtual host, and imported the database to the remote server’s environment. The mysql user used in the projects connection has all privileges. SC’s connection editor reports the connection as OK.

I think I’ll stop now. My head’s hurting

Cheers

#4

Early morning, my masochistic tendencies kick in. I can’t help myself. Clean out everything SC project related on the remote virtual host. Reinstall the SC project. Link. Passwords. Database connection. So far so good. CLose browser. Re-open browser. Link to app_login. Cautiously and slowly type log in criteria.

Bingo. It works, 18 months on, after countless similar attempts and exercises. Much relief.

Open first grid application, which features GROUP BY options. These worked fine in the development environment and the web server environment on our local server.

No GROUP BY on the remotely deployed project. Argggghhhhhh…

I should go to the pub…

#5

Right, one step forward, two back.

Step Forward: I don’t why, but it seems the issue might have been due to using Friendly URLS(?). This looked nifty in the project’s website folder, but scouring the web I see that some were blaming Friendly URLs for bad behaviour. So, I reworked the applications, removed the Friendly URLs, and built it all again, That was 8 or so hours ago. Everything seemed to be working.

Two Steps Back: This morning, our time, I tried a login on the remote virtual host and get Unauthorised User. WTF? Check everything. Reset password with MD5. No luck. Download the the database to the local test web server. Run the project locally, no problems. Rebuild, re-test locally. All good. Clean install of project on remote server, including the database. Try login “Unauthorized User”.

I give up!