YAFLogo

sewi
  • sewi
  • 56% (Neutral)
  • YAF Forumling Topic Starter
16 years ago
Hello all,

i have a problem when i want to create the admin user.

Its a new installation and i think it works cause i set the forum passwort and the next step is the forum name and the admin user data.

When i click the "next" button i always get a messagebox with the following merror:

Create Admin User Failed: The password provided is invalid. Please enter a valid password value.

EventLog:

Source: Failure Initializing User/Page

Description:

System.ApplicationException: Sql Exception with error number 50000 (Tries=0) ---> System.Data.SqlClient.SqlException: Found 0 possible guest users. There should be one and only one user marked as guest.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

at YAF.Classes.Data.DBAccess.GetDatasetBasic(SqlCommand cmd, Boolean transaction)

at YAF.Classes.Data.DBAccess.GetData(SqlCommand cmd, Boolean transaction)

at YAF.Classes.Data.DB.pageload(Object sessionID, Object boardID, Object userKey, Object ip, Object location, Object browser, Object platform, Object categoryID, Object forumID, Object topicID, Object messageID, Object donttrack)

--- End of inner exception stack trace ---

at YAF.Classes.Data.DB.pageload(Object sessionID, Object boardID, Object userKey, Object ip, Object location, Object browser, Object platform, Object categoryID, Object forumID, Object topicID, Object messageID, Object donttrack)

at YAF.Classes.Utils.YafContext.InitUserAndPage()

i don't know what to do - i tried to run it in the iis-root - also in a subfolder - every time same error.

any idea :cry:

thx

Sponsor
jshepler
16 years ago

Create Admin User Failed: The password provided is invalid. Please enter a valid password value.

sewi wrote:

Make sure you're meeting all the password requirements. Check for stuff like min number of characters, if you have to have a non-alpha character (e.g. # or ! or _ or $), have to mix letters and numbers, that kind of thing.

EventLog:

Source: Failure Initializing User/Page

sewi wrote:

Description:

System.ApplicationException: Sql Exception with error number 50000 (Tries=0) ---> System.Data.SqlClient.SqlException: Found 0 possible guest users. There should be one and only one user marked as guest.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

at YAF.Classes.Data.DBAccess.GetDatasetBasic(SqlCommand cmd, Boolean transaction)

at YAF.Classes.Data.DBAccess.GetData(SqlCommand cmd, Boolean transaction)

at YAF.Classes.Data.DB.pageload(Object sessionID, Object boardID, Object userKey, Object ip, Object location, Object browser, Object platform, Object categoryID, Object forumID, Object topicID, Object messageID, Object donttrack)

--- End of inner exception stack trace ---

at YAF.Classes.Data.DB.pageload(Object sessionID, Object boardID, Object userKey, Object ip, Object location, Object browser, Object platform, Object categoryID, Object forumID, Object topicID, Object messageID, Object donttrack)

at YAF.Classes.Utils.YafContext.InitUserAndPage()

This is a different error. This error is saying you don't have a guest user, which is required. The install script should have made one. Were there any other errors during installation?


not jsheLPer

sewi
  • sewi
  • 56% (Neutral)
  • YAF Forumling Topic Starter
16 years ago
ok i startet again with a new installation an now it works - but when i click "next" to save admin and configuration i get following:

There has been a serious error loading the forum. No further information is available.

Please contact the administrator if this message persists.

nothing in the event log...

sewi
  • sewi
  • 56% (Neutral)
  • YAF Forumling Topic Starter
16 years ago
i dont think its a db-permission problem cause i had events in the log and the tables where created, but i think the admin user isnt stored in the db.

it should be in the yaf_user - shouldn't it?

what could be wrong with file-permissions? i configured it (running in sub-dir) using the install instructions.

*edit*

now i get an entry in the eventlog:

System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)

--- End of inner exception stack trace ---

at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)

at System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install)

at System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString)

at System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString)

at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation)

at System.Web.Security.SqlMembershipProvider.GetUser(String username, Boolean userIsOnline)

at System.Web.Security.Membership.GetUser()

at YAF.Classes.Utils.YafContext.InitUserAndPage()

but how could this be - tables where created, an log entry was written? why unable connect to db???

