Ryzom

Check this: http://dev.ryzom.com/wiki/ryzom/ClientConnectErrors
Looks like you missed some step configuring databases.

i've gone through the db configuration twice and i've double checked everything. it's all there. it adds a user to the db just fine. afterwards when i try to log in with an user already in the db, that's when i get the 3006 message.

side note, i get the 3006 message even if the server is not running. figured there may be a firewall problem. double checked my firewall, all the bits and pieces that requires net access has full permissions. still getting the 3006. i've tried with the firewall disabled, no go on that either.

and i'm out of ideas. what exactly is a 3006 error anyways?

thanks.

3006 is when r2_login.php script fails with mysql_query(). Check r2_login*.log files for more info

Welp, got one step closer.

Looks like there is an error with this particular statement : $query = "UPDATE permission set AccessPrivilege='".$permission['AccessPrivilege'].",$accessPriv' WHERE prim=".$permission['prim']; (r2_login.php:417). There seems to be an extraneous comma in the command. If I remove the comma in front of $accessPriv, I get pass that 3006 error.

I also had to make a change to the table structure for ring_users in db:ring_open. I set the description field to allow for nulls. I was getting "Field 'description' doesn't have a default value" errors until I made the change.

Now, I'm getting :

A failed assertion occurs
ProcName: haven/SU-0
Date: 2010/05/29 09:56:40
File: .\database_mapping.cpp
Line: 2846
FuncName: RSMGR::CRingUser::setPersistentState
Reason: "NOPE::AllowedTransition[_ObjectState][state] == true"
-------------------------------

I'll report back with what I can figure out.

Side question. Is there a particular level of mysql that is required? I already had apache and mysql installed, so I just used what I had instead of installing XAMPP. The version of MySQL that I am using is 5.1.46.

tabs

http://dev.ryzom.com/wiki/ryzom/ConfigureForLinux
Check note about STRICT_TRANS_TABLES, make sure you don't have it

that did it. thanks very much.

hehe, ok. revert your changes you made in r2_login.php

tabo wrote:

i've gone through the db configuration twice and i've double checked everything.

twice was not enough it seems? :P

well, in my defense, STRICT_TRANS_TABLES is listed under "Alternative steps to creating user and privileges" for the setting up stuff on Windows. I just read the main parts of the doc and created the user and db, didn't even think to look over the alternative way. :p

now, i just need to find a second machine to run the server on. running both server and client on the same machine, causes the client have problems staying connected to the server.

tabs

ok :) Wiki is open, you can edit it and fix :)

I tried to clean up the wiki page [[http://dev.ryzom.com/wiki/ryzom/EverythingWindows]] so that the STRICT_TRANS_TABLES removal is more obvious, and, not just under the "alternative steps".

Sorry for the confusion.

As kerozcak mentioned, the wiki is open and you can add/edit to your hearts content :)

If you find my changes confusing or hard to follow, please feel to improve upon them :)

Don't be shy :)