Shimoda
  •  Shimoda
  • 53% (Neutral)
  • YAF Forumling Topic Starter
2016-09-05T15:05:10Z
I installed YAF on localhost with IIS on Windows 10 and SQL Server Express 2015.
No problems.

Now I'm trying to install it on Azure (with the relative web.config),
but I have problems with the tables that are created on the database.

The following tables are not created:
yaf_prov_Application
yaf_prov_Membership
yaf_prov_Profile
yaf_prov_Role
yaf_prov_RoleMembership

Instead, the following are created:
aspnet_Applications
aspnet_Membership
aspnet_Profile
aspnet_Roles
aspnet_SchemaVersions
aspnet_Users
aspnet_UsersInRoles

And, obviously, the subsequent task: "Create New Board", fails.

Any insight on this issue?

Thank you
Sponsor
tha_watcha
2016-09-06T06:09:45Z
What error messages are you getting?

Which tables are created is based on which Role & Membership Provider you use. Normally Yaf uses its own Providers but for azure the default and old ASP.NET Providers are used.
UserPostedImage
Shimoda
  •  Shimoda
  • 53% (Neutral)
  • YAF Forumling Topic Starter
2016-09-06T07:35:23Z
Originally Posted by: tha_watcha 

What error messages are you getting?

Which tables are created is based on which Role & Membership Provider you use. Normally Yaf uses its own Providers but for azure the default and old ASP.NET Providers are used.



No errors, it simply creates the wrong tables.
At the followng screen, when it asks basic info about forum and admin user, it fails saying that there is no table yaf_prov_Membership.

I tried as with the raccomended.config as with raccomanded-azure.config.

Thank you
Shimoda
  •  Shimoda
  • 53% (Neutral)
  • YAF Forumling Topic Starter
2016-09-07T12:24:45Z
I find out that in the install dir, the scripts for mssql table generation create the aspnet tables.
So, why the forum is not aware to use those tables after creating them?
tha_watcha
2016-09-10T12:12:10Z
The installation under Azure for YAF is a complete new installation correct?

Quote:

At the followng screen, when it asks basic info about forum and admin user, it fails saying that there is no table yaf_prov_Membership.



Can you paste here the complete error message?
UserPostedImage
Shimoda
  •  Shimoda
  • 53% (Neutral)
  • YAF Forumling Topic Starter
2016-09-10T14:04:34Z
Yes it was a new installation.

I solved by setting isAzureEngine to false in

private void ExecuteInstallScripts(bool isAzureEngine)
{
// Install Membership Scripts
if (isAzureEngine)
{
this.DbAccess.Information.AzureScripts.ForEach(script => this.ExecuteScript(script, true));
}
else
{
this.DbAccess.Information.YAFProviderInstallScripts.ForEach(script => this.ExecuteScript(script, true));
}

// Run other
this.DbAccess.Information.InstallScripts.ForEach(script => this.ExecuteScript(script, true));
}

in InstallUpgradeService.cs
and than installing the forum running from the code in VS.
After that, the version installed on the website run.

Anyway i woudn't want to keep sources... i'd prefer to have only the compiled version...
even to do not have to tweak the code at every update...
I'd be glad if you fix these.

thank you

PS: Why two different providers for Azure and non-Azure?
I have no problem using the default provider on Azure, besides those descripted...
tha_watcha
2016-09-10T15:41:57Z
There exist some problems with the yaf providers in azure. Any chance you can send the full error message so i have a chance to fix the issue?
UserPostedImage
Shimoda
  •  Shimoda
  • 53% (Neutral)
  • YAF Forumling Topic Starter
2016-09-10T16:12:08Z
i will have to create a new db on Azure and retry the default insatallation.
But that's ok, if i can, i will do :-)
Not before Monday, anyway.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved