Websecurity forgets who is who?

[mvaughn]

This morning the office could log in as usual. This afternoon they couldn't. Nothing changed in the interim.
"Login Information Incorrect"
I had to delete the websecurity files from my document root, republish them and exit and restart the server to get things rolling again.
Is it just me having these problems?

[lgrupido]

Re: Websecurity forgets who is who?

I've had Alpha do similar things to me, but it's pretty rare. Can't say that I have ever found out why. It hasn't happened to me in the last 6 months though.

My advice: worry about it if it keeps happening, but if that was the only time - it may never happen again.

Larry

[mvaughn]

Re: Websecurity forgets who is who?

Thanks Larry for the reply. This is an intermittent problem, but when it does happen I catch hell when they can't log in. I guess its just one of those things.

[Steve Wood]

Re: Websecurity forgets who is who?

Michael, this should never happen. You are using pre-release and this was reported by someone else using the same. Check your "stack" error log for statements about "too many tables open". Also, please mention in every single post, that you are using the pre-release so we don't confuse what the report is about.

[Peter.Greulich]

Re: Websecurity forgets who is who?

Yeah, what Steve said. If you read the pre-release notes you will see that there have been a bunch of security bugs introduced recently. Build 3044- 4041 is stable.

[Steve Wood]

Re: Websecurity forgets who is who?

Michael,

I don't know how possible it is for you, but I would definitely move OFF of the pre-release back to the official stable V11 patch. I have read enough, and had a few side conversations, to know you are going to continue to be in a bad spot. The problem with pre-release (as I have said before here) is that you are working ahead of things such as release notes, depreciated, removed or altered functions, etc. In this place, none of the normal Alpha "experts" are not going to be able to help, and the advice you get from others is going to be stabs in the dark. Under those conditions the only guys that can help are Alpha staff, and they are not as available as you might need. It basically is not a safe place to be for a live application. If you cannot go back, or don't want to, you are going to have to roll with the punches.

[Progytech]

Re: Websecurity forgets who is who?

Hi Michael,

As Steve mentioned here, I have this issue reported in another thread Fatal Server Error.
I am still need to do some test to verify that the issue has been resolved, but here is a summary of things that I did that could help with the situation:

1. The problem seems to be created by the AWS while generating reports it will create temporary DBF files which at some point will reach the limit of available table opened, this then will not allow your users to login if your Security Framework tables are in DBF format.
2. I covert my security framework to MS-SQL tables to free the AWS to use DBF file in memory for security operations.
3. Since there is no assurance that the AWS would not trigger that error, I make the decision to get the Report Server that will handle the generation of report in a much better fashion than the AWS itself.
4. Still I need to test the same scenario as before to see if these procedures will in fact avoid having the AWS to reach the limit of open tables while my end users are generating reports, this will happen at the end of the month, so I will keep you posted in the original thread Fatal Server Error.

[mvaughn]

Re: Websecurity forgets who is who?

Hi Edhy,
That makes perfect sense since I also am generating reports and have once a day login issues that mandate a server restart. I am not ready to give up 3184 yet because it fixes alot of bugs and the benefits outweigh the risks. I'll look into converting security over to MySQL because in theory it will be removed from the dbf tables. I have also seen Exceeded Maximum Tables before on report generation. I took pains to ensure in my code that only one table at a time would be open at any given moment and that seems to have alleviated that problem. It is my opinion that this web security issue should be given TOP PRIORITY and a patch issued promptly. After all, I'm having good luck with 3184 except for this one issue.

[Progytech]

Re: Websecurity forgets who is who?

Hi Michael,
Please do the following:

1. Upgrade to build 3186-4069 which have more security framework updates and it is the one I am using now.
2. Move security framework to SQL using the following instructions: http://alphadevnet.com/downloads/Usi...b_Security.pdf

I have also seen Exceeded Maximum Tables before on report generation. I took pains to ensure in my code that only one table at a time would be open at any given moment and that seems to have alleviated that problem.

I am convince, this is just a limitation of using DBF tables internally, so in reality unless you are using Alpha Link Tables, your MySQL or any other SQL database will not trigger this error, only DBF stuff.

If you need any help converting security framework, please let me know I will be glad to assist in any way I can, attached is the MS-SQL scripts which you can modify if needed to MySQL.

[mvaughn]

Re: Websecurity forgets who is who?

Thank you Edhy!
I will look into that tomorrow as I am working out code on another function. I and others thank you for your excellent help!

