RE: DBv7 setup
Bulent Can
Hi Jay
If you want to be prompted for Windows credentials then in IIS set your DBNET for Basic Authentication and disable Anonymous Access.
Note that you need to install the Basic authentication module first as per Section 4.4 of http://www.designbais.com/usermanual/usermanual.aspx
Regards
Bulent Can
DesignBais
From: designba...@googlegroups.com [mailto:designba...@googlegroups.com]
On Behalf Of Jay
Sent: Tuesday, 29 January 2019 11:16 AM
To: DesignBais-Forum
Subject: Re: DBv7 setup
Hi Bob,
I made the changes below and even with "dbnetuser" as the loginpublicuser, I still receive a Default form not found message. I also tried adding DBCLIENT_DEMO as the qcode and received a "session initialization" error. I tried several other combinations but I think I moving farther from a solution.
I must be missing something fundamental about the db.config file. I'm not quite understanding why DB is trying to login using the public user. Shouldn't I be prompted to login with Windows Authentication like I had been using with v6? Do I need to remove these lines from db.config so DB won't try?
Thanks for you help!
On Saturday, January 26, 2019 at 3:57:10 PM UTC-5, Newstart wrote:
Hi Jay,
Your db.config is attempting to start in the DesignBais start account DBINET.DEMO with a user “dbpublic”.
I assume that is the login public user in your v6 environment.
But there is no “dbpublic” user defined in the downloaded Release 7 version of DesignBais.
The standard DesignBais Release 7 db.config does not have “dbpublic” as the loginpublicuser – you must have edited that in.
Yes DBINET.DEMO has a start form defined for user “dbnetuser”. The start form is DBCLIENT_DEMO from which you can navigate to DBIFORMS_DEVELOP (the tools menu).
If you replace “dbpublic” with “dbnetuser” you will be logged in to our DBINET.DEMO account.
Then use the Users option on the side menu to create “dbpublic”. Or copy this user from your v6 DBIUSERS file.
You may want to set up a qcode entry in the db.config:
<entryPoint qcode="public">
<loginHost>192.168.0.7</loginHost>
<loginHostType>UNIVERSE</loginHostType>
<loginAccount>YOUR_ACCOUNT_NAME</loginAccount>
<loginUser>dbnetuser</loginUser>
<loginPassword>dbnetuser</loginPassword>
<loginPublicUser>dbpublic</loginPublicUser>
<requestTimeoutSeconds>360</requestTimeoutSeconds>
</entryPoint>
Replace YOUR_ACCOUNT_NAME with the account name on your system. But you will need to migrate that account to Release 7 before it will function correctly in Rel 7.
loginUser
A Windows user login name
The login name used to establish communication with the DATACOMP regardless of the actual user login. Note that this user must also be created with the same password on the database server.
loginPassword
A password (must be longer than 3 characters)
Password for the loginUser
loginPublicUser
A user login name
When a DBNET is configured for anonymous access, loginPublicUser is passed to the DATACOMP as the logged on user. Note that this does not need to be a Windows user account but must be a DesignBais user and must have a default DesignBais form specified.
Bob
From: designba...@googlegroups.com [mailto:designba...@googlegroups.com] On Behalf Of Jay
Sent: Sunday, 27 January 2019 6:22 AM
To: DesignBais-Forum
Subject: Re: DBv7 setup
Hi Bob,
Thanks for responding! I haven't set up my account yet so I don't have a start form. Does the DesignBais initial install have a start form in the DBINET or DBINET.DEMO accounts?
Also, I was expecting a user login page like I had in DBv6. Does this mean that all users are entering the environment as dbpublic?
Jay
On Friday, January 25, 2019 at 5:52:20 PM UTC-5, Newstart wrote:Hi Jay,
The error message “Default login form not found” indicates the DesignBais has logged in and wants to go to the start form in the specified account, for the public user.
It can’t find the form.
So check your DBIUSERS record for the user and check that the start form in the start account is valid.
The user is “dbpublic” based on your db.config.
If you still have trouble let us know.
Bob Garrard
DesignBais
<?xml version="1.0" encoding="utf-8" ?>
<dbconfig>
<entryPoint qcode="">
<loginHost>127.0.0.1</loginHost>
<loginHostType>D3</loginHostType>
<loginAccount>DBINET.DEMO</loginAccount>
<loginUser>dbnetuser</loginUser>
<loginPassword>dbnetuser</loginPassword>
<loginPublicUser>dbpublic</loginPublicUser>
<requestTimeoutSeconds>60</requestTimeoutSeconds>
<debugUser>designbais</debugUser>
<enableXSSshield>true</enableXSSshield>
<allowDomainNamesInLoginNames>false</allowDomainNamesInLoginNames>
<convertLoginNamesToLowercase>true</convertLoginNamesToLowercase>
<enableDetailedErrorMessages>true</enableDetailedErrorMessages>
</entryPoint>
<connectionSpecs>
<connectionSpec type="D3" host="127.0.0.1" pooling="db" max="2"/>
</connectionSpecs>
</dbconfig>
From: designba...@googlegroups.com [mailto:designba...@googlegroups.com] On Behalf Of Jay
Sent: Saturday, 26 January 2019 9:08 AM
To: DesignBais-Forum
Subject: DBv7 setup
I am attempting to set up my first DesignBais v7 system using D3v10.2.2 as the database on Windows Server 2012 R2 Standard. The test programs all say successful website and database connectivity but my startup form displays this:
I suspect that the db.config (c:\inetpub\dbnet\admin\db.config) is not correct but I'm not sure what to look for. The file is attached. Is there a qcode/account that is required for DesignBais development environment?
I'm not sure what other info is need about this setup but I am running the website and the database on the same server.
Thanks
--
You received this message because you are subscribed to the Google Groups "DesignBais-Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to designbais-for...@googlegroups.com.
To post to this group, send email to designba...@googlegroups.com.
Visit this group at https://groups.google.com/group/designbais-forum.
For more options, visit https://groups.google.com/d/optout.--
You received this message because you are subscribed to the Google Groups "DesignBais-Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to designbais-for...@googlegroups.com.
To post to this group, send email to designba...@googlegroups.com.
Visit this group at https://groups.google.com/group/designbais-forum.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "DesignBais-Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
designbais-for...@googlegroups.com.
To post to this group, send email to
designba...@googlegroups.com.
Visit this group at https://groups.google.com/group/designbais-forum.
For more options, visit https://groups.google.com/d/optout.
Jay
To post to this group, send email to designb...@googlegroups.com.
Rick Weiser
Bulent Can
Jay
Do you want the IIS "Windows Integrated Authentication" or "Basic Authentication".
"Windows Integrated Authentication" is used if you're on a PC that is on the same network with the web server. In that mode you don't get a login prompt because you've already logged in to the network (when you logged in to your PC with a domain)
"Basic Authentication" is used when your PC is NOT on the same network with the web server. In this mode, you either create local Windows users on the web server OR in IIS, configure the basic authentication against a domain.
"Windows Integrated Authentication" is recommended for closed environments (no internet access, no public access etc.).
Basic authentication must not be used without SSL. It's also for closed environments.
Neither method is safe for public access websites.
In general for DesignBais we recommend form based authentication.
For your particular case, remove Windows Integrated Authentication and enable Basic Authentication from your website. This should prompt you for a login.
Bulent