Home | Advertising Info34 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Sunday, May 29, 2022  

Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds



Blog Entry: 3/25/2006 4:43:17 PM

What am i supposed to do now... i do have another member server that is not a domain controller-

 

However, i have like 5 websites running on this domain controller already. I have thought about this before how its a HUGE security risk but it will take too long to configure everything on the other computer :(

, Actually it is my own server (retired email server from my employer). I will check out the documentation again. I DID read that part, but didn't understand it enough. I'll dig deeper. Also my box has 2 CPU's, hence the $125 for ASPImage...,



Please Note : Users with the option pack a new feature called groups that is much more powerful than access levels.


More On Access Levels

Again, Examples of managing Access Levels are provided in the "multiple_access_levels" folder included in the root of the Password System. Look at the source code of the ASP pages in that folder with a text editor to see the working code.

Access Levels and how they work can be re-coded to work in many different ways. However, you have to be a good ASP developer to make changes to it. Here is some information on how they work by default and also info on an alternate scenario we have provided.


In the "check_user_inc.asp" that comes in the root of this system Access Levels works as follows.

Level 1 has Access to - Level 1
Level 2 has Access to - Level 1,2
Level 3 has Access to - Level 1,2,3
Level 4 has Access to - Level 1,2,3,4
Level 5 has Access to - Level 1,2,3,4,5
Level 6 has Access to - Level 1,2,3,4,5,6
Level 7 has Access to - Level 1,2,3,4,5,6,7
Level 8 has Access to - Level 1,2,3,4,5,6,7,8
ADMIN has Access to - Level 1,2,3,4,5,6,7,8,ADMIN

The "check_user_inc.asp" included in the "extras" directory is an example of changing the access level checking code
to work differently. In that "check_user_inc.asp" Access Levels works as follows.

Level 1 has Access to - Level 1
Level 2 has Access to - Level 2
Level 3 has Access to - Level 3
Level 4 has Access to - Level 4
Level 5 has Access to - Level 5
Level 6 has Access to - Level 6
Level 7 has Access to - Level 7
Level 8 has Access to - Level 8
ADMIN has Access to - Level 1,2,3,4,5,6,7,8,ADMIN

If you get creative you can create some interesting access level checking scenarios.


Here is some additional info..

If the access levels are too restrictive you can ignore them all together and create your own totally custom solutions.
Here is a quick rundown of some of the things you can do.

Ok... so if you want to be really specific about what each user can see and
can't .. here's an example of what you can do

Don't use the access levels before the include file..
Don't worry about what you set a user to in the admin area since the access levels won't be used.

Do something like this..

Every time a user logs in session variables are set that you can access at
any time.. thus allowing you to know who they are.

So you could do something like this...


<%@ LANGUAGE="VBSCRIPT" %>

<!--#INCLUDE FILE="check_user_inc.asp"-->

<%
If Session("USERNAME") = "bob1267" or Session("USERNAME") = "carl45" or Session("ADMIN") = "True" Then
Session("PASSWORDACCESS") = "Yes"
Else
Session("PASSWORDACCESS") = "No"
Response.Redirect(Request.ServerVariables("script_name"))
End If
%>


The following URL explains what Redirects are.
http://www.powerasp.com/content/code-snippets/redirects.asp

That would in effect create totally custom access levels.. but you would
have to do it manually for each user.

You can also do things like this after a person logs in

Show custom html to any specific user based on either their username or
access level ... like so

say there was a menu and a certain link should only show up to username
"paully67"

you could do something like this


<HTML>
<HEAD>
<TITLE></TITLE>
</HEAD>
<BODY>


<br>
<a href="main.asp">Home Page</a>

<%
If Session("USERNAME") = "paully67" Then
%>

<br>
<a href="paullys_page.asp">Pauls Stats Page</a>

<%
End If
%>

<br>
<a href="links.asp">Links Page</a>

</BODY>
</HTML>


Or you can show custom HTML or links based on Access Levels or any other info.

You can do just about anything with if-then statements and
using the built in vbscript functions..

Hopefully this info will help to give you some ideas...

Bottom line is you have to do some work within your site to make the Access Level system really come alive.

cwilliams38114.6506712963, Hi Chris,

I've got a page with a form that includes an input field with 'type="file"' for uploading an image.  The page posts back to itself to save the info to the database and run the code necessary to upload and resize the image.

I need to limit this page to a group.   So like usual, at the top of the page I put:
<% GROUPACCESS = "1" %>
<!--#INCLUDE FILE="../check_user_inc.asp"-->

This gives me the error: "Cannot call BinaryRead after using Request.Form collection"

I have used ASPUpload and SA-FileUP before and know that this is caused by the components having their own .form collection.  This script is using "Pure ASP File Upload" from DMXZone for the upload which I'm not familiar with. 

So...my question is, do you know a way around the BinaryRead problem wtih ASPProtect? 

Thanks,
Michelle

P.S. PLEASE don't send me to DMXZone for help....they've got notoriously bad support!

,

If I would like a link on my web page that will take someone to the login page (I would also like this page to contain forgot passord? and register)   I am not entirely clear what file to link to to do this.  Would it be check_user_inc.asp?

Thanks in advance?

 

cwilliams38456.0972106481, I have ASPPhotoGallery installed. Everything has been working great for some time. Suddenly, for no apparent reason, I am not getting the "Hits" incremented when a user opens an album. It works when an administrator is logged on. Does not for any anonymous users. Everything else seems to work fine. Again, this used to work. Any ideas. , the no concurrent login feature is based on IP addresses.. if you logged in again using the same IP address it would let you in regardless. So for example if you were behind a rhome router and logged in to a site on the internet it would nt matter if you had multiple computers at home because they would all have the same external IP address... etc etc

In other words it is tricky to correctly test..

I really need more detailed info on everything going on. I real world scenarios there are no issues with that feature that I know of. At least according to customers so far. ,

I really need more info on what you have going on?

This can sometimes be cause by a slow server / bad data connection.

Sometimes caused when someone is using the option pack but did not make the proper changes to the database.

Sometimes caused when a user adds users the database on his own and does some "incorrect" things..

The more details you can provide the better. Think of anything and everything and describe it.

SQL or MSACCESS... version of either
Server OS
Using Option Pack or not
Did you have your host set permissions...

etc etc etc

cwilliams38300.5380092593,

how you connecting... lets see the connection string...

could be permissions related too.. if they are not set correctly
(always give them to the folder, never just the mdb file)

Some of this might help...

http://support.cjwsoft.com/code/moreinfo11-1.htm

http://support.cjwsoft.com/code/moreinfo136-1.htm

http://support.cjwsoft.com/code/moreinfo56-1.htm

you may want to download some of the different versions of the access database from the support area and try connecting to them as you may have older odbc drivers on the server

You may also want to try to get ASPTest from our website working before you go any further

,

Thanks, I really appreciate you working on this. The software works GREAT and the support you give can't be beat. I will definately tell other that are looking for software for their sites to check your first.

 

one more question.

To use the bulk upload feature of aspuload, do I just need to add another upload section to the same upload page, that will allow more than one file to be selected then tell it to put the files in as Photo 1, 2, 3 etc.? I am a rookie at ASP but I think this is possible and with a little research I should be able to get it going.

Just want to make sure I am on the right track.

Thanks

,

The only major usability issue I've found to date is multi-zone banners. Cloning is helpful to a point, but then if you have a change to that banner, you have to make the change 6 times or what have you. I think, even at the expense of speed, multi-zone capability for a single banner would be excellent addition. Of course, that supposes I haven't just missed it and it's already there.

cwilliams38453.6665509259, I would like to delete the SQL tables and set them up from scratch using enterprise manager and sql query manager and see what happens

If that is ok with you let me know.

Something is wrong like I said...  almost seems like the database is caching old password info from the field., Its a great idea. I didnt really check the counter until the album started working. Its a great concept though., Oh, to clarify the above.  We did not change any columns in your [Users] database or any other table.,

Great Thank you!

As of thus far the program is working rather nicely.

I am very impressed :)