imukai
  • imukai
  • 100% (Exalted)
  • YAF Commander
16 years ago
It's likely an error trying to write to the config file - I had a similar problem. Either add the config password manually to the config file, or turn on errors so that you can see the full .NET error screen rather than the friendly error page that you quoted.
sewi
  • sewi
  • 56% (Neutral)
  • YAF Forumling Topic Starter
16 years ago
error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

my connectionstring:

<add name="yafnet" connectionString="server=***; database=***; user id=***; password=***; trusted_connection=false"/>

remote connections are enabled

imukai
  • imukai
  • 100% (Exalted)
  • YAF Commander
16 years ago
I suppose the obvious question would be.. can your web server communicate with where you have SQL installed?

Can you describe your setup?

sewi
  • sewi
  • 56% (Neutral)
  • YAF Forumling Topic Starter
16 years ago
i have access otherwise tables couldn't be created.

but is it possible there's a right that has to be set?

its not the first time i configure a sql server but now im not sure this is a bug in yaf

Elrinth
  • Elrinth
  • 55.4% (Neutral)
  • YAF Forumling
15 years ago
http://wiki.yetanotherforum.net/Installation%20Instructions.ashx 

I renamed: /webconfigs/recommended-web.config to web.config and copied to root. edited db.config and mail.config to reflect what I wanted.

This is the first time I ever install an ASP.NET forum. I previously only fiddled with PHP forums.

Everything went nicely during the setup until I reached the create admin user section where it wouldn't accept "test" as password. Is there anywhere in the config I can set regex for requirements for password because it's requirements right now is pretty sick. Not even 8 letters with 1 uppercase and three numbers were accepted. In the installation process, it's not clear what type of password you are required to input, I suggest changing the password complaint text so the user is informed on what characters are allowed and what kind of requirements there are.

At first I was just typing in a password which wasn't okay. But then I added a . (i think it's very weird I needed to have a . in my password)

Anyways, once that was done I got:

There has been a serious error loading the forum. No further information is available.

Please contact the administrator if this message persists.

in red. from the url: http://localhost:4678/Error.aspx?aspxerrorpath=/default.aspx

So... What exactly can be wrong? :shock:

I browse the db in mssql server management studio 2008 and I see that the admin user was indeed created. There's also a guest user there.

I look in event log and see following:

Exception type: NullReferenceException

Exception message: The object reference wasn't an instance of an object

Information of request:

URL: http://localhost:4678/default.aspx

Host computer address for user: 127.0.0.1

Is authentiscated: False

Thread information:

Thread-ID: 8

Is personified: False

Stack trace: at YAF.Classes.Utils.YafBoardSettings.get_Name()

at YAF.Classes.Base.ForumPage.GeneratePageTitle()