[Peter.Greulich]

Re: Websecurity forgets who is who?

I have also seen Exceeded Maximum Tables before on report generation. I took pains to ensure in my code that only one table at a time would be open at any given moment and that seems to have alleviated that problem.

That's strange. Never heard of such a thing. Maybe it is something in the pre-release? You can have dozens of dbf tables open at tone time. Never have seen a problem there before.

[Progytech]

Re: Websecurity forgets who is who?

Hi Peter,

You can have dozens of dbf tables open at tone time. Never have seen a problem there before.

This seems to be an issue with the way reports are being generated, and the numbers of reports being requested by users in a short period of time, at least that is what I have experienced with my first Alpha application with 20-40 users and just 2 reports they generate twice a month for billing purpose.

Peter, can you share with us some details of your application like:

• How many users?
• How many reports could be generated on a regular day?
• Where is the AWS hosted, and how much RAM?
• Are you using SQL database?
• How ofter do you re-start the AWS?

Here are some entries of my A5XbasicErrorStackLog file:

Wed Jan 16 22:33:03 2013
 Error loading C:\A5webroot\bci\bci.alb: Maximum open tables exceeded
Execution Stack:
0#1 evaluate_shared_private(           
0#22 OOhttpdServerClientMIME(ptemp,"AppServerMain")
0#2 A5WCallResult = evaluate_a5w_to_response(page_contents,Response,quote(" " + eval_settings.global.Request.SCRIPT_NAME),eval_settings,EVALUATE_A5W_TIMEOUT,RequestBundle.RequestInfo.Filename.Path)
0#307 a5w_report_saveAs(reportName,saveAs,filter,order,filename,global_variables(),printOptions,args,options)
==========================================================
Wed Jan 16 22:33:03 2013
 Error loading C:\A5webroot\bci\bci.alb: Maximum open tables exceeded
Execution Stack:
0#1 evaluate_shared_private(           
0#22 OOhttpdServerClientMIME(ptemp,"AppServerMain")
0#2 A5WCallResult = evaluate_a5w_to_response(page_contents,Response,quote(" " + eval_settings.global.Request.SCRIPT_NAME),eval_settings,EVALUATE_A5W_TIMEOUT,RequestBundle.RequestInfo.Filename.Path)
0#307 a5w_report_saveAs(reportName,saveAs,filter,order,filename,global_variables(),printOptions,args,options)
Wed Jan 16 22:33:03 2013
 Error loading C:\A5webroot\bci\bci.alb: Maximum open tables exceeded
Execution Stack:
0#1 evaluate_shared_private(           
0#22 OOhttpdServerClientMIME(ptemp,"AppServerMain")
0#2 A5WCallResult = evaluate_a5w_to_response(page_contents,Response,quote(" " + eval_settings.global.Request.SCRIPT_NAME),eval_settings,EVALUATE_A5W_TIMEOUT,RequestBundle.RequestInfo.Filename.Path)
0#307 a5w_report_saveAs(reportName,saveAs,filter,order,filename,global_variables(),printOptions,args,options)
==========================================================
Wed Jan 16 22:33:03 2013
 Error loading C:\A5webroot\bci\bci.alb: Maximum open tables exceeded
Execution Stack:
0#1 evaluate_shared_private(           
0#22 OOhttpdServerClientMIME(ptemp,"AppServerMain")
0#2 A5WCallResult = evaluate_a5w_to_response(page_contents,Response,quote(" " + eval_settings.global.Request.SCRIPT_NAME),eval_settings,EVALUATE_A5W_TIMEOUT,RequestBundle.RequestInfo.Filename.Path)
0#307 a5w_report_saveAs(reportName,saveAs,filter,order,filename,global_variables(),printOptions,args,options)
Wed Jan 16 22:33:03 2013

Thread: AppServerWorker9
Script: generic_layout_save_as
Line: 284
<br>Amyuni Low Level Print:<br>Layout name: DailyTheraphyLogNotes@C:\A5webroot\bci\bci.alb<br>Layout type: report<br>Error loading C:\A5webroot\bci\bci.alb: Maximum open tables exceeded
Execution Stack:
0#1 evaluate_shared_private(           
0#22 OOhttpdServerClientMIME(ptemp,"AppServerMain")
0#2 A5WCallResult = evaluate_a5w_to_response(page_contents,Response,quote(" " + eval_settings.global.Request.SCRIPT_NAME),eval_settings,EVALUATE_A5W_TIMEOUT,RequestBundle.RequestInfo.Filename.Path)
0#307 a5w_report_saveAs(reportName,saveAs,filter,order,filename,global_variables(),printOptions,args,options)
==========================================================
Wed Jan 16 22:33:03 2013