, I think I have successfully integrated Paypal but seem to have a slight issue. Once a person has entered the Paypal site but cancels their order, the ad is still placed on the site. The optimal way for my site to work would be to cancel the ad once the Paypal process has been cancelled. Any help would be great.

Thanks


, It is not something I did when I wrote the emailing sub routines. You would have to edit the email sub routine for CDONTS and add something to it most likely. The email sub routines are in the "scripts" folder in the "emailing_subs_inc.asp" file.

I am not sure you can do that when using CDONTS though I think you can do it with CDOSYS. You would have to do some research and edit the code like I mentioned.
,

also.. every once in a while I get some nervous person concerned about security... and the pros and cons of having parent paths enabled.

etc etc etc

 

so let me add this bit of info..

I don’t know what your hosting company will say because it is an iffy topic and those that understand it have a hard time explaining it to someone who doesn't. Also usually the hosting company doesn't have a clue except they heard it was a security risk.

Here is the low down from someone that really understands it...
(well, at least I think I do)

The only real security risks are from YOU and possibly other people hosting on the same server if they have parent paths enabled that is.

Meaning your site visitors can't possibly do anything with it unless of course you let them upload and run their own asp files to the server.

Anyway.. if YOU run malicious asp scripts you could potentially attack other sites on the server and look at things you shouldn't. As could other sites on the same server do to you I suppose.

