Session Expired message V7

ready4data · 06-06-2012, 08:22 AM

I'm upgraded to the latest version and trying to set up on my testing server before moving to my web host. I have some modified files I need to test before moving.
I ran the setup successfully but when the login screen comes up and I try to login, I get a Session Expired! message then it goes back to the login page. The url it is at is http://localhost/calendar/setup/index.php
If I go to the calendar url http://localhost/calendar the calendar displays.

Please advise,
Scott

ve9gra · 06-06-2012, 08:55 AM

Run the Tester script on your test server to see if everything is compatible... From checking the FAQ, it seems that the "Login loop" problem should only affect V6 and not V7.

ready4data · 06-06-2012, 09:15 AM

Tester ran and all passed. I did a clean install and didn't include any of my modified files and the same thing happened. I used localhost for the license key.

**Brian** · 06-06-2012, 09:56 AM

What is the exact version are you installing? 7.0.??

Version 7 does not use localhost for the license key.

FWIW, the only time I've seen this before was when the mySQL user didn't have the correct permissions.

ready4data · 06-06-2012, 12:08 PM

I'm using V70.8 for Zend.
I can access MySQL using the same U/P I have in the calendar.
If I use my registered key on the test server can I then use it when I move it to my webhost?

Scott

**Brian** · 06-06-2012, 01:58 PM

Did you go through the entire installation using Version 7.0.08? This version has checks to make sure your users has the correct permissions.

You can use a "fake" key if you want. You also have the option to "re-issue" your real key through the client area if you move the installation.

ready4data · 06-06-2012, 02:04 PM

Yes everything up to the point of logging in went correctly with no errors. I even deleted the tables in the database and ran through it again. It recreated them and said DB permissions were ok. I saw the data in the tables. Then at the login, I got a brief logging in message then the session expired message.

**Brian** · 06-06-2012, 02:06 PM

You have something else going on then that I haven't seen. Is this a local installation or a web server that hosts web sites?

**Brian** · 06-06-2012, 02:25 PM

Also, make sure you're not blocking cookies from the calendar.

ready4data · 06-06-2012, 03:00 PM

I'm testing this on my own box so I can customize before I move to my webhost.
Configuration Windows 2003 Server IIS6
MySQL 5.5.19
Calender V7.0.08 Zend
Installation on D:\inpub\wwwroot\calendar
Passed Server tester31
Install/setup of database through calendar interface completed with no errors.(I even tried deleting the database and created using a different database name) 9 tables created.
Version 6 worked on this test box.
Stumped...
Scott

**Brian** · 06-07-2012, 11:36 AM

Haven't heard back from you about cookies. Did you try that?

ready4data · 06-07-2012, 12:28 PM

Brian,
Sorry, Yes I enabled all cookies and even tried from Firefox and tried to connect from another PC to the site. Still the same issue. If I copy the version 6 calendar folder and its contents back to the server, it works correctly.
I also rebooted the server and tried another fresh install of the V7 to a new database name.
If we can get the timing right we can do a JoinMe session and you can take control and look.
Forgot to include in the previous post: PHP version 5.2.10

Scott

**Brian** · 06-07-2012, 12:35 PM

Is Session Support enabled in PHP?

ready4data · 06-07-2012, 01:00 PM

Yes, Session support is enabled in PHP.
See attachment
http://www.ready4data.com/documents/info.zip

**Brian** · 06-07-2012, 02:11 PM

After trying to log in, is there any data stored in the _sessions database table?

ready4data · 06-07-2012, 02:51 PM

Yes, In the table epc7_sessions,
id is f6d51743ad46d8aa175c0ef4f587669c
access is 1339094504
data blank
URL when Login is clicked:
http://localhost/calendar/events/index.php
URL while its trying to connect before it reverts back to the login page:
http://localhost/calendar/events/index.php?PHPSESSID=f6d51743ad46d8aa175c0ef4f587669c

**Brian** · 06-07-2012, 03:00 PM

Data should contain a lot of information...

Does your mySQL user have the REPLACE permissions?

ready4data · 06-07-2012, 03:28 PM

In the MySQL workbench, the user has every role checked.
I don't specifically see an item(priviledge or role) called "Replace"

Scott

**Brian** · 06-07-2012, 03:33 PM

Everything seems to be configured correctly. But, since it's a localhost, I really can log into it to test.

Right now you are the only person with this issue (the others I know of were permissions issues and were fixed by the user).

If I can think of anything else to try, I'll let you know.

ready4data · 06-07-2012, 03:37 PM

Thanks for your persistance, I hope its not something dumb I'm doing.
If you have a way for me to send you a private message, you can remote in through Join.me (joinme.com)

**Brian** · 06-07-2012, 03:39 PM

You can open a support ticket to send me a private message. However, I would need access to the server to upload/download test files, make modifications and repeat until I find the culprit on your setup. A remote control session won't work in this case.

**Brian** · 06-07-2012, 03:44 PM

Is the time set correctly on the server?

ready4data · 06-07-2012, 03:51 PM

Yes it is the current time.

**Brian** · 07-24-2012, 03:08 PM

I have isolated the issue with the few servers that have had this problem. It had to do with the server not being able to return the IP address of the user that was logging in, so the security of the login system could not properly authenticate them.

The fix (i.e. a work-around for these types of server configurations) will be released in Version 7.0.11.