flagflag  If you want to see English page, please click "English" Button at Left.

NSLバージョンの OpenSim Currencyサーバについて

  • このフォーラムに新しいトピックを立てることはできません
  • このフォーラムではゲスト投稿が禁止されています
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 .2 .3 .4 .5 .6 .7 .8 .9 .10 .11 .12 .13 .14 .15 | 投稿日時 2010-8-20 13:41
admin  Webmaster   投稿数: 245
NSLバージョンの OpenSim Currencyサーバについての質問はここにお願いしいます.
投票数:108 平均点:5.00
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2010-9-7 3:44
Luisillo  Just can't stay away 居住地: Spain  投稿数: 80
I reinstall a lot of times but i obtain a error. I m in a mental bucle
I need help some idea about this error?

2010-09-06 20:37:37,209 INFO - OpenSim.Data.MySQL.MySQLMoneyDataWrapper.MySQLMoneyManager [MYSQL]: Connection established
2010-09-06 20:37:37,417 INFO - OpenSim.Framework.Servers.BaseOpenSimServer [STARTUP]: Startup took 0m 1s
2010-09-06 20:38:01,586 INFO - OpenSim.Grid.MoneyServer.MoneyXmlRpcModule [Money] User 283cb4c4-2084-43d2-9547-0bd02675b5cc@63.246.153.80 is logging off
2010-09-06 20:38:35,235 INFO - OpenSim.Grid.MoneyServer.MoneyXmlRpcModule [Money] User: 283cb4c4-2084-43d2-9547-0bd02675b5cc@63.246.153.80 has logged in,getting balance...
2010-09-06 20:38:35,247 ERROR - OpenSim.Data.MySQL.MySQLMoneyDataWrapper.MySQLMoneyManager <log4net.Error>Exception during StringFormat: Index (zero based) must be greater than or equal to zero and less tha
MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data
at MySql.Data.MySqlClient.MySqlStream.LoadPacket () [0x00000]
at MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000]
at MySql.Data.MySqlClient.NativeDriver.ReadResult (System.UInt64& affectedRows, System.Int64& lastInsertId) [0x00000]
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet () [0x00000]
at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000]
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000]
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (CommandBehavior behavior) [0x00000]
--- End of inner exception stack trace ---
投票数:252 平均点:4.05
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-9-7 3:48
Luisillo  Just can&#039;t stay away 居住地: Spain  投稿数: 80
More informatión im sorry...
Opensim 0.7.0.1 with xoopensim and 0.7.0.1
OpenSim 0.7/0.7.0.1 rev3 Currency Server (NSL Version)
投票数:77 平均点:5.19
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-9-9 14:28
iseki  Home away from home   投稿数: 1581
Well. I do not know.....

I do not reproduce your error though I tried with any condition.

My Money Server works well.
It's log is
2010-09-09 14:03:13,664 INFO  - OpenSim.Data.MySQL.MySQLMoneyDataWrapper.MySQLMoneyManager [MYSQL]: Connection established
2010-09-09 14:03:13,741 INFO  - OpenSim.Framework.Servers.BaseOpenSimServer [STARTUP]: Startup took 0m 0s
2010-09-09 14:03:36,850 INFO  - OpenSim.Grid.MoneyServer.MoneyXmlRpcModule [Money] User: 3fc93602-b2d3-4c46-80ac-36fff2523e8c@202.26.159.196 has logged in,getting balance...
2010-09-09 14:03:36,853 INFO  - OpenSim.Grid.MoneyServer.MoneyDBService [MYSQL] Found user "Test User",now update information
2010-09-09 14:03:37,023 INFO  - OpenSim.Grid.MoneyServer.MoneyXmlRpcModule [Money] Getting balance for user: 3fc93602-b2d3-4c46-80ac-36fff2523e8c@202.26.159.196

According to your log, it seems that your Money Server can not get avatar name or balance from MySQL server.
Please check your MySQL table by Linux command or , phpMyAdmin (case of Windows).

at Linux
# /usr/local/mysql/bin/mysql -u root -p    or  mysql -u root -p
Enter Passwaord
mysql> use "db name of OpenSim";
mysql> select * from balances;
投票数:107 平均点:4.77
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2010-9-9 22:48
Luisillo  Just can&#039;t stay away 居住地: Spain  投稿数: 80

Problem was i give data for db access of "xoopensim" database not for "opensim" database then can not create new users into this table.

15:38:49 - [Money]: User: 283cb4c4-2084-43d2-9547-0bd02675b5cc@207.150.183.56 has logged in,getting balance...
15:38:49 - [MYSQL]: Found user "Luisillo Contepomi",now update information
15:38:51 - [Money]: Getting balance for user: 283cb4c4-2084-43d2-9547-0bd02675b5cc@xxx.xxx.xxx.xxx

Thank you !
投票数:87 平均点:5.17
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-9-10 22:18
iseki  Home away from home   投稿数: 1581
Hi Luisillo

