mongodb 以管理员登录并创建 database

mongodb 以管理员登录并创建 database

在一个有了用户名的数据库集中,即使在 admin 数据库中创建了用户,登录上去后还是不能访问其他数据库的,但是用   登录是可以的呀,虽然可以在相应数据库中再建立用户,但别的程序都不用是怎么回事?

 

原来是要在用户名后加上 "(admin)" 标识.

例如

            //ok//MongoServer server = MongoServer.Create("mongodb://root:111@192.168.0.34:27017/?connect=direct;slaveOk=true"); // connect to localhost
            MongoServer server = MongoServer.Create("mongodb://root(admin):111@192.168.0.34:27017/?connect=ReplicaSet;slaveOk=true"); // connect to localhost
是在以下找到的,用的 baidu 关键字 "MongoDatabase GetDatabase Invalid credentials for database"

关键字来源于 C# 的错误提示:

"

An unhandled exception of type 'MongoDB.Driver.MongoAuthenticationException' occurred in MongoDB.Driver.dll

Additional information: Invalid credentials for database 'demoBaseaaa'.

"

本来想查找 mongodb.exe 中是怎么实现的 use,结果发现它调用 js..  找了半天也没找到 C# 如何实现这样的先 use admin 再 use 普通 database 的,看来 API 和它的 shell tool 实现还是有差异.

http://groups.google.com/group/mongodb-user/browse_thread/thread/82132048f3ba1f6d

--------------------------------------------------

Creating a database from the 10gen C# driver

选项

共 7 个帖子 - 全部折叠  -  将所有内容翻译成中文（简体）

	ALH	查看个人资料   翻译成中文（简体）	更多选项 1月19日, 上午12时05分

How do I create a database from using 10gen C# driver? I have tried
this using the GetDatabase method in MongoServer with no luck. Also,
how would I do this if running in authentication mode? Is it any
different then running within a replica set? Thanks.

 

	Robert Stam	查看个人资料   翻译成中文（简体）	更多选项 1月19日, 上午12时11分

The database will be created automatically when you insert the first
document.

When running in authentication mode you must provide the credentials to use
for that database, like this:

var credentials = new MongoCredentials("username", "password");
var database = server.GetDatabase("databaseName", credentials);

The only thing different about running with a replica set is that your
connection string must have a seed list containing all or some of the
replica set members.

- 显示引用的文字 -

 

	ALH	查看个人资料   翻译成中文（简体）	更多选项 1月27日, 下午8时22分

Hi Robert,

Thanks for the reply. I have ran into some issues with the suggested
approach that I would like to share with you. So, just to recap:

I want to create a new database and then a new collection in that
database.

Here is what I am doing in code to achieve the above:

// Connect to server
var url = "mongodb://someAdminUser:someAdminUserPassword@localhost:
9001/admin"
var server = MongoServer.Create(url);

// Create my new database
var db = server.GetDatabase("SomeNewDatabase");

// Create my new collection
var collection = db.CreateCollection("MyNewCollection");

Observations:

I am running in authenticated mode but the database has not been
create yet, therefore, has no user credentials to authenticate against

Questions:

1. Given that I am running in authenticated mode what is the proper
way to connect to the server so that I can create a database that at
creation will not have any credentials? (please see the below error
message I am getting when executing the above code sample)
2. Is there a way to create a database without writing any data like
you would in SQL Server? I am currently doing this from the mongo
shell in PowerShell using connect("MyNewDatabase"). I would be willing
to write a CreateDatabase method if you can provide guidance.

Invalid credentials for database 'SomeTestDatabase'.
   at MongoDB.Driver.Internal.MongoConnection.Authenticate(String
databaseName, MongoCredentials credentials) in C:\work\10gen\mongodb
\mongo-csharp-driver\Driver\Internal\MongoConnection.cs:line 165
   at
MongoDB.Driver.Internal.MongoConnection.CheckAuthentication(MongoDatabase
database) in C:\work\10gen\mongodb\mongo-csharp-driver\Driver\Internal
\MongoConnection.cs:line 244
   at