at YAF.Classes.Base.ForumPage.ForumPage_Load(Object sender, EventArgs e)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnLoad(EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

In the database I can see in the dbo.yaf_Board:

BoardID Name AllowThreaded MembershipAppName RolesAppName

1 test_forum 0

From sourceforge I am using:

YAF-v1.9.3-FINAL-BIN-NET20.zip

It is important I'm using .NET Framework 2.0, because I can't really know if the client will have anything above that. (3.5)

So I can't really just take the 1.9.4 src beta and use that.

Elrinth
  • Elrinth
  • 55.4% (Neutral)
  • YAF Forumling
15 years ago
bump... please help me with this issue. this will decide if I'll recommend your board or not.

Edit: Okay.. Now it magically started working.. Keep in mind, I haven't done ANYTHING.

However, when I create a new board I get:

Violation of UNIQUE KEY constraint 'IX_yaf_Forum'. Cannot insert duplicate key in object 'yaf_Forum'.

INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_yaf_ForumAccess_yaf_Forum'. The conflict occurred in database 'yet_another_forum_test', table 'yaf_Forum', column 'ForumID'.

INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_yaf_ForumAccess_yaf_Forum'. The conflict occurred in database 'yet_another_forum_test', table 'yaf_Forum', column 'ForumID'.

INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_yaf_ForumAccess_yaf_Forum'. The conflict occurred in database 'yet_another_forum_test', table 'yaf_Forum', column 'ForumID'.

The statement has been terminated.

So I insert one directly via SQL Management Studio 2008 and it works :D

So I have one board with id 1 and the newly created one got 4.

I'm guessing the two tries I did before made the newly created one become 4.

logan
  • logan
  • 100% (Exalted)
  • YAF Leader
15 years ago
delete the test forum from the first board then try again
test
Elrinth
  • Elrinth
  • 55.4% (Neutral)
  • YAF Forumling
15 years ago

delete the test forum from the first board then try again

logan wrote:

Deleting via YetAnotherForum.NET admin gave me following error:

"There has been a serious error loading the forum. No further information is available.

Please contact the administrator if this message persists. "

Win log says:

"Undantagsmeddelande: DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_yaf_Active_yaf_User'. The conflict occurred in database 'yet_another_forum_test', table 'yaf_Active', column 'UserID'.

DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_yaf_User_yaf_Rank'. The conflict occurred in database 'yet_another_forum_test', table 'yaf_User', column 'RankID'.

DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_yaf_Rank_yaf_Board'. The conflict occurred in database 'yet_another_forum_test', table 'yaf_Rank', column 'BoardID'.

The statement has been terminated."

When I try to delete in SQL Server Management Studio 2008 I get following message:

"No rows were deleted.

A problem occured attempting to delete row 1.

Error Source: .Net SqlClient Data Provider.

Error Message: DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_yaf_Active_yaf_Board'.

The conflict occured in database 'yet_another_forum_test', table 'yaf_Active',

column 'BoardID'.

The statement has been terminated.

Correct the errors and attempt to delete the row again or press ESC to cancel the change(s)."

So it seems alot of tables are nestled together with the Board id.

After having clearing the whole database almost, you can delete the default board. However, now user is deleted so now you can't do anything... How am I supposed to do anything now?

You can easily say this doesn't work. :D

So I will try everything from the beginning again.

When trying to clear the database with:

EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"

The following tables aren't removed:

yaf_AccesMask

yaf_Board

yaf_Category

yaf_Forum

yaf_Message

yaf_NntpForum

yaf_NntpServer

yaf_PMessage

yaf_Poll

yaf_Rank

yaf_Topic

Error message is:

Msg 3726, Level 16, State 1, Line 1

Could not drop object 'dbo.yaf_Message' because it is referenced by a FOREIGN KEY constraint.

Msg 3726, Level 16, State 1, Line 1

Could not drop object 'dbo.yaf_PMessage' because it is referenced by a FOREIGN KEY constraint.

Msg 3726, Level 16, State 1, Line 1

Could not drop object 'dbo.yaf_Poll' because it is referenced by a FOREIGN KEY constraint.

Msg 3726, Level 16, State 1, Line 1

Could not drop object 'dbo.yaf_Topic' because it is referenced by a FOREIGN KEY constraint.

Msg 3726, Level 16, State 1, Line 1

Could not drop object 'dbo.yaf_User' because it is referenced by a FOREIGN KEY constraint.

Msg 3726, Level 16, State 1, Line 1

Could not drop object 'dbo.yaf_Rank' because it is referenced by a FOREIGN KEY constraint.

Msg 3726, Level 16, State 1, Line 1

Could not drop object 'dbo.yaf_AccessMask' because it is referenced by a FOREIGN KEY constraint.

Msg 3726, Level 16, State 1, Line 1

Could not drop object 'dbo.yaf_Board' because it is referenced by a FOREIGN KEY constraint.

Msg 3726, Level 16, State 1, Line 1

Could not drop object 'dbo.yaf_NntpServer' because it is referenced by a FOREIGN KEY constraint.

Msg 3726, Level 16, State 1, Line 1

Could not drop object 'dbo.yaf_NntpForum' because it is referenced by a FOREIGN KEY constraint.

Msg 3726, Level 16, State 1, Line 1

Could not drop object 'dbo.yaf_Category' because it is referenced by a FOREIGN KEY constraint.

Msg 3726, Level 16, State 1, Line 1

Could not drop object 'dbo.yaf_Forum' because it is referenced by a FOREIGN KEY constraint.

So I simply deleted the whole database and remade everything.

This time everything went okay when I installed.