cant buy land, banker cant get money
- You cannot open a new topic into this forum
- Guests cannot post into this forum
Cam_C
Posts: 20
Posts: 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
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
Votes:125
Average:4.40
Cam_C
Posts: 20
Posts: 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
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
Votes:89
Average:4.04
iseki
Posts: 1581
Posts: 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?
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?
Votes:99
Average:3.13
Cam_C
Posts: 20
Posts: 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
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
Votes:68
Average:4.41
Cam_C
Posts: 20
Posts: 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
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
Votes:89
Average:3.93
iseki
Posts: 1581
Posts: 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
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
...................
...................
Votes:75
Average:4.93
Cam_C
Posts: 20
Posts: 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)
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)
Votes:114
Average:4.21
Cam_C
Posts: 20
Posts: 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
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
Votes:87
Average:4.94
admin
Posts: 245
Posts: 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
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
Votes:59
Average:4.75
iseki
Posts: 1581
Posts: 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.
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.
Votes:86
Average:3.72
Previous post
-
Next post
|
Parent
-
No child
|
Posted on 2012/3/25 14:57
Cam_C
Posts: 20
Posts: 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
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
Votes:113
Average:5.40
