[Help] with reg page/connection error....In need of your wisdom :P

[michae5k]

hi all, this is my first post yay..

i have tried to set up every pw server pack i have found online and i always run into errors,
at the moment my reg page does not work and shows this error :

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: TDS in /opt/lampp/htdocs/register/processor.php on line 26

Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in /opt/lampp/htdocs/register/processor.php on line 27
Connection failed! Check your core.php

so i got hold of the "testacc" user sql dump. and now i have another problem. for example currently i have set up my server and it appears to work, yet if i try to log in with the "testacc" account i get an error in the colinux window which reads :

GQueryPasswd:account is testacc , login ip is 33685514
TRACE : Timer update: (0) Sat Feb 21 21:36:43 2009

TRACE : gdelivery:asswdtimeout. user=testacc
TRACE : gdelivery::matrixpasswd cache missing, user=testacc

all my ip/info within table.xml/hosts ect are all correct, so could anyone help me with a soultion for either or both of these problems. and i have used the search button but have not found a working soultion.

thanks guys

 

[juca266]

open your PWServer.bat and fallow it

cd /opt/lampp/htdocs/register press enter

nano core.php press enter

on core.php put your sql password

example:
$dbhost = "127.0.0.1";

$dbuser = "sa";

$dbpasswd = "PASSWORD HERE";

press CTRL X press Y press ENTER put cd press ENTER and start your server
if you reg is on appserver open AppServ\www\reg and edit sql password save and done

 

[michae5k]

thanks for the reply, all my info in all those fields are correct as is the info in table.xml and etc/hosts.
so that isnt the problem. i have even installed the latest version of lampp (xampp for linux) into colinux and that still doesnt help. any more ideas ?

 

[Romulan]

Yep, the table.xml is scripted for a connection to a MSSQL Server...
If you are a programer or have friends can "translate" the table.xml for a connection to a MySQL Server... It's will be very nice... ^^
Other problems... in every release on this forum don't include MySQL Connector/J in their package... Always for a connection to a MSSQL Server (msODBC...) (Noobs always love Microsoft ^-^)... MySQL connector/J is needed for a connection to MySQL server with Java : )

(Sorry for bad english.. I speak french ^^")

I'm trying to search more information about MySQL connector/J for a fully perfect server on Linux/Unix system ^^ (Love OpenSource tt: )

Cheers ^_^

EDIT : Don't use coLinux and MSSQL ! it's for noob !
Do a perfect world server on a Linux with physical machine ! Not virtual machine or coLinux because the perfomance are decreased than a real machine... and it's more difficult to install and configure, thrust me ^-^
And MySQL is very better than MSSQL for many thing... (no proprietary software and co...)