Gossamer Forum
Home : Products : DBMan : Installation :

Using multple databases HELP?

Quote Reply
Using multple databases HELP?
I'm working on a project where I have 14 different databases to play with. I have it set up where anyone can search for information in any of the areas with out logging in. But I need them to log in so they can enter info. My problem is what kind of link do I use for logging in and entering detail into each database. I'd love it if people could log in and enter details into any of the databases without logging in time after time.

Currently I have the link -
http://www.lightwaveworld.com/cgi-bin/dbman/db.cgi?signup_form=1

for new users. This link pulls the login form from the html.pl file. I'm not even using that file right now. How do I get it to pull the form from each of the databases?
How do I accomplish this?

The search page is located at:
http://www.lightwaveworld.com/search.html

The only database I have working right now is the website one. The rest are in limbo.

I have separate db files like this.
website.cfg
website.db
website.pl
website.log

The rest of the files are just straight out of the origonal archive. Modified to work with my site of cource.

Any help is greatly appreciated.


------------------
"rippin Lightwave a new polygon"

http://www.lightwaveworld.com
thomas@lightwaveworld.com
Quote Reply
Re: Using multple databases HELP? In reply to
Use one .pass file and one auth directory for all of your databases -- this is assuming that everyone who logs in will have the same permissions on all of your databases.

Each db will have its own .cfg file, html.pl file and (if you want) its own .log file.

It won't matter which database they log in on. If you use the same .pass file and the same auth directory, when they log into one, they're logged into all.


------------------
JPD
Quote Reply
Re: Using multple databases HELP? In reply to
But what I don't understand is why it uses the html.pl file for signup. And for that matter it brings the user to the wrong screen. It brings em to the Login screen. How is a user supposed to log in if it won't take em to the signup screen. I'm using this link -
http://www.lightwaveworld.com/cgi-bin/dbman/db.cgi?signup+form=1

And to top it off this link is being pulled from a file called websites.pl. You'd think it would just go to the bottom and use the signup section there. But it doesn't! It pulls it from the html.pl file that I'm not even using. Should I delete the html.pl file or what?

And why does it take the user to the logon section and not the signup section?



------------------
"rippin Lightwave a new polygon"

http://www.lightwaveworld.com
thomas@lightwaveworld.com
Quote Reply
Re: Using multple databases HELP? In reply to
  
Quote:
I'm using this link -
http://www.lightwaveworld.com/cgi-bin/dbman/db.cgi?signup+form=1

And to top it off this link is being pulled from a file called websites.pl. You'd think it would just go to the bottom and use the signup section there.

You have to understand that the whole script starts over every time you send a command to it and by the time it finishes building the page the script has ended. The next time, the script has no idea where it left off.

You need to include the name of your .cfg file that you want people to use for signup:
...db.cbi?db=websites&signup_form=1 (I'm assuming your "signup+form" above was a typo.) Without the "db=websites" part of the URL, it thinks you want to use the html.pl file as defined in default.cfg.

I just visited your site and I was wrong. You're "signup+form" was not a typo, at least here on the forum.. If you use "db.cgi?signup_form=1", you'll get users to your signup form just fine.

You might also think of adding a link on the login form for users who don't already have an account. Just a thought.

------------------
JPD



[This message has been edited by JPDeni (edited January 03, 1999).]