MongoDB.Driver.MongoServerInstance.AcquireConnection(MongoDatabase
database) in C:\work\10gen\mongodb\mongo-csharp-driver\Driver\Core
\MongoServerInstance.cs:line 260
   at MongoDB.Driver.MongoServer.AcquireConnection(MongoDatabase
database, Boolean slaveOk) in C:\work\10gen\mongodb\mongo-csharp-driver
\Driver\Core\MongoServer.cs:line 1052
   at MongoDB.Driver.MongoCursorEnumerator`1.AcquireConnection() in C:
\work\10gen\mongodb\mongo-csharp-driver\Driver\Core
\MongoCursorEnumerator.cs:line 184
   at MongoDB.Driver.MongoCursorEnumerator`1.GetFirst() in C:\work
\10gen\mongodb\mongo-csharp-driver\Driver\Core
\MongoCursorEnumerator.cs:line 194
   at MongoDB.Driver.MongoCursorEnumerator`1.MoveNext() in C:\work
\10gen\mongodb\mongo-csharp-driver\Driver\Core
\MongoCursorEnumerator.cs:line 126
   at MongoDB.Driver.MongoDatabase.GetCollectionNames() in C:\work
\10gen\mongodb\mongo-csharp-driver\Driver\Core\MongoDatabase.cs:line
662
   at MongoDB.Driver.MongoDatabase.CollectionExists(String
collectionName) in C:\work\10gen\mongodb\mongo-csharp-driver\Driver
\Core\MongoDatabase.cs:line 305

Thanks.

Best Regards,
RelayHealth
Albert L. Hives

On Jan 18, 8:11 am, Robert Stam <rob...@10gen.com> wrote:

- 显示引用的文字 -

 

	Robert Stam	查看个人资料   翻译成中文（简体）	更多选项 1月27日, 下午11时07分

If you want the default credentials supplied in the URL to be
authenticated against the admin database you put "(admin)" after the
username in the URL, like this:

var url = "mongodb://
someAdminUser(admin):someAdminUserPassword@localhost:9001"

When you authenticate against the admin database you gain access to
all databases at once (including the new one you are about to create).

On Jan 27, 7:22 am, ALH <ahi...@gmail.com> wrote:

- 显示引用的文字 -

 

	ALH	查看个人资料   翻译成中文（简体）	更多选项 1月28日, 上午12时58分

Hi Robert,

This totally worked though I could not find this connection string on
the driver docs @ http://www.mongodb.org/display/DOCS/CSharp+Driver+Tutorial#CSharpDriv...

On Jan 27, 7:07 am, Robert Stam <rob...@10gen.com> wrote:

- 显示引用的文字 -

 

	Robert Stam	查看个人资料   翻译成中文（简体）	更多选项 1月28日, 上午1时05分

It's kind of buried in there:

http://www.mongodb.org/display/DOCS/CSharp+Driver+Tutorial#CSharpDriv...

- 显示引用的文字 -

 

	ALH	查看个人资料   翻译成中文（简体）	更多选项 1月28日, 上午3时06分

You are correct. I see it now. Thanks again. :)

On Jan 27, 9:05 am, Robert Stam <rob...@10gen.com> wrote:

- 显示引用的文字 -

 

--------------------------------------------------

里面说帮助页面上有说明的,看了一下的确有..就是说得太隐晦了:

Connection strings

The easiest way to connect to a MongoDB server is to use a connection string. The standard connection string format is:

mongodb://[username:password@]hostname[:port][/[database][?options]]

The username and password should only be present if you are using authentication on the MongoDB server. These credentials will be the default credentials for all databases. To authenticate against the admin database append "(admin)" to the username. If you are using different credentials with different databases pass the appropriate credentials to the GetDatabase method.

嗯,主要是我英文太烂,又没想到它的字符串示例没列出来完.

http://www.mongodb.org/display/DOCS/CSharp+Driver+Tutorial#CSharpDriverTutorial-TheC%23Driver

原来有一个完整的

            //字符串来自  http://www.mongodb.org/display/DOCS/CSharp+Driver+Tutorial#CSharpDriverTutorial-Connectionstrings