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

cant buy land, banker cant get money

  • このフォーラムに新しいトピックを立てることはできません
  • このフォーラムではゲスト投稿が禁止されています
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 .2 .3 .4 .5 .6 | 投稿日時 2012-3-24 16:38
Cam_C  Just popping in   投稿数: 20
Hi I have got the system working mostly but as the title of this post suggests, I cant buy or sell land, I get no errors on the console, just the screen panel saying cannot buy now, also the Banker cannot obtain money from the system, again I get no error on the console, just the screen floater says cannot get money at this time.
Thank you for your help
BTW I am running php 5.3.9 I just found something that 5.3.x doesnt work, should I uninstall and go back to 5.2.x ?
Thanks
Cam
投票数:124 平均点:4.44
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2012-3-24 19:13
Cam_C  Just popping in   投稿数: 20
Sorry I couldnt find the edit button so I add another reply instead.
I have downgraded php to 5.2.5 but I still get exactly the same problem, cant buy or sell land and Banker cant get money from system, ( all users log in with 1000, and can give money and buy objects ok)

(I can however buy and sell land for $0 in standalone mode if I remove the money module, but cant buy land in grid mode for money or for no money)
thank you
Cam
投票数:89 平均点:4.04
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2012-3-24 19:44 | 最終変更
iseki  Home away from home   投稿数: 1581
Hi

Please show me your environment of system.

Version of OpenSim, Windows, PHP (is it include xmlrpc and curl?) and Apache.

And can you see your PHP log?
投票数:99 平均点:3.13
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2012-3-24 20:24
Cam_C  Just popping in   投稿数: 20
Sure,
Windows XP pro sp3, opensim 7.4 , php5.2.5, xmlrpc and curl enabled apache 2.2.6
the php log file is blank,
but this is in the apache error log file
"[Sat Mar 24 20:14:17 2012] [error] [client 192.168.1.68] client denied by server configuration: C:/wamp/www/opensim_scripts/helper/landtool.php"

thanks
投票数:68 平均点:4.41
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2012-3-24 22:03
Cam_C  Just popping in   投稿数: 20
More info,
after looking at the apache error I have added 192.168.1.68 to the httpd.conf directory "Allow from 192.168.1.68" and now I get a different log, the result is the same but the is no error in apache now
there is an error in php_error.log
"[24-Mar-2012 22:54:31] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'http' (11001) in C:\wamp\www\opensim_scripts\include\mysql.func.php on line 72"
what do you think causes this?
thanks
投票数:89 平均点:3.93
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2012-3-25 1:21 | 最終変更
iseki  Home away from home   投稿数: 1581
Did you set up "OPENSIM_DB_HOST" in C:\wamp\www\opensim_scripts\include\config.php ?
Maybe, in your case
define('OPENSIM_DB_HOST', '192.168.1.68');

My config.php is

<?php
//
// Configration file for non Web Interface
//
//
//
// Please set this hepler script URL and directory
if (!defined('ENV_HELPER_URL'))  define('ENV_HELPER_URL',  'http://www.nsl.tuis.ac.jp/currency/helper/');
if (!defined('ENV_HELPER_PATH')) define('ENV_HELPER_PATH', '/home/apache/htdocs/currency/helper/');
//////////////////////////////////////////////////////////////////////////////////i
// Valiables for OpenSim
// Please set MySQL DB access information
define('OPENSIM_DB_HOST', 'mysql.nsl.tuis.ac.jp');
define('OPENSIM_DB_NAME', 'opensim_db');
define('OPENSIM_DB_USER', 'opensim_user');
define('OPENSIM_DB_PASS', '**********');
// Money Server Access Key
// Please set same key with MoneyScriptAccessKey in MoneyServer.ini
define('CURRENCY_SCRIPT_KEY', '123456789');
// Group Module Access Keys
// Please set same keys with at [Groups] section in OpenSim.ini (case of Aurora-Sim, it is Groups.ini)
define('XMLGROUP_RKEY', '1234');    // Read Key
define('XMLGROUP_WKEY', '1234');    // Write key
// Please set user(robust) server's URL
define('USER_SERVER_URI', 'http://opensim.nsl.tuis.ac.jp:8002/');   // not use localhost or 127.0.0.1

...................
...................
投票数:74 平均点:4.86
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2012-3-25 8:45
Cam_C  Just popping in   投稿数: 20
I actually had "define('OPENSIM_DB_HOST', 'http://192.168.1.68');"
so after looking at what you posted I removed the http://
and now I get a different php error ...
[25-Mar-2012 09:16:43] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Host 'hp-1ac38496d8c6.lan' is not allowed to connect to this MySQL server in C:\wamp\www\opensim_scripts\include\mysql.func.php on line 72
..............................................
hp-1ac38496d8c6 is actually the name of my computer in my router,
I tried adding "hp-1ac38496d8c6.lan" to the directory "allowed" and also tried "hp-1ac38496d8c6" and both times the result was,
the wamp icon would stay 3/4 yellow, and the buying land and banker buying money still fails
(however there is no error logged in either apache nor php)
投票数:111 平均点:4.32
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2012-3-25 10:43
Cam_C  Just popping in   投稿数: 20
I fixed it, (I think) I replaced "define('OPENSIM_DB_HOST', 'http://192.168.1.68');" with "define('OPENSIM_DB_HOST', 'localhost');" and now all functions seem to work, I hope this will not cause the problems you spoke of by using localhost, but it seems to me that tis is the DB connect, and not the IP.
A look at the money server shows uuid@192.168.1.68 as the user so it seems to be ok, would you agree?
many thanks for your time and help.
Regards
Cam
投票数:87 平均点:4.94
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2012-3-25 10:45 | 最終変更
admin  Webmaster   投稿数: 245
Your MySQL not allowed to access from remote user account.
Remote user account format is "xxxx@IP address of remote PC"

Please see
http://dev.mysql.com/doc/refman/5.0/en/access-denied.html

If php script is in same PC that MySQL is executed, you can use 127.0.0.1
So
define('OPENSIM_DB_HOST', '127.0.0.1');

In that script, 127.0.0.1 is allowed.
Please see also http://www.nsl.tuis.ac.jp/xoops/modules/d3forum/index.php?post_id=817

---
Iseki
投票数:58 平均点:4.83
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2012-3-25 10:56
iseki  Home away from home   投稿数: 1581
Hi,

I mistake to post. I re post.

In that script, 127.0.0.1 and localhost are allowed.
Please see also http://www.nsl.tuis.ac.jp/xoops/modules/d3forum/index.php?post_id=817

Thanks.
投票数:85 平均点:3.76
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2012-3-25 14:57
Cam_C  Just popping in   投稿数: 20
Thank you very much for providing both this currency server and also the support help to make it work.
You have saved me from a lot of problems.
My testing has also proved the system with opensim0.7.4 to work ok.
Do you intend to continue to update this with upgrades as the Opensim code evolves?
This would be very good if you do.
Regards
Cam
投票数:112 平均点:5.36

  条件検索へ


サイト内 検索

ログイン

ユーザー名:

パスワード:


パスワード紛失
新規登録

サブ メニュー

ミニカレンダー

前月2024年 3月翌月
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
<今日>

オンライン状況

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

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

もっと...

アクセスカウンタ

今日 : 4078407840784078
昨日 : 4222422242224222
総計 : 2317149223171492231714922317149223171492231714922317149223171492
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com