Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Mysql ODBC 5.3 error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Mysql ODBC 5.3 error

 Post Reply Post Reply Page  12>
Author
BritBOT View Drop Down
Newbie
Newbie
Avatar

Joined: 05 October 2021
Location: TRNC
Status: Offline
Points: 19
Post Options Post Options   Thanks (0) Thanks(0)   Quote BritBOT Quote  Post ReplyReply Direct Link To This Post Topic: Mysql ODBC 5.3 error
    Posted: 19 October 2021 at 7:41am
Thanks for your help.


Edited by BritBOT - 19 October 2021 at 8:20am
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9700
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 12 October 2021 at 11:16am
You would parse the XML to get the CookieName, CookieKey, and CookieData. 

This would be used to set a cookie in the users web browser which can then be read by the forum to login the user.

You can then re-create the same cookie as the forum would create when someone logs in to the forum.

The CookieName would be the name of the cookie you create, the CookieKey will be the cookie key usually UID, and the Cookie Data is the data you set for the cookie.

If the cookie is set on the same domain as the forum then you don't need to worry about browser security as the forum will be able to read the cookie and use this to login the user.
Back to Top
BritBOT View Drop Down
Newbie
Newbie
Avatar

Joined: 05 October 2021
Location: TRNC
Status: Offline
Points: 19
Post Options Post Options   Thanks (0) Thanks(0)   Quote BritBOT Quote  Post ReplyReply Direct Link To This Post Posted: 12 October 2021 at 8:51am
Thanks, appreciate the advice but with all my sites using MySql, not going to change for this.

However, I am using the XML HTTP API and successfully parsing the response which gives the cookie.  My question is what do I do with that?  I can't see any documentation on how to use that to login. Presumably the cookie code needs to be redirected somewhere. Please advise.
Would it be possible for you to give me a code example please?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9700
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 11 October 2021 at 6:56pm
The existing member API is the easiest to use, but as ASP sessions only work within the same website/application pool you would need to find a way to have your website and forum run in the same website/application pool for it to work.

I highly recommend that you use SQL Server for the backend database which also supports 64-bit application pools. MySQL does not work very well as the backend database and we only maintain support for mySQL due to legacy reasons.

Regarding the XML HTTP API. This is intended to be used in backend server side code and should never be exposed client side.

If you are going to use the XML HTTP API you would need to write your own server side code that sends an XML request to the forums API, which then responds with an XML response that you would parse in your server side code.


Edited by WebWiz-Bruce - 12 October 2021 at 7:02am
Back to Top
BritBOT View Drop Down
Newbie
Newbie
Avatar

Joined: 05 October 2021
Location: TRNC
Status: Offline
Points: 19
Post Options Post Options   Thanks (0) Thanks(0)   Quote BritBOT Quote  Post ReplyReply Direct Link To This Post Posted: 11 October 2021 at 12:03pm
Yes, and because I have had to use ODBC 5.3 32 bit for your code, there has to be a different application as we established earlier. 

However, the httpAPI seems to require the admin name and password to be sent to it which exposes them, even if in hidden fields. Not good IMHO.
Even if I store them in a session variable, they would still be exposed.
Is there a way of automatically logging in without that?

Your demo does return a cookie, but I'm afraid I haven't seen anywhere yet that says how that might be used to login.

Apologies if this is repeated, I thought I had posted this before your forum went down.


Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9700
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 11 October 2021 at 9:07am
4. The Existing Membership API uses ASP Session which require both the website where the session variable are set and Web Wiz Forums are both in the same application pool.

If you are using different websites and/or application pools there is also the XML HTTP API that can work across websites, domains, and applications pools.

Back to Top
BritBOT View Drop Down
Newbie
Newbie
Avatar

Joined: 05 October 2021
Location: TRNC
Status: Offline
Points: 19
Post Options Post Options   Thanks (0) Thanks(0)   Quote BritBOT Quote  Post ReplyReply Direct Link To This Post Posted: 07 October 2021 at 3:46pm
Thanks for you help - much appreciated.

1. Solved
2. Tried a very long unique password and still showing insecure.  Looking at the code, I couldn't find anywhere that turned off the class="errorTable" in admn_menu.asp
3. Found the activation now thanks.  I had also found member_approve in tblsetupoptions and set that to true,  but only after adding a primary key to the table so it was not read only.  Actually will probably upload our current member list and then add them when they join the Society so they will be setup immediately.

Next, unfortunately
4. Tried many times to use the Existing Membership API, but even using the same tab to go from my login response to the forum which are both in the same domain, the session Id's are different, so it's not picking up the 3 session variables.  Could this be because it is a different application pool?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9700
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 06 October 2021 at 2:56pm
3. Yes you can enable vetting from the email section in the admin area. Once enabled the admins will need to vet new users to activate their accounts.

You can also use the forum permissions system so new users only have access to certain forums, read-only access to some forums but not others, or forums that are hidden to all but selected groups.
Back to Top
 Post Reply Post Reply Page  12>
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.


Become a Fan on Facebook Follow us on Twitter Connect with us on LinkedIn Community Forums Web Wiz Blogs Web Wiz News
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2021 Web Wiz Ltd. All rights reserved.