So, unless you plan on doing that or some other site admin on the server does it to you its not really a concern. Just an advantage in coding abilities.

If you attack someone elses site on the server or lurk where you shouldnt then you are probably violating your hosting agreement.

99% of the time everyone gets all nervous over nothing.. half the people nervous about this have sites nobody would ever want to hack anyway.

Many people with a really important/busy sites are going to have a dedicated server somewhere so the setting is not relevant..

The hosting companies of course have to warn you.

This setting was enabled by default for years on IIS4-IIS5. I never once heard one single real story about anyone attacking anything because of this setting. That doesn't mean it doesn't happen but I am just telling you what I know.

This is all my opinion so take it for what it is...

If you are a Hosting Company your better off turning it on at the customers request, giving them a warning about it, and in turn having happy customers.

The big hosting companies like Alentus and MaximumASP do it...

There are far worse things than this to let people do after all.

Beleive it or not I have actually been in servers where they gave the anonymous webserver acount modify permissions EVERYWHERE yet they disabled parent paths ????

cwilliams38391.6024189815,

its one or the other... you cant protect upload.asp at the same time if upload.asp is included in another page..

I mean sure you can protect upload.asp from running when another page calls it by password protecting the page calling it.

And sure you can protect upload.asp by itself if it also runs all by itself. But you can not include the "check_user_inc.asp" more than once in any order of execution scenario. That includes pages being included.

Generally anytime a page is included in another that included page is not meant to run by itself and wouldn't produce any outcome if run by itself so this would never be an issue.

if you don't want "upload.asp" to ever be run by itself in that scenario put it somewhere in your web site that is not web browser accessible.

I would also suggest you look into using Virtual includes. It will save you a lot of time figuring out this sort of thing "../../../../../" becuase once you figure out the virtual include path you can use the same server side include from any directory level.

http://www.powerasp.com/content/code-snippets/includes.asp

 

,

OK, I updated the server with the SP 8 Jet updates and this had no effect.

Then I loaded the asptest file and put in the correct path. The results were:

Failed: Database could not be connected to....

Error reported from server:
Error source: Microsoft OLE DB Provider for ODBC Drivers
Error number: -2147467259
Error description: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x784 Thread 0x854 DBC 0x2101014 Jet'.

,

Hi,

I need to be able to add about 9 checkboxes to the register.asp. would I be able to use one of the custom fields?

The other thing is once I add the checkboxes the value must be written to the DB and later read when displaying the person's Album.

Any idea on how I can do this.

Thanks

 

,

Chris,

I've given the IUSR account modify access for the aspprotect folder.

In the ODBC manager module on the webserver I've taken out the aspprotect access driver option.

The dataconn_inc.asp line reads as

ConnectionString = "DBQ=D:\missourirealtor.org\members\aspprotect\data\database \ASPProtect_access2002.mdb;Driver={Microsoft Access Driver (*.mdb)};UID=Admin;Password=temp"

