ERROR: Create Admin User Failed... · YAF.NET Support Forum

sewi
56% (Neutral)
YAF Forumling Topic Starter

13 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:

Quote:

Source: Failure Initializing User/Page

Quote:

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

Edited by user 13 years ago | Reason: Not specified

jshepler
100% (Exalted)
YAF MVP

13 years ago

#2

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

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.

sewi wrote:

EventLog:

Quote:

Source: Failure Initializing User/Page

Quote:

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?

Edited by user 13 years ago | Reason: Not specified

not jsheLPer

sewi
56% (Neutral)
YAF Forumling Topic Starter

13 years ago

#3

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:

Quote:

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...

Edited by user 13 years ago | Reason: Not specified

sewi
56% (Neutral)
YAF Forumling Topic Starter

13 years ago

#4

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:

Quote:

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???

Edited by user 13 years ago | Reason: Not specified

imukai
100% (Exalted)
YAF Commander

13 years ago

#5

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
56% (Neutral)
YAF Forumling Topic Starter

13 years ago

#6

error:

Quote:

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
100% (Exalted)
YAF Commander

13 years ago

#7

I suppose the obvious question would be.. can your web server communicate with where you have SQL installed?

Can you describe your setup?

sewi
56% (Neutral)
YAF Forumling Topic Starter

13 years ago

#8

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
55.4% (Neutral)
YAF Forumling

13 years ago

#9

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.

Edited by user 13 years ago | Reason: added additional info.

Elrinth
55.4% (Neutral)
YAF Forumling

13 years ago

#10

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.

Edited by user 13 years ago | Reason: Not specified

logan
100% (Exalted)
YAF Leader

13 years ago

#11

delete the test forum from the first board then try again

test

Elrinth
55.4% (Neutral)
YAF Forumling

13 years ago

#12

logan wrote:
delete the test forum from the first board then try again

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.

Edited by user 13 years ago | Reason: Not specified

Important Information: