Can't connect to FTP Server and getting log error

rated by 0 users
Not Answered This post has 0 verified answers | 7 Replies | 2 Followers

Top 500 Contributor
48 Posts
Points 675
dvanbrunt posted on Tue, Mar 28 2006 9:56 PM
I'm getting a strange error in my FTP logs and I haven't been able to connect.
I just updated CS from 1.1 to 2.0 and installed FTP server 2.0

2006-03-28 21:07:06,272 [6060] ERROR [] - Exception occurred in Server.ThreadPool_WaitCallback
Exception: System.Data.SqlClient.SqlException
Message: Procedure 'aspnet_Membership_GetPasswordWithFormat' expects parameter '@UpdateLastLoginActivityDate', which was not supplied.
Source: .Net SqlClient Data Provider
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.ScalableHosting.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved)
   at Microsoft.ScalableHosting.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat)
   at Microsoft.ScalableHosting.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved)
   at Microsoft.ScalableHosting.Security.SqlMembershipProvider.ValidateUser(String username, String password)
   at Microsoft.ScalableHosting.Security.Membership.ValidateUser(String username, String password)
   at CommunityServer.FtpServer.Components.FtpContext.ValidateUser(String password)
   at CommunityServer.FtpServer.Components.CommandProcessor.?(FtpContext , String[] )
   at CommunityServer.FtpServer.Components.CommandProcessor.?(FtpContext , String[] )
   at CommunityServer.FtpServer.Components.CommandProcessor.ProcessCommand(FtpContext context, String command)
   at CommunityServer.FtpServer.Components.Server.?(Object )

Any Ideas?

----------
Thanks,
Dan
----------- Thanks, Dan
  • | Post Points: 20

All Replies

Top 10 Contributor
5,237 Posts
Points 48,205
CS Developers

What changes have you made to your site recently?  Are you using ASP.NET 2.0?  Using it with DNN?

Basically, it looks like you might have overwritten the MemberRoles tables/stored procedures with the ASP.NET 2.0 Membership ones.  They are essentially the same thing, but their schema differs slightly.

  • | Post Points: 35
Top 500 Contributor
48 Posts
Points 675
dvanbrunt replied on Thu, Mar 30 2006 4:28 PM
My CS site was originally CS 1.1 runing on ASP.NET 1.1.
This implementation is the only app in its DB. I have not merged DNN with it so we are only talking CS 2.0 here.
After upgrading CS 1.1 to CS 2.0 and ASP.NET 1.1 to ASP.NET 2.0 the site worked fine.
I then installed the FTP Server 2.0 which has never connected.
The above error is the one I find many times in the FTP error logs.
The CS 2.0 "site" seems to run completely normal.
However, FTP login and that above error seems to be my only issue.

If indeed I did acidentally overwrite the MemberRoles tables/stored procedures with the ASP.NET 2.0 Membership ones, how can I be sure and how can I correct the issue if that is the case?

Thanks,
Dan


----------- Thanks, Dan
  • | Post Points: 5
Top 10 Contributor
2,423 Posts
Points 19,605
MVPs
Nick replied on Wed, May 3 2006 9:19 AM
ken, I get this error since I updated my CS to ASP.net 2.0, is there a release for ASP.net 2.0??
  • | Post Points: 20
Top 10 Contributor
5,237 Posts
Points 48,205
CS Developers
How did you go about getting CS 2.0 running on ASP.NET 2.0?  Did you use the "Community Server v2.0 (Web Install) - ASP.NET 2.0" download from our site or not?
  • | Post Points: 20
Top 500 Contributor
48 Posts
Points 675
dvanbrunt replied on Thu, May 11 2006 9:22 PM
I set it up using this:<br>
http://communityserver.org/files/folders/releases/entry519767.aspx<br><br>
However, I'm not sure if the "updated" version was out then.....I may have DLed the one that was missing some dlls :(  Is there any way to tell which version I have?

----------- Thanks, Dan
  • | Post Points: 5
Top 500 Contributor
48 Posts
Points 675
dvanbrunt replied on Thu, May 11 2006 10:12 PM
Just updated to the lastest from
http://communityserver.org/files/folders/releases/entry519767.aspx

still get that same error

Exception occurred in Server.ThreadPool_WaitCallback
Exception: System.Data.SqlClient.SqlException
Message: Procedure 'aspnet_Membership_GetPasswordWithFormat' expects parameter '@UpdateLastLoginActivityDate', which was not supplied.
Source: .Net SqlClient Data Provider
----------- Thanks, Dan
  • | Post Points: 20
Top 10 Contributor
5,237 Posts
Points 48,205
CS Developers
You are probably getting the error because the ASP.NET 2.0 build of CS is using the built in .NET 2.0 Membership providers, while the add-ons use the MemberRoles version of the Membership provider, which has a few schema differences.  I will have to look into changing it to use the built in 2.0 providers, as I am not 100% sure if an application built in v1.1 but running on a mahine with v2.0 can load v2.0 assemblies.
  • | Post Points: 5
Page 1 of 1 (8 items) | RSS
Powered by Community Server (Commercial Edition), by Telligent Systems

Copyright© 2008 Telligent Systems Inc. All rights reserved
CommunityServer.com  •  Telligent.com