Now this should make it DNS-less correct? with the permissions set properly?

I've also taken out the password on the access database.

The original database of users I had was an access database from a different program called spooky login.  I exported them into a tab delimited file and changed the column headings to match those in aspprotect exactly.  Actually access would not let me import them in the databases without them being exact.

I imported that information directly using access's import options.  I tried the import/export manager in aspprotect but kept timing out as well.


 

,

I can no longer send e-mails to my configured accounts through aspbanner. It was working for over a year and now it stopped.

At one point I was using CDONTS_Installed but since I moved to a new Windows 2003 server I was told by my ISP that either one of these will work

but neither one works. Can some one assist?

JMAIL_Installed

ASPEMAIL_Installed

,

Your going to have a lot of problems and a lot of the code will have to be re-written.

There are a lot of things in the the code that the MYSQL database system does not support or has issues with . I know because I once made a version of ASPBanner work with MYSQL and it took weeks of work to get it stable.

Null field types can cause problems... but mostly ADO updates which I don't think MYSQL supports at all. All of the ADO stuff would have have to be rewritten.. etc etc

That's probably why you cant get much of the code to write to the database.


Here is a generic example.

An update to an existing record using ADO
http://www.powerasp.com/content/database/ado_update.asp

And update to an existing record using an update query.
http://www.powerasp.com/content/database/using_update.asp

All through the the code the ADO updates would have to converted to update queries which means a lot of work.

I used ADO a lot because I like it and it is little easier to validate data before it is written to the database.

It is also a little easier for customers to understand when they look at the code.


Anyway....

The app just was not designed to work with MYSQL.
It was specifically designed to work with MSSQL and MSACCESS only.

This holds true for all of our applications.

Your running off an IIS 5 Server so I would suggest just using MSACCESS as the database. The Photo Gallery app will run very well using MSACCESS. 

, we ended up resolving it...

the physical path being used was invalid,


IMPORTANT UPDATE - READ THIS
http://support.cjwsoft.com/forum/forum_posts.asp?TID=205& ;PN=1

The IPN Support Pack which is built in to ASPProtect 7 contains all the pre-built scripts you need to implement PayPal IPN with ASPProtect. IPN stands for (Instant Payment Notification). It allows you to set up scripts on your server so whenever a PayPal web accept order is processed the PayPal server sends info to your server regarding the transaction and vice versa. This is a fully automated process and allows you to charge users for access by the month or however long you like.

This Support Pack basically gives you an additional signup and registration directory "paypal_signup" and it should not interfere with any changes or customizations you have made to your ASPProtect setup in general. New users can register in this directory and pay for membership at the same time. Existing users whether active or expired can be sent to this directory where they can lookup their account and buy additional membership time online. You can also assign various Access and Group Levels during signup and you can set up various prices for various amounts of time as well. This is a real-time setup for the most part. As soon as a user pays via PayPal your system is updated and they will have access.

To use this all you need to do in ASPProtect 7 is enter your PayPal account name into the settings screen. It will be an email address. You'll need a business or premier account with PayPal and you will need log into your PayPal account and turn on IPN in you profile. They make you enter a default IPN URL. We do not use that so if you already have something there leave it there. If you dont have something there you can type in any the full url to any page on your server. It's probably best to send it to an empty ".asp" page or something.

Changing Payment Options

In the "paypal1.asp" file there are form options set up.

They look like this and you can have as many as you like.

<option selected value="30,9.95,3,">30 Days, 9.95</option>

In this option... A user has the option to purchase 30 days for $9.95 and he will be set to Access Level 3 when payment in completed.

Here is how it works.

The value setting (red) is essentially and array that can be made up 4 elements separated by comma's
They must be separated by a comma and there can be no spaces. In this example the 4th value was not used but the last comma must still be there. If you didn't want to set an access level and left out the "3" there would 2 commas at the end.  etc etc
Basically there must always be 3 commas but you only have to set the 1st 2 values which are days and price.

days,price,access level,groups