Thread: AppServerWorker9
Script: generic_layout_save_as
Line: 284
<br>Amyuni Low Level Print:<br>Layout name: DailyTheraphyLogNotes@C:\A5webroot\bci\bci.alb<br>Layout type: report<br>Error loading C:\A5webroot\bci\bci.alb: Maximum open tables exceeded
Execution Stack:
0#1 evaluate_shared_private(           
0#22 OOhttpdServerClientMIME(ptemp,"AppServerMain")
0#2 A5WCallResult = evaluate_a5w_to_response(page_contents,Response,quote(" " + eval_settings.global.Request.SCRIPT_NAME),eval_settings,EVALUATE_A5W_TIMEOUT,RequestBundle.RequestInfo.Filename.Path)
0#307 a5w_report_saveAs(reportName,saveAs,filter,order,filename,global_variables(),printOptions,args,options)
Wed Jan 16 22:33:03 2013
 <br>Amyuni Low Level Print:<br>Layout name: DailyTheraphyLogNotes@C:\A5webroot\bci\bci.alb<br>Layout type: report<br>Error loading C:\A5webroot\bci\bci.alb: Maximum open tables exceeded
Execution Stack:
0#1 evaluate_shared_private(           
0#22 OOhttpdServerClientMIME(ptemp,"AppServerMain")
0#2 A5WCallResult = evaluate_a5w_to_response(page_contents,Response,quote(" " + eval_settings.global.Request.SCRIPT_NAME),eval_settings,EVALUATE_A5W_TIMEOUT,RequestBundle.RequestInfo.Filename.Path)
0#307 a5w_report_saveAs(reportName,saveAs,filter,order,filename,global_variables(),printOptions,args,options)
==========================================================

[Mike Reed]

Re: Websecurity forgets who is who?

Here is the text to create the Web Security files in MySQL. You can use TOAD or some other product to execute statements.
In the example the tables are named 'websec_xxx', so if want something different just change that portion.

CREATE TABLE `websec_users` (
`guid` varchar(36) NOT NULL,
`Userid` varchar(100) NOT NULL,
`Password` varchar(60) DEFAULT NULL,
`RememberMe` tinyint(1) NOT NULL DEFAULT '0',
`RedirPage` varchar(60) DEFAULT NULL,
`PassEnt` datetime DEFAULT NULL,
`PassExp` datetime DEFAULT NULL,
`Email` varchar(100) DEFAULT NULL,
`SecQues` varchar(100) DEFAULT NULL,
`SecAns` varchar(60) DEFAULT NULL,
`UpdWeb` datetime DEFAULT NULL,
`UpdLocal` datetime DEFAULT NULL,
`Ulink` varchar(40) DEFAULT NULL,
PRIMARY KEY (`guid`),
KEY `Userid` (`Userid`),
KEY `Ulink` (`Ulink`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `websec_groups` (
`group_guid` varchar(36) NOT NULL,
`group_name` varchar(60) NOT NULL,
`UpdWeb` datetime DEFAULT NULL,
`UpdLocal` datetime DEFAULT NULL,
PRIMARY KEY (`group_guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `websec_members` (
`group_guid` varchar(36) NOT NULL,
`user_guid` varchar(36) NOT NULL,
`UpdWeb` datetime DEFAULT NULL,
`UpdLocal` datetime DEFAULT NULL,
PRIMARY KEY (`user_guid`,`group_guid`),
KEY `user_guid` (`user_guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `websec_expired` (
`user_Guid` varchar(36) NOT NULL,
`Password` varchar(60) NOT NULL,
`lastUsed` datetime NOT NULL,
PRIMARY KEY (`user_Guid`,`Password`),
KEY `user_Guid` (`user_Guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

mike

[mvaughn]

Re: Websecurity forgets who is who?

Thank you Mike.
I copied the above into a textfile named websecurity.sql and dragged and dropped it into Navicat and the tables were created flawlessly.



UPDATE: moving my web security to sql eliminated the Maximum Tables Exceeded error, and server reboots are no longer necessary. However, web security logging has ceased.

a5ws_login.log, in my project folder, remains empty. Can someone else verify this behavior?

A5v11 3202