|
Group: StrataFrame Users
Posts: 84,
Visits: 835
|
Thanks Trent, but still nothing. I keep on getting the same error, and I've tried every permutation of connection strings, port 80, port 443, using SQLServer Authentication and not. Tried various connection strings. Tried with and without datasource keys. I've restarted IIS a gazillion times, I rebooted the server, kicked the server, yelled at it. I reinstalled Strataframe on my side and ES on the server side ( BTW I'm using the latest Beta version). Below is debug information on one of the attempts: | 1 | | 2009-03-07 01:29:22.750 | | General Command Settings | | Text | | System.Data.SqlClient.SqlCommand | | http://www.aeswebaccess.com:80/aes/es/RemoteDataSource.ashx | | False | | Command Settings | | Select st_email from pws_Statements where st_key = '1ab' | | Command Parameters | | No parameters are defined |
below is what shows on status.aspx | Server Name (site name): | Development SDK | | Registered Name: | Marcel Heitlager | | Registered Company: | Advanced Education Services, Inc. | | Serial Number: | [my serial number] | | Server Hostname: | www.aeswebaccess.com/aes/es | | License Expiration Date: | 2/9/2010 | | Allowed Clients: | 2 | | Allowed Hosts to Status.aspx: | 127.0.0.1 / 10.12.14.0 - 10.12.14.255 / 63.127.169.0 - 63.127.169.255 | | Serialization Type: | Standard |
| SMTP Settings |
|---|
| SMTP Server & Port: | 10.12.14.16:25 | | Email From Address: | es@aeswebaccess.com | | Email To Addresses: | heitlager@mindspring.com
| | SMTP Auth | No |
|
| Data Sources |
|---|
| (SqlDataSourceItem) |
|---|
| DataSourceKey: | | | Type: | MicroFour.StrataFrame.Data.SqlDataSourceItem | | Assembly: | MicroFour StrataFrame Base, Version=1.6.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7 | | Connection String: | Data Source=AESWEBACCESS\SQLEXPRESS;Initial Catalog=Test_PPMEmailService; User Id=myID; Password=myPassword; | | Is Encrypted: | Yes | | Encryption Key: | {default numbers } | | Encryption IV: | {default numbers} | | Is Compressed: | Yes | | Transaction Timeout: | 1h 0m 0s |
|
| Recognized Client List |
|---|
| It shows 1 client has connected |
I'm beginning to wonder if it has to do with where the web service is located. www.aeswebaccess.com root directory does not use secure socket layer. Everything under the /aes directory requires 128 bit ssl encryption except the /aes/es directory in which I set the do not require ssl option. When I had it set on it wouldn't even connect to the ES on port 443 (port 80 of course returned an access denied error). It would just time out. After turning it off I can connect to port 80 but I then get the error in my previous post. I wonder if I need to try moving the ES server to the root like www.aeswebaccess.com/es, unless you might have another idea. The bad thing is, I thought this would be the easy part, and I've been stuck on it for 2 days now. Oh well. 
|
|
Group: StrataFrame Users
Posts: 84,
Visits: 835
|
OK I've tried some other things. Tried to add a new record with the following debug info: | 1 | | 2009-03-07 21:54:41.93 | | General Command Settings | | Text | | System.Data.SqlClient.SqlCommand | | http://www.aeswebaccess.com:80/aes/es/RemoteDataSource.ashx | | False | | Command Settings | | INSERT INTO [dbo].[pws_Statements] ([st_Key], [st_StudentFullName], [st_PmtDueDate], [st_Email], [st_AmountDue], [st_Message]) VALUES (@st_Key, @st_StudentFullName, @st_PmtDueDate, @st_Email, @st_AmountDue, @st_Message); | | Command Parameters | | '123411' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: st_Key | SourceVersion: Current] | | '' [DbType: AnsiString | Size: 52 | Direction: Input | SourceColumn: st_StudentFullName | SourceVersion: Current] | | '1/1/1800 12:00:00 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: st_PmtDueDate | SourceVersion: Current] | | 'heitlager@mindspring.com' [DbType: AnsiString | Size: 52 | Direction: Input | SourceColumn: st_Email | SourceVersion: Current] | | '0' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: st_AmountDue | SourceVersion: Current] | | '' [DbType: AnsiString | Size: 102 | Direction: Input | SourceColumn: st_Message | SourceVersion: Current] |
Then I created a vfp database, and tried to go that route. The datasource.config is as follows: <DataSources> <DataSource DataSourceKey="Test1"> <ConnectionString>Provider=VFPOLEDB.1;Data Source="E:\Inetpub\wwwroot\aeswebaccess.com\aes\somedir\dir2\test_PPMEmailService.dbc"</ConnectionString> <TypeFullName>MicroFour.StrataFrame.Data.VfpDataSourceItem</TypeFullName> <TypeAssemblyName>MicroFour StrataFrame Base</TypeAssemblyName> <TypeAssemblyVersion>1.6.0.0</TypeAssemblyVersion> <TypeAssemblyCulture>neutral</TypeAssemblyCulture> <TypeAssemblyPublicToken>99fe9917f71608a7</TypeAssemblyPublicToken> <IsEncrypted>True</IsEncrypted> <IsCompressed>True</IsCompressed> <EncryptionKey>1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4</EncryptionKey> <EncryptionVector>1,2,3,4,5,6,7,8</EncryptionVector> <TransactionTimeout>3600</TransactionTimeout> </DataSource> </DataSources> Could there be a problem with the connection string syntax? Appmain looks like this: Dim ds As New EnterpriseDataSourceItem("testClient", _
"www.aeswebaccess.com/aes/es",80,"Test1", _
New VfpDataSourceItem("testClient"))'-- Configure the compression and encryption (optional)
ds.IsCompressed = True
ds.IsEncrypted = True
ds.EncryptionKey = New Byte() {1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, 4}
ds.EncryptionVector = New Byte() {1, 2, 3, 4, 5, 6, 7, 8}'-- Add the EnterpriseDataSourceItem
DataLayer.DataSources.Add(ds)
And again the result is the same (internal server error [500]. Debug is as follows: | 2 | | 2009-03-07 22:56:31.609 | | General Command Settings | | Text | | System.Data.OleDb.OleDbCommand | | http://www.aeswebaccess.com:80/aes/es/RemoteDataSource.ashx | | False | | Command Settings | | INSERT INTO pws_statements (st_key, st_studentfullname, st_pmtduedate, st_email, st_amountdue, st_message) VALUES (?, ?, ?, ?, ?, ?); | | Command Parameters | | '123411' [DbType: AnsiString | Size: 18 | Direction: Input | SourceColumn: st_key | SourceVersion: Current] | | '' [DbType: AnsiString | Size: 50 | Direction: Input | SourceColumn: st_studentfullname | SourceVersion: Current] | | '1/1/1800 12:00:00 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: st_pmtduedate | SourceVersion: Current] | | 'heitlager@mindspring.com' [DbType: AnsiString | Size: 50 | Direction: Input | SourceColumn: st_email | SourceVersion: Current] | | '0' [DbType: Double | Size: 0 | Direction: Input | SourceColumn: st_amountdue | SourceVersion: Current] | | '' [DbType: AnsiString | Size: 254 | Direction: Input | SourceColumn: st_message | SourceVersion: Current] |
Could it be a permission setting? The problem is I have another asp.net site running in aes/onepay directory (es is in aes/es) without a proble. Now the web.config contains the <authentication mode="Windows" /> line, but the web.config for the other site is the same. I apologize for the lengthy emails, I'm just trying to eliminate possibilities. Thanks, Marcel
|
|
Group: Forum Members
Posts: 2K,
Visits: 6.6K
|
I think this one got missed...bump.
|
|
Group: StrataFrame Developers
Posts: 3K,
Visits: 2.5K
|
Do you have an SMTP server that you can configure within the web.config file for the ES? Whenever the ES returns an error 500, it's because it has thrown an unexpected exception. The error handler within the ES catches those exceptions and emails the exception details to the address configured within the web.config. Make sure that's configured, then try it again, and let me know what the exception says when it gets emailed to you.
|
|
Group: StrataFrame Users
Posts: 84,
Visits: 835
|
OK, Got the smtp server working. Sent me the following message:
Enterprise Server Error | Message: | This server is not licensed to run on the requested hostname. | Client IP: | 75.104.220.239 | Details: | Exception
This server is not licensed to run on the requested hostname.
Source : MicroFour StrataFrame Enterprise Server
Stack Trace:
at MicroFour.StrataFrame.Enterprise.Server.RemoteDataSource.ᜀ(String A_0)
at MicroFour.StrataFrame.Enterprise.Server.RemoteDataSource.ProcessRequest(HttpContext context) |
|
On my end, the application is located at www.aeswebaccess.com/aes/es. IIS shows the application name as es. I registered the ES with you as www.aeswebaccess.com/aes/es. So, what did I do wrong? Thanks, Marcel
|
|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
|
That is the problem. I have reset your account. Set the hostname as www.aeswebaccess.com and try again.
|
|
Group: StrataFrame Users
Posts: 84,
Visits: 835
|
OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOh!!! So you mean to say that trying to solve the S&L, Mortgage, Banking, Detroit, Job, Economic, Iraq, Iran, Afghanistan, Pakistan, and Uncle Stan crisis was redundant. All I needed to do was type www.aeswebaccess.com and that would have been enough. You were right. It works now! So next time, if anyone gets an error 500 or timeout, the first thing to do is check to see if you're even connecting to the server by checking status.aspx. Then if you're running make sure your smtp server is up. BTW - I wasn't getting any email messages because when I later checked the Event Viewer it said the mailbox wasn't available. Make sure that the SMTP server allows relay messages from the localhost. That allowed ES to send the email through, so I could receive the telltale error report. (Of course everyone else allready knew that) Thanks for the help guys, Marcel
|
|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
|
Glad you got it going!
|
|
Group: StrataFrame Users
Posts: 81,
Visits: 270
|
I have the same timeout problem. Could you please reset my account so that I can change my hostname?
Thanks
|
|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
|
Done. You should be good to go. 
|