Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Having to re-login for each table

Quote Reply
Having to re-login for each table
Hi,

I have a database with 10 users and 20 tables. Each user has access to 2 tables applicable to him.

When I login as a user on one table, and then either re-enter the URL of that table, or attempt to move to another one, I have to re-login. For example, if I login to http://www.megsh.com/...bin/db.cgi?db=AzK_db and then either re-enter the same URL, or move across to the other table: http://www.megsh.com/...K_input_game_results I have to re-login.

Session ID is active, with a period of 4 (hours). I'm getting URL's like this with SID: http://www.megsh.com/...b=AzK_db&fm=long

*EDIT: Also tried it with cookies instead of SID....same result, having to re-login each time.

Logging is also active for the table, and is recording the log_time / action / user_id / ip / tablename.

Ideally a user needs to be able to login and move between tables without having to re-login each time. Can someone please advise on how I can do this?

Thx,

Eli.

Last edited by:

Elisor: Dec 11, 2004, 7:15 AM
Quote Reply
Re: [Elisor] Having to re-login for each table In reply to
Hi,
If ALL your tables are sharing the same User table and you are using sessions you should be able to move between all your tables without having to login again.
Check that your URL looks something like -
http://www.yourdomain.com/directory/db.cgi?sid=f6c7a52b760b8e56bc9de1a7bbef3938&db=table_name
Simon.
Quote Reply
Re: [jai] Having to re-login for each table In reply to
Thx Simon.

Not all the users are sharing the same table. However, each user has 2 tables that they share - and it's those two tables I'm trying to move inbetween without them having to re-login each time they jump from one table to another.

Eli.
Quote Reply
Re: [Elisor] Having to re-login for each table In reply to
Eli,
Try adding &do=home (or another process) to the end of your URL.

http://www.yourdomain.com/directory/db.cgi?sid=f6c7a52b760b8e56bc9de1a7bbef3938&db=table_name&do=home

Does that make any difference?
Simon.


Quote Reply
Re: [jai] Having to re-login for each table In reply to
Nah, that doesn't work. **EDIT: when I try that on the URL's listed below, it gives an "invalid user or password error". That's even after I've logged onto one table, then moved to the next by adding &do=home at the end**

Let me give you an example. These are the actual URL's. Say I login into this URL:

http://www.megsh.com/...gi?db=AzK_players_db

The login details are test/test and you can view the records with those login details.

The above table shares the same user table and login details as the following table:

http://www.megsh.com/...K_input_game_results

BUT (and this is where the problem comes in) I have to login each time I move between tables, or each time I visit the same table again, even when it's in the SID lifetime. All I want to be able to do is up put the above two URL's in a webpage so someone can go visit them, but only has to login the once per session , instead of everytime he visits one of the tables during the session time.

Thanks for the help :)

Eli.

Last edited by:

Elisor: Dec 12, 2004, 2:54 AM
Quote Reply
Re: [Elisor] Having to re-login for each table In reply to
Played around some more and you're right Simon, it does work. My mistake was to have an already dropped table as the default home table. So it kept returning an error. Once that was changed it worked like a charm.

Also moved to cookies as well.

Thanks for the help :D

Eli.