2 DB, same server, different username

Fetches the last 20 loots from eqdkp

Moderator: Thumann

2 DB, same server, different username

Postby sturmy » Fri Aug 25, 2006 3:31 pm

Great stuff! I was thrilled when I saw that I could get my DKP info out of ANOTHER DB than the one I use for my roster (bloody free hosts with limited spaces / concurrent logins...).

Unfortunately, after installing and configuring... well it didn't work!

The error returned is clearly linked to MySQL connexions. I have the same (remote) server for BOTH my Roster DB and my EQDKP DB, however, I have to connect with 2 separate logon / passwords.
Roster: Host_A / Login_A / Password_A / DB_A
EQDKP: Host_A / Login_B / Password_B / DB_B

Result: Table 'DB_A.eqdkp_config' doesn't exist

Although I can swear I have entered all the *_B info in the config file. It is as if the mysql_connect went smoothly but returned the link to DB_A silently.

Any help appreciated!
sturmy
WR.net Expert
WR.net Expert
 
Posts: 160
Joined: Wed Aug 16, 2006 9:07 pm

2 DB, same server, different username

Postby foreseit » Sat Aug 26, 2006 11:52 pm

That's odd. I have a similar set up with a different database for my dkp than my roster. I had no difficulties. The config file only wants the DKP database info so it seem to be odd that it would somehow look up the roster database info.
User avatar
foreseit
WR.net Journeyman
WR.net Journeyman
 
Posts: 139
Joined: Tue Jul 25, 2006 10:03 pm

Re: 2 DB, same server, different username

Postby sturmy » Sun Aug 27, 2006 1:37 am

yeah. At first I thought I mistyped. Then I thought a "2" slipped of the SQL query... and at the end I suspect the connexion to the Roster DB stays up for whatever reason.

But my (limited) knowledge of MySQL stops there... anyone with a lead is welcome. I tried searching for extra "do open a new connexion" parameters for mySQL_connect to no success...
sturmy
WR.net Expert
WR.net Expert
 
Posts: 160
Joined: Wed Aug 16, 2006 9:07 pm

2 DB, same server, different username

Postby Thumann » Mon Aug 28, 2006 3:08 pm

Hi,
I'll do some testing on this and report back..

It shouldn't be a problem.. at all
Regs. Thumann
http://fc-guild.org | Go Joomla! | Author of the Joomla Integration Guide
Thumann
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 78
Joined: Mon Jul 10, 2006 11:03 pm
Location: Copenhagen, Denmark


Return to Latest Loots

Who is online

Users browsing this forum: No registered users and 1 guest

cron