The 1st value is the amount of days.
The 2nd value is the price for the amount of days.
The 3rd value is the access level you want to user assigned to.
The 4th option is the groups you want the user assigned to. (see PayPal subscription thread for examples of specifying group info)

Now, the label for the option in (blue) can say whatever you like.

cwilliams38421.7143981481,

any asp code that accesses an access database, writes to text files, or allows for picture uploading will need permissions set on certain directories

every application out there is going to need permissions set at some point

its just a fact.. and if your hosting company does not give you a way to manage permissions or have it done when you ask they do not know what they are doing and they are not supporting your asp hosting needs

see my article for more info on the whole process
http://support.cjwsoft.com/code/moreinfo136-1.htm
the part newar the bottom talks about hosting companies

,

one thing to note... the time period we are talking about is going to to be whatever you have the session timeout set at in the settings.

perhaps making that value lower like 10 minutes is an option for you.. and might help to deal with situation

 

, sounds like the data/export folde does not have permissions, I am running into problems with the import function.  I have 25 photos loaded into the import folder.  The page see all of the photos.  But after I click on the import process it takes me Picture Manager with no pictures loaded.  I have hit the refresh button, but there is nothing there.  dr_bones38394.676412037, Ok, I tried what you suggested but the program won't let me leave the date area on the banner ad blank. I reset it to a date in 2010.

I deleted the Level 1 Access note in the notes area.

I then attempted to access the banner stats using the correct info and the right link.  Again,  got this message: 

ACCESS DENIED

INVALID Username & Password

Username HAS EXPIRED

Any ideas? Should I just delete the whole account and start fresh?

TIA,

Laura
,

ok.. Chris.. I am now kicking myself in the butt.  In the setting section, I had to redirect certain urls and directories to the right spot.  I forgot that I renamed the root folder. 

 

Thank you, thus far for your continued help.  It is greatly appreciate.

 

, also.. you could try chaning your connection string to set the current language to english like in this example..

BannerConnectionString = "Provider=sqloledb;Data Source=127.0.0.1;Initial Catalog=aspbanner;User Id=aspbanneruser;Password=temp;Current
Language=English
;"

I do not know if that actually works but from what I have been researching it looks valid and it may solve your problem.

Also: The value may need to be Current Language=us_english

You'll have to try them, I posted this in the wrong forum. Sorry.

I have installed ASPProtect on a client's website and I have been notified that some of their customers have been unable to login to the protected pages.

On testing it seems that the issues seem to be related to how cookies are being stored by IE 6.

ASPProtect is being used to protect particular template files within a Content Mangement System. 90% of the time it is working fine but on the odd occassion particular cutomers are unabe to login.

After quite a bit of testing I have managed to find the scenario in which it starts to have problems and was hoping you may be able to provide a solution.

If a customer enters the wrong password, then reenters the correct username and password, they receive a message "template can not be found" from the Content Management System. This message is generated when a url is entered that contains a link to a template file that does not exist. In this case the template does exist. If I remove the ASPProtect code the page opens without error.

Everytime they re-enter the details they receive the same message.

If they close down the browser and then reenter the correct details in some instances the page will open correctly.

More often than not, they have to delete cookies and temporary files and  close the browser. This seems to fix the problem again for most users. For users who's web access is heavily cached by an internal server, even this does not work.

Have you come across this problem before and can you suggest a remedy.

If you can email me privately I can give you the URL and access codes.

Thanks,

Stuart ,

Hi Chris,

 

Thank you for your prompt response.

Our current project requires alot of customization.

 

Yes, the error is probably a data problem and not due to your code, because we needed to make modifications to the database.  But that's why debugging would be helpful.

 

Basically our intent to modify the asp protect code stems from the fact that our client doesn’t want certain fields to be recorded or to appear: address, city, state, zip etc…

 

We are happy to be able to modify the HTML, but we also want to modify some other default behavior, such as which page opens when the "cancel" button is hit in the editaccountinfo.aspx page.

 

 

, ok, now were getting somewhere

I didn't know you imported from another system,

chances are you are missing field information that an ASPProtect user requires.

Start off from scratch with a new aspprotect database... create a new user and look at the info that gets entered by default for every field in the database

