Re: single database ... many aplications

2006-05-08 Thread Barry

jehova villa martinez schrieb:
Hi, as newbie and with some trubles understanding English language, i 
have a question that I don’t know howto put on search engines (I don’t 
know technical keywords for my particular case). This is why I post here.


This is the whole picture:
I have four programs running on my place,
Freeradius
http://www.freeradius.org/

metadot web portal
http://www.metadot.com/index_static.html

mail toaster con qmail
http://www.tnpi.biz/internet/mail/toaster/

y Xpanel
http://www.xpanel.com/

each of them use MySQL and they has different databases and different 
tables...this four applications handle same usernames and password for 
same users, I mean same user has an e-mail account, and uses same 
username and password for authenticate freeradius modem access for a 
protmaster3, same username and password for login our  metadot portal, 
and…. Same thing for access Xpanel virtual hosting for their home page.


How can I use just one shared common database for use of all of my 
portal applications? Is this possible?  It would be nice if I have a 
single login feature for all… is MySQL related topic or is particular 
hack for each program?


Thank you for share  any experience related or knowledge about this doubt.

best regards from mexico,




Yes.
You have to set the GRANT provilegies that way, that Applications can 
connect to the Database which has the Users from outside.

Just replace 'localhost' with '%' in the Mysql tables.

That way the other servers can access this Database and get the Users 
from it.


Greets
Barry

--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



single database ... many aplications

2006-05-05 Thread jehova villa martinez
Hi, as newbie and with some trubles understanding English language, i have a 
question that I don’t know howto put on search engines (I don’t know 
technical keywords for my particular case). This is why I post here.


This is the whole picture:
I have four programs running on my place,
Freeradius
http://www.freeradius.org/

metadot web portal
http://www.metadot.com/index_static.html

mail toaster con qmail
http://www.tnpi.biz/internet/mail/toaster/

y Xpanel
http://www.xpanel.com/

each of them use MySQL and they has different databases and different 
tables...this four applications handle same usernames and password for same 
users, I mean same user has an e-mail account, and uses same username and 
password for authenticate freeradius modem access for a protmaster3, same 
username and password for login our  metadot portal, and…. Same thing for 
access Xpanel virtual hosting for their home page.


How can I use just one shared common database for use of all of my portal 
applications? Is this possible?  It would be nice if I have a single login 
feature for all… is MySQL related topic or is particular hack for each 
program?


Thank you for share  any experience related or knowledge about this doubt.

best regards from mexico,



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]