Some success. So far the following was done:
Command used was:
deadlinecommand -UpdateDatabaseSettings "\\servername\repository\v7" "MongoDB" "db.servername.dev" "deadline7db" "27017" "0" "false" "true" "deadlineuser" "password" "" "true"
I followed the 6.2 user manual for the command structure but it was giving an missing index error, so going off:
C:\Program Files\Thinkbox\Deadline7\bin>deadlinecommand.exe -help UpdateDatabaseSettings[/code]
[code]UpdateDatabaseSettings
Updates the given repository's dbConnect.xml file with the given database settings.
[Repository] The path to the repository root
[Type] The database type (currently only MongoDB)
[Host] The host name or IP address of the database machine
[Name] The database name
[Port] The database port
[AltPort] The alternate database port (not currently used)
[SSL] If SSL should be used to connect (not currently used)
[Authenticate] If authentication is required
[Username] The username
[Password] The password
[Relpica Set] The Replica set name
[Split DB] If Database should be split (by default, it is enabled)
Indicated that I need to include a “” “true” at the end to cover the indexes needed for ReplicaSetName (“”) and SplitDB (“true”). After that, success!
Current problem:
I can’t seem to get mongodb to auth against the supplied user. It was previously created without authentication. Any chance there’s a mongo script I can run on the local DB server that would setup the user privileges? I’ve tried:
C:\Program Files\Thinkbox\Deadline7\bin>deadlinecommand -ConfigureDatabase "MongoDB" "db.server.dev" "deadline7db" "27017" "0" "false" "true" "deadline" "password" "" "true"
But it tells me i haven’t started mongod with --auth (it is) or gives me:
[code]An error occurred while configuring the database:
An error occurred while trying to Query the Database (db.server.dev):
27017). It is possible that Deadline failed to Authenticate properly. Please che
ck that the Mongo Username/Password are correct.
Full error: QueryFailure flag was not authorized for query on deadline7db_Misc.s
ystem.namespaces (response was { “$err” : “not authorized for query on deadline7
db_Misc.system.namespaces”, “code” : 13 }).[/code]
I’ve tried:
db.createUser({user: “deadline”,pwd: “password”,roles: [{role: “userAdminAnyDatabase”,db: “admin”}]})
But that doesn’t work, i’ve also tried adding the deadline user to the deadline7db DB, still no luck.
Currently my deadline7db looks like:
[code]> use deadline7db
switched to db deadline7db
db.getUsers()
[
{
“_id” : “deadline7db.deadline”,
“user” : “deadline”,
“db” : “deadline7db”,
“roles” : [
{
“role” : “readWrite”,
“db” : “deadline7db”
},
{
“role” : “readWrite”,
“db” : “deadline7db_Config”
},
{
“role” : “readWrite”,
“db” : “deadline7db_JobState”
},
{
“role” : “readWrite”,
“db” : “deadline7db_Jobs”
},
{
“role” : “readWrite”,
“db” : “deadline7db_LimitStubs”
},
{
“role” : “readWrite”,
“db” : “deadline7db_Limits”
},
{
“role” : “readWrite”,
“db” : “deadline7db_Misc”
},
{
“role” : “readWrite”,
“db” : “deadline7db_Reports”
},
{
“role” : “readWrite”,
“db” : “deadline7db_Statistics”
},
{
“role” : “readWrite”,
“db” : “deadline7db_StatusInfo”
},
{
“role” : “readWrite”,
“db” : “deadline7db_Tasks”
}
]
}
]
[/code]
And the DL Monitor on startup gives me:
Traceback (most recent call last):
File "DeadlineMonitor\UI\Forms\MainWindowStartup.py", line 309, in Startup
DatabaseConnectionException: An error occurred when trying to connect to the Database. See inner exception for details.
at g.a(MongoDatabase A_0, Boolean A_1)
at Deadline.StorageDB.MongoDB.MongoSettingsStorage.GetRepositoryDateTime()
at Deadline.Monitor.MonitorManager.GetDefaultMonitorLayout(Boolean& resetAtStartup)
Should I look at completely dropping and starting fresh? Don’t need to keep anything in the repo etc.