make sure when you import a user that you mimic it all

dont import directly using access because the passwords will not get converted to encrypted versions of themselves correctly.. and the whole process will be usesless as no passwords will be correct

Use the import feature built into ASPProtect.. because it is smart enough to take the clear text passwords and encrypt them accordingly

if you want to know a correctly formatted import file needs to look like make one and check it out

do one user at a time and make sure you can log in to an example protected page till you get it right...

once you get that working do them all

Thats really the best advice I can give you. , What application you talking about ? I'll assume ASPProtect. In the future please specify what application you are talking about.

ASPProtect 7 already has protection that is quite effective. The no concurrent login feature which will not let the same username under a different ip log in at the same time. Meaning if someone gives out their info they will screw themslves over because eventually they won't be able to log in. Only one unique ip at a time can log in so even of 100 people know the info it won't really do anyone much good except the lucky one that logged in 1st and stayed logged in.  The username/password will eventually become more and more useless as more and people know it.

In addition to that is is a good idea to monitor the daily logs and single out a user you see logging in a lot. The more ips you see for that user the more chance it is multiple people logging in and you should take action. , Well, I had no more trouble after I read the instructions.

The PayPal integration is really neat stuff! WOW!  And the email users function got up and running in a snap... this is an awesome package!

The coolest thing with the user registration is that the account username and password are selected by the user. That is very very nice. Much less typing for me to do.
,

Version 7 uses.. RC4

The upgrade process is described here in detail including a procedure to convert existing clear text passwords to the encrypted versions. (Your passwords will need to be clear text as the system shipped of course for the conversion to do its thing)

http://support.cjwsoft.com/code/info24.htm

It is also covered in the downloadbale docs
http://support.cjwsoft.com/code/moreinfo221-1.htm

Many people have done the upgrade without any issues and Version 7 is getting great feedback.

Should you decide to go with it there is upgrade pricing.
http://www.aspprotect.com/purchase_v7_upgrade_pricing.asp

, I just remembered the current skin is stored in a text file in the pictures folder. If it did not have permissions for writing it could give you trouble.  That could of had something to do with it.cwilliams38295.3821064815,


Timecard Entry: 3/25/2006 4:43:17 PM

Slowed down around 9., Manning NOC. Watching modems, resetting modems, setting up a couple of virtual domains. Mounting a new case., Email/Newsgroups/Voice Mail/Time Card, travel to clayton 60 miles, E-Mail, Voice-Mail, Packup, NO WORKORDER CREATED YET Expo at the State Office Building setup, Casey Lyons - Digital Junction, Called users regarding the 9200 numbers and new numbers that they can call., working on copying DNS records from NS1.imcnet.net to new DNS box and setting it up, 60 Miles : Watertown - Postdam, office work, email, phone conv. with Paul,beth, meet with Jim/Randy, customer followups, talk with Chris Palermo, Ron Garafalo, Meeting with Nic- go ovver web site problems with projects, Email/Newsgroups, teched phone calls and had clayton numbers were getting RNA, Very slow. Cleaned and kept eye on emonitor as it was going up and down all night, Expense report, Building IP Mgt database, Rebuild Workstation, Setting up budget spreadsheets, Manning NOC. Watching network. Checking and resetting open modems. Setting up printers for Don., USERS group meeting at JCC- returned to Clayton, made ethernet cable to patch server room fiber cisco into the network and tested IP connectivity in the co location room, Email and callbacks on expired accounts. A lot of cancels today (seasonal, Roadrunner), General tech duties., TIITC DB proj., email, voicemail, gen admin, call backs, *TaskForce, po's approved and sent to penguin and msi. s/w brandy at walker - referred to darrell., damn mcdonalds again.....whats wrong with going someplace healthy?, steady teching.,

   Active Server Pages Rule The World
Contact Us  
All artwork, design & content contained in this site are Copyright © 1998 - 2022 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
STATS Unless otherwise noted - All Rights Reserved.

Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspclassifieds.com, www.powerasp.com,www.cjwsoft.com,www.aspphotogallery.com,www.codewanker.com,www.aspprotect.com,www.aspbanner.com