Gossamer Forum
Home : Products : DBMan : Installation :

Creating their own user names

Quote Reply
Creating their own user names
I'm trying to allow people to add themselves to the DB however, when I've entered in a test user name and pw, there's an error....?

# Allow people to sign up for their own userid/passwords? They will
# recieve default permissions.
$auth_signup = 1;

The above should be correct...
Quote Reply
Re: Creating their own user names In reply to
What kind of error? What is the exact error message that you get?


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





Quote Reply
Re: Creating their own user names In reply to
This:

Log On Error

Oops, there was a problem logging into the system: invalid username/password.

Please try logging in again, or contact the system administrator.

Also:

One thing though - how do you modify a record. I put in the search query, for example "RAY" as last name, it returns a blank, "modify" record window...do I just put in the fields I want to change? If so should it show what is currently in the DB so you can edit it that way...like Access would?
Quote Reply
Re: Creating their own user names In reply to
Looks like you're not adding your new username and password on the signup form.

Look in sub html_login_form and see if there's a line like this:

Code:
if ($auth_signup) {
print qq|<$font>You can sign up for an account online right
<a href="$db_script_url?db=$db_setup&signup_form=1">here</a>.</font><P>
|;
}

If not, add it.

Your modify form should be filled in. If it isn't, you have a problem somewhere in your database.


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





Quote Reply
Re: Creating their own user names In reply to
Where should I place your code at? And why was it not there from the beginning?

Here's what I have though...

sub html_login_form {
# --------------------------------------------------------
# The login screen.

&html_print_headers;
print qq|
<html>
<head>
<title>$html_title: Login.</title>
</head>
<body bgcolor="#DDDDDD" text="#000000" onLoad="document.form1.userid.focus()">
<form action="$db_script_url" method="post" name="form1">
<input type=hidden name="db" value="$db_setup">
<input type=hidden name="uid" value="$db_uid">
<center>
<table border=1 bgcolor="#FFFFFF" cellpadding=5 cellspacing=3 width=500 align=center valign=top>
<tr><td colspan=2 bgcolor="navy">
<FONT FACE="MS Sans Serif, arial,helvetica" size=1 COLOR="#FFFFFF">
<b>$html_title: Login</b>
</td></tr>
<tr><td>
<p><center><$font_title>
<b>Log On</b></font></center><br>
<$font>Welcome! You need to have an active account to access $html_title. For
the demo, you can use userid/passwords: 'admin/admin', 'author/author', 'guest/guest'.
<p>
<table border=0>
<tr><td><Font face="Verdana, Arial, Helvetica" Size=2 Color=#003399><b>User ID:</b></FONT></td>
<td><input type="TEXT" name="userid"></td></tr>
<tr><td><Font face="Verdana, Arial, Helvetica" Size=2 Color=#003399><b>Password:</b></FONT></td>
<td><input type="PASSWORD" name="pw"></td></tr>
</table>
<p align=center><center><input type="SUBMIT" name="login" value="Logon"> <INPUT TYPE="SUBMIT" NAME="logoff" VALUE="Cancel"></center></p>
</td></tr>
</table>
</center>
</form>
</body>
</html>
|;
}

***What could be wrong with the datbase for this to happen...? Thanks ever so much.
Quote Reply
Re: Creating their own user names In reply to
Put the code I gave you earlier just after

</td></tr>
</table>

Regarding the modify thing: It could be that there is a problem with your key field.

Are you sure it's a blank modify form or is it a search form, with a message of "no records found"?


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





Quote Reply
Re: Creating their own user names In reply to
Blank - nothing there. I know the record is there. Thanks for the code....
Quote Reply
Re: Creating their own user names In reply to
I only queried the last name field, maybe I should have input something in the index field also...?!! I'll try that
Quote Reply
Re: Creating their own user names In reply to
CGI ERROR==========================================
Error Message : Error loading required libraries.
Check that they exist, permissions are set correctly and that they compile.
Reason: Missing $ on loop variable at ./onadbhtml.pl line 987.
Quote Reply
Re: Creating their own user names In reply to
It's getting hard to keep the problems straight here.

I didn't mention something I should have.

In sub html_login form, after

</td></tr>
</table>

add

Code:
|;
if ($auth_signup) {
print qq|<$font>You can sign up for an account online right
<a href="$db_script_url?db=$db_setup&signup_form=1">here</a>.</font><P>
|;
}
print qq|

That should fix up your code.

As to your modify problem, I would need to see your database in action.


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





Quote Reply
Re: Creating their own user names In reply to
Modiy works now....