It might be interesting that only a specific avatar (ex. Banker avatar) can buy currency.

I'll think that function. But I cannot do immediately, because I am busy recently. :)
投票数:90 平均点:4.56
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2010-9-11 3:06
Luisillo  Just can&#039;t stay away 居住地: Spain  投稿数: 80
Hi iseky,
Yes would be interesting.

Now im working on ossearch. Currency is only, by now, for tests, waiting for future more secure applications about. I think is early for implement currency in a production grid with opensim proyect in status beta "0.7" and with big changes inter versions (0.6.9 to 0.7 was a big step)

Regards,
投票数:125 平均点:3.04
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-9-11 21:05 | 最終変更
iseki  Home away from home   投稿数: 1581
Hi Luisillo

Oh!!
Thank you for your response. And I'm Sorry Very Much!!
I'm sorry for writing an unknown thing.

I mistook the user for answer and the topic of forum.

Am I tired? :)


Regards,
投票数:95 平均点:5.26
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2010-10-10 0:05
master  Just can&#039;t stay away   投稿数: 138
Slight build problem at current svn. It will patch but ./build.sh fails saying it cannot find the target files needed in the opensim project.
Moneyserver ect will not build.
I am doing this in the same way as i had been until the last update using current git dev. revs. of opensim.
Tnx

(there has been some changes to core files that may effect this but copying and over writing the files still seems to work ok using the files from the last knowen good build of this project).

Tnx
投票数:133 平均点:5.71
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-10-10 21:40 | 最終変更
iseki  Home away from home   投稿数: 1581
Hi master.

Thank you for your report.
I corrected it's bug.

Thanks.
投票数:96 平均点:4.38
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-10-11 0:30
master  Just can&#039;t stay away   投稿数: 138
Looks ok now. thank you.

I might suggest a small fix that relates to HyperGrid visitor's and that would be that if it see's a user that has null user info to ignore them and not bother looking them up. (it trys to look up info for user="")

They do not have an actual account on the grid they HG too anyway.
If its too complex then its not a big problem as it wount hurt anything but adds to the log as an error.

I would prefer that HG visitor's not be able to use currency anyway at this point.

tnx
投票数:123 平均点:7.15
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-10-11 1:29
master  Just can&#039;t stay away   投稿数: 138
Err.. "if it see's a user that has null user info to ignore them" lol, It has to look to know that. But it shouldent get to where it trys to make "" a currency account.

mostly Mysql is catching the attempt of the money server and rejects it.

tnx
投票数:69 平均点:3.77
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2010-10-11 2:38
master  Just can&#039;t stay away   投稿数: 138
I have another question and that is how i can make SineWaveCert's my own pair?
Or is this done when the project is built?

tnx
投票数:110 平均点:5.82
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2010-10-12 3:26
master  Just can&#039;t stay away   投稿数: 138
Here is a link to our mantis about the Hypergrid error we get.

http://tritongrid.com/modules/mantis/bug_view_page.php?bug_id=0000015

One of our admins is also trying to sort it out.

tnx
投票数:111 平均点:2.88
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-10-12 12:45
iseki  Home away from home   投稿数: 1581
引用:

I have another question and that is how i can make SineWaveCert's my own pair?
Or is this done when the project is built?

Because SineWareCerts is a usual server certification file, everyone can newly make it.
We are planning the distribution of a different server certification file to each region server by using own CA(Certificate Authority).

thnks
投票数:90 平均点:4.67
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2010-10-12 12:53 | 最終変更
iseki  Home away from home   投稿数: 1581
引用:

Here is a link to our mantis about the Hypergrid error we get.

http://tritongrid.com/modules/mantis/bug_view_page.php?bug_id=0000015

One of our admins is also trying to sort it out.

I can not see above link? I see empty page.

We do not understand HG still well.
One of the my students is studying that. The student's work is very slow... :)
投票数:83 平均点:3.98
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-10-12 23:54
master  Just can&#039;t stay away   投稿数: 138
ohh sorry for that link. Its not working. I will post the log here then.

2010-10-08 03:06:29,843 INFO - OpenSim.Grid.MoneyServer.MoneyXmlRpcModule [Money] User: 6e11d415-71df-47e2-85de-f16c9ddd5f02 has logged in,getting balance...
2010-10-08 03:06:29,875 ERROR - OpenSim.Data.MySQL.MySQLMoneyDataWrapper.MySQLMoneyManager Unable to add user information to database: MySql.Data.MySqlClient.MySqlException: Column 'avatar' cannot be null
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at OpenSim.Data.MySQL.MySQLMoneyDataWrapper.MySQLMoneyManager.addUserInfo(UserInfo userInfo)
2010-10-08 03:06:29,875 ERROR - OpenSim.Grid.MoneyServer.MoneyXmlRpcModule [MYSQL]Unable to refresh information for user "" in DB

This is from the log and only happens when there is a HG visitor.

