Am I missing something?

[GlaphanKing]

OK before you start, yes I am using the v11 files to start deving some custom items and get some packets, so shut up about that. We are all the same when it comes to this.

So I'm setting up the servers. I hate MSSQL by the way. MySQL i can do in my sleep but this is bull. Here's what I got:

1. ODBC Connectors for login, character01, log01, etc. Set up MSSQL 2008 express because 2005 is outdated for my OS. I set up a dummy account called flyff. I can connect successfully when I test the connection but when i turn on the account server, it won't connect. The log error says my user login with name 'flyff' failed.

Did I miss something? The ini's are setup with local ip's (127.0.0.1). C'mon its not this difficult. I bet I'm missing something stupid.


Help me out people and be descriptive.

[MentaL]

[jason145]

Did you add the account into Account__tbl and account_tbl_detail

[GlaphanKing]

can you elaborate?

it won't even connect to the database so I don't see the need for that yet.

[heathj]

OK before you start, yes I am using the v11 files to start deving some custom items and get some packets, so shut up about that. We are all the same when it comes to this.

So I'm setting up the servers. I hate MSSQL by the way. MySQL i can do in my sleep but this is bull. Here's what I got:

1. ODBC Connectors for login, character01, log01, etc. Set up MSSQL 2008 express because 2005 is outdated for my OS. I set up a dummy account called flyff. I can connect successfully when I test the connection but when i turn on the account server, it won't connect. The log error says my user login with name 'flyff' failed.

Did I miss something? The ini's are setup with local ip's (127.0.0.1). C'mon its not this difficult. I bet I'm missing something stupid.


Help me out people and be descriptive.

so your account servers ini should look like this

TEST
AddTail( -1, 1, "Test", "127.0.0.1", 0, 1, 0 );
   AddTail( 1, 1, "Channel 1-1", "127.0.0.1", 0, 1, 600 );

DSN_NAME_LOGIN			"login"
DB_ADMIN_ID_LOGIN		"login"

DSN_NAME_LOG			"log01"
DB_ADMIN_ID_LOG			"log01"

MSG_VER				"20070712"

DB_PWD_LOGIN			""
DB_PWD_LOG			""

your odbc should be set to "SQL Server" not native client as i had problems with it on around page 3 of its setup there should be an option at the top with default database you want to set log01 default database to LOG_01_DBF character01 to CHARACTER_01_DBF and login to ACCOUNT_DBF, im a little fuzzy what you mean by the flyff account is it a mssql login?

[Mohanddo]

Why not just use windows authentication? :S

[KingNoobie]

Glaphan i'll make a guide for you, would be nice if you came on msn too, or i'll just pm it

[jason145]

can you elaborate?

it won't even connect to the database so I don't see the need for that yet.

Ok. Forget what i said the first time. Can you post of a copy of you AccountServer.ini please.

[GlaphanKing]

AddTail (-1, 1, "Glaphan", "192.168.2.2", 0, 1, 0);
AddTail (1, 1, "King", "192.168.2.2", 0, 1, 1100);

DSN_NAME_LOGIN            "login"
DB_ADMIN_ID_LOGIN        "flyff"

DSN_NAME_LOG "log01"
DB_ADMIN_ID_LOG "log01"

// 6
//MSG_VER        "19791221"
//MSG_VER        "19731109"
//MSG_VER        "19731110"
MSG_VER        "20070712"
// 6
DB_PWD_LOGIN    "pass"
DB_PWD_LOG    "pass"

the passwords are not pass. flyff is the test user to connect to ODBC for MSSQL.

[spikensbror]

I don't think you need to specify the DB_ADMIN_ID_LOGIN since the userdata is stored inside ODBC already. Not sure though, but try to change it to "account". That's what i have mine set as. ^^

[GlaphanKing]

bear in mind I'm running Windows 7 Ultimate 64Bit. Oh, yeah! MSSQL 2008 Express.

[MisterKid]

found it
min

AddTail( -1, 1, "IFLYFF", "5.150.27.168", 0, 1, 0 );
AddTail( 1, 1, "BETA", "5.150.27.168", 0, 1, 1100 );

DSN_NAME_LOGIN "flyff"<--
DB_ADMIN_ID_LOGIN "account"

DSN_NAME_LOG "account"
DB_ADMIN_ID_LOG "log01"

// 6
//MSG_VER "19791221"
//MSG_VER "19731109"
//MSG_VER "19731110"
MSG_VER "20070712"
// 6
DB_PWD_LOGIN ""
DB_PWD_LOG ""

it say's DSN_NAME_LOGIN that should be your odbc connection (flyff)

[GlaphanKing]

2009/10/26	17:01:55
query:login
SQLSTATE:28000 error:[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'account'.

Always get this error.

[MisterKid]

2009/10/26	17:01:55
query:login
SQLSTATE:28000 error:[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'account'.

Always get this error.

nvm. uhm let me check 1 sec xD
I use windows authentication (or how ever you spell it)

[Mohanddo]

found it
min

AddTail( -1, 1, "IFLYFF", "5.150.27.168", 0, 1, 0 );
AddTail( 1, 1, "BETA", "5.150.27.168", 0, 1, 1100 );

DSN_NAME_LOGIN "flyff"<--
DB_ADMIN_ID_LOGIN "account"

DSN_NAME_LOG "account"
DB_ADMIN_ID_LOG "log01"

// 6
//MSG_VER "19791221"
//MSG_VER "19731109"
//MSG_VER "19731110"
MSG_VER "20070712"
// 6
DB_PWD_LOGIN ""
DB_PWD_LOG ""

it say's DSN_NAME_LOGIN that should be your odbc connection (flyff)

forgot to say don't change DB_ADMIN_ID_LOG sql files create them in database if im not wrong o.O

I believe DSN_NAME_LOGIN should stay login... That line is for the name of your odbc connecting to your account table.

[MisterKid]

I believe DSN_NAME_LOGIN should stay login... That line is for the name of your odbc connecting to your account table.

idk didn;t he use flyff as login o.o im confused xD but your right about that it should connect to your account db

DB_ADMIN_ID_LOGIN "sa"

DB_PWD_LOGIN "blablabla"

never used this function to connect o.0
Winblows authentication (or however you spelled don't need these information O.o only
DSN_NAME_LOGIN and with database(account) XP
Damn its bed time X.x night.

Good luck GlaphanKing

[spikensbror]

bear in mind I'm running Windows 7 Ultimate 64Bit. Oh, yeah! MSSQL 2008 Express.

So do i, but I'm running MSSQL 2005.
And I've got mine set up as i said. ^^

[Mohanddo]

So glaphan are you saying you have a user called flyff under security->users in the account database?

[gunnerone]

O hi!
Check out my image. I use windows auth only on all the server configs and then just set everything to the odbc dns name. so login and character01 and log01 are the only things i use in the inis. I'm just having issues getting hung up at @ character screen no biggy i'm just packet capturing lol.

[GlaphanKing]

OK. Figured it out. When I set up the connection I forgot to point it to the database like a dumbass.

Solved it.