flagflag  

about OpenSim Currency Server (NSL version)

  • You cannot open a new topic into this forum
  • Guests cannot post into this forum
Previous post - Next post | Parent - Children.1 .2 .3 .4 .5 .6 .7 .8 .9 .10 .11 .12 .13 .14 .15 | Posted on 2010/8/20 13:41
admin  Webmaster   Posts: 245
The question on the OpenSim Currency server of the NSL version has asking here.
Votes:116 Average:5.09
Previous post - Next post | Parent - Children.1 | Posted on 2010/9/7 3:44
Luisillo  Just can't stay away From: Spain  Posts: 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 ---
Votes:258 Average:4.07
Previous post - Next post | Parent - No child | Posted on 2010/9/7 3:48
Luisillo  Just can&#039;t stay away From: Spain  Posts: 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)
Votes:82 Average:5.24
Previous post - Next post | Parent - No child | Posted on 2010/9/9 14:28
iseki  Home away from home   Posts: 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;
Votes:117 Average:4.70
Previous post - Next post | Parent - Children.1 | Posted on 2010/9/9 22:48
Luisillo  Just can&#039;t stay away From: Spain  Posts: 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 !
Votes:94 Average:5.11
Previous post - Next post | Parent - No child | Posted on 2010/9/10 22:18
iseki  Home away from home   Posts: 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. :)
Votes:97 Average:4.43
Previous post - Next post | Parent - Children.1 | Posted on 2010/9/11 3:06
Luisillo  Just can&#039;t stay away From: Spain  Posts: 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,
Votes:133 Average:3.23
Previous post - Next post | Parent - No child | Posted on 2010/9/11 21:05 | Last modified
iseki  Home away from home   Posts: 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,
Votes:103 Average:5.05
Previous post - Next post | Parent - Children.1 | Posted on 2010/10/10 0:05
master  Just can&#039;t stay away   Posts: 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
Votes:153 Average:5.23
Previous post - Next post | Parent - No child | Posted on 2010/10/10 21:40 | Last modified
iseki  Home away from home   Posts: 1581
Hi master.

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

Thanks.
Votes:105 Average:4.38
Previous post - Next post | Parent - No child | Posted on 2010/10/11 0:30
master  Just can&#039;t stay away   Posts: 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
Votes:154 Average:7.53
Previous post - Next post | Parent - No child | Posted on 2010/10/11 1:29
master  Just can&#039;t stay away   Posts: 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
Votes:77 Average:3.77
Previous post - Next post | Parent - Children.1 | Posted on 2010/10/11 2:38
master  Just can&#039;t stay away   Posts: 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
Votes:143 Average:6.50
Previous post - Next post | Parent - Children.1 | Posted on 2010/10/12 3:26
master  Just can&#039;t stay away   Posts: 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
Votes:123 Average:3.17
Previous post - Next post | Parent - No child | Posted on 2010/10/12 12:45
iseki  Home away from home   Posts: 1581
Quote:

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
Votes:100 Average:4.60
Previous post - Next post | Parent - Children.1 | Posted on 2010/10/12 12:53 | Last modified
iseki  Home away from home   Posts: 1581
Quote:

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... :)
Votes:92 Average:4.13
Previous post - Next post | Parent - No child | Posted on 2010/10/12 23:54
master  Just can&#039;t stay away   Posts: 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
Votes:130 Average:4.62
Previous post - Next post | Parent - Children.1 | Posted on 2010/10/13 0:26
master  Just can&#039;t stay away   Posts: 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
Votes:91 Average:4.95
Previous post - Next post | Parent - No child | Posted on 2010/10/15 15:16
s10703  Just popping in   Posts: 1
The experimental environment is being constructed just now.
Votes:84 Average:5.36
Previous post - Next post | Parent - Children.1 | Posted on 2010/10/16 3:02
chrisby  Not too shy to talk   Posts: 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 :)
Votes:93 Average:4.62
Previous post - Next post | Parent - Children.1 | Posted on 2010/10/18 22:11 | Last modified
iseki  Home away from home   Posts: 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;
        }
Votes:99 Average:4.95
Previous post - Next post | Parent - No child | Posted on 2010/10/19 2:33
chrisby  Not too shy to talk   Posts: 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
Votes:147 Average:4.90
Previous post - Next post | Parent - No child | Posted on 2010/11/4 2:06
master  Just can&#039;t stay away   Posts: 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 :)
Votes:120 Average:3.25
Previous post - Next post | Parent - No child | Posted on 2010/11/4 2:08
master  Just can&#039;t stay away   Posts: 138
(Pokes my own admins to help out here.. this is the good stuff :) )
Votes:92 Average:4.24
Previous post - Next post | Parent - No child | Posted on 2010/11/4 2:25
master  Just can&#039;t stay away   Posts: 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
Votes:86 Average:5.23
Previous post - Next post | Parent - No child | Posted on 2010/11/4 2:39
master  Just can&#039;t stay away   Posts: 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
Votes:132 Average:4.62

  Advanced search


Site Search

Login

Username:

Password:


Lost Password?
Register now!!

Sub Menu

mini Calendar

Last MonthMay 2025Next Month
Su Mo Tu We Th Fr Sa
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
Today

Who's Online

57 user(s) are online (3 user(s) are browsing Forum)

Members: 0
Guests: 57

more...

Access Counter

Today : 1132911329113291132911329
Yesterday : 1641116411164111641116411
Total : 2615154126151541261515412615154126151541261515412615154126151541
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com