tnx
投票数:112 平均点:4.20
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2010-10-13 0:26
master  Just can&#039;t stay away   投稿数: 138
The problem is quite clear in the log. It does not need to process this and as near as we can tell can just ignore it.
A HG visitor is processed in a another way than normal and currency is of no use to them anyway.

tnx
投票数:82 平均点:5.12
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-10-15 15:16
s10703  Just popping in   投稿数: 1
The experimental environment is being constructed just now.
投票数:79 平均点:5.44
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2010-10-16 3:02
chrisby  Not too shy to talk   投稿数: 23
iseki,
after looking into the errors and code the fix is to add a null check to the mysql db manager for the money server so it ignores a null avatar key

manythanks

chrisby

ps if you would like me to submit a patch then please ask :)
投票数:86 平均点:4.65
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2010-10-18 22:11 | 最終変更
iseki  Home away from home   投稿数: 1581
Thank you chrisby.

Is this OK?

----
        public bool addUserInfo(UserInfo userInfo)
        {
            bool bRet = false;
            string sql = string.Empty;

            if (userInfo.Avatar==null) return false;

            sql += "INSERT INTO userinfo(`user`,`simip`,`avatar`,`pass`) VALUES";
            sql += "(?user,?simip,?avatar,?password);";

            MySqlCommand cmd = new MySqlCommand(sql, dbcon);
            cmd.Parameters.AddWithValue("?user", userInfo.UserID);
            cmd.Parameters.AddWithValue("?simip", userInfo.SimIP);
            cmd.Parameters.AddWithValue("?avatar", userInfo.Avatar);
            cmd.Parameters.AddWithValue("?password", userInfo.PswHash);

            try
            {
                if (cmd.ExecuteNonQuery() > 0) bRet = true;
                cmd.Dispose();
            }
            catch (Exception e)
            {
                m_log.Error("Unable to add user information to database: " + e.ToString());
                bRet = false;
            }

            return bRet;
        }
投票数:86 平均点:5.23
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-10-19 2:33
chrisby  Not too shy to talk   投稿数: 23
hi iseki,

that should work fine

also need a null check in

public XmlRpcResponse handleClientLogin(XmlRpcRequest request, IPEndPoint remoteClient)
in
MoneyXmlRpcModule.cs

to solve this error
2010-10-08 03:06:29,875 ERROR - OpenSim.Grid.MoneyServer.MoneyXmlRpcModule [MYSQL]Unable to refresh information for user "" in DB

that master posted

many thanks for your good work

chrisby
投票数:112 平均点:3.57
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-11-4 2:06
master  Just can&#039;t stay away   投稿数: 138
HG is fixed now, well done!, It wasent a show stopper but man NSL rocks.. I am proud to be here and prouder to see it matters.
I have big repect for all of the members here.

Some say they the language is a problem, some say its to complex

I say. both are wrong just try harder. it works .. simple as that :)

Anyway HG thing is fixed

Think the best of NSL crew now we see what happens with the mix :)
投票数:112 平均点:3.21
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-11-4 2:08
master  Just can&#039;t stay away   投稿数: 138
(Pokes my own admins to help out here.. this is the good stuff :) )
投票数:72 平均点:5.00
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-11-4 2:25
master  Just can&#039;t stay away   投稿数: 138
Our grip at triton grid is not about who We are. its not about the one. Its about what we can prove. Most of our ppl are just good at what they do. The restult is what maters .. (go look, just works).

We have no papers or say were of some some great.

We do what users want and our pride is in what users see and works!

We work hard and it is made of many minds.

If we have to know something new than we do.

We have been a grid for over 2.5 years now.. Hindsight matters and more the users.

No matter who is part of it .. users rule and we do our best

NSL is more.. clever coders and on top of it!

There is no one dong this but NSL.. its just the good stuff :)

One stop shopping if you want a real grid .. scalable and so on!

If you code .. got thong better to do.. chime in here.. we got alot of work to do :)

tnx
投票数:77 平均点:5.32
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2010-11-4 2:39
master  Just can&#039;t stay away   投稿数: 138
TritonGrid.com FULLly suports NSL and there efforts. If you want a real grid FULL and need some help we will do our best.
Have alot of hands on and years worth, was cant do more than what we know.

Its a good start and will do are job.

Donate to NSL if you got a spare buck .. keeps this working and matters :)

tnx
投票数:117 平均点:4.53

  条件検索へ


サイト内 検索

ログイン

ユーザー名:

パスワード:


パスワード紛失
新規登録

サブ メニュー

ミニカレンダー

前月2024年 5月翌月
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
<今日>

オンライン状況

25 人のユーザが現在オンラインです。 (5 人のユーザが Forum を参照しています。)

登録ユーザ: 0
ゲスト: 25

もっと...

アクセスカウンタ

今日 : 278278278
昨日 : 4763476347634763
総計 : 2368890523688905236889052368890523688905236889052368890523688905
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com