kooleyo

if any1 can help me with this task, I'm tryin to install mambo on a server (www.aaa.com) but this server does not have MySql installed, so I'm trying to use a database from another server (www.bbb.com) is this thing possible?

Allready did this: on server www.bbb.com
1.- added user and password in the database with an ODBC connection with the IP address of www.aaa.com

How can i connect www.aaa.com Mambo script whit www.bbb.com database??

thanx in advance.
Diego

X-F4CT0R

I don't think that this would be possible, so I wouldn't know how to help you.

__________________
CoastDigital: www.coastdigital.net

Professional Web Design Services (Including mambo)

Arnes Hadzic

kooleyo

Anyone else, i really need to know if this is possible.

i already created a DB in the server where Mysql is installed, and add an ODBC Connection to that DB using the IP address of the server where i'm installing Mambo. So, when i'm running mambo installation i fill all the text fields such as DB User, DB password, DB Name, Prefix and in the field HOST NAME instead of 'localhost' i simply enter the ip address of the server where mysql is installed. but i get a notice THE USERNAME AND PASSWORD PROVIDED ARE INCORRECT.

What am i doing wrong?

dot°NETt

In general: it _is_ possible.

But I don't understand, why you add an ODBC-connection?

Your mySQL-server is running -> ok.
The mambo-database is created -> ok.
You set up - using for instance phpMyAdmin - a new user with full rights for this database (user root is not a good idea for external access): could be mamboadmin.
In phpMyAdmin: load Privileges >> Add a new user >> Login Information >> User name: [mamboadmin]; Host: [%]; Password: [Your pass] >> Go.
At least Database-specific privileges >> Add privileges on the following database: [mambo].

Now you're able to connect to this database from everywhere using the name of this (new) user, the password, databasename and the IP from the host where your mySQL-server is running.

cu dot°NETt

kooleyo

Thanx for the answer, I'm new at this mambo thing, about de ODBC connection: reading the MySqL documentation on the webserver where it is installed it says that i need to create an ODBC connection for security 'cuz only the ip address - user that i set for this connection would be able to create or modify this table.

Could you be a little more specific on the solution you gave, i'm not quite following at the HOST : [%]. do i have to put the IP Address or that symbol?

Aaron

You do not need to do anything other than fill in the server name in the config file. The default is localhost but you need to change it to whatever your host is that is the DB server. Then fill in the rest for the user/pass etc.

All my hosting is done in a cluster so the MySQL server is just that, same with the web and email servers etc. So every site I setup and all my clients setup they just need to change the localhost to the name of our MySQL server and all is good. In other words it works fine, I have done it lots and so have my clients.

__________________
NetFuel Professional Hosting Services

dot°NETt

It's right.
But: the database-user must have the privileges to access the database from Any Host (that is what % means).

You can change and set the privileges with phpMyAdmin only if you have root-access to your database.
For my databases I set up these privileges so, that in normal cases a user can access the database only from localhost (for security reasons the user root too).
In special cases I create a new user with the privilege to access the database from Any Host - but only with privileges for one database (no grant privileges!).

If you don't have root-access to your databases it depends on your hoster and the admininterface you can use to manage your server/webspace >> there should be an option to allow external access to the database (the default option is mostly no external access) ... or ask your hoster.

cu dot°NETt

Blorf

If you know that you will be accessing the database from a
specific host (www.aaa.com in your example) then this is
what you should specify in the permissions on the database.

The % is a wildcard that will give access to the database to
any host that authenticates with the username and password
you set up and this is a security hole. That means if I can
manage to read your config file I will be able to access your
database from my laptop unless there's a firewall protecting it.

kooleyo

Thank you very much to all, now I have my site running specifying the host from where i'm accessing the DB with the user-pass-host settings (for security reasons). I asked my hoster about this and he tells me that all the changes (create new DB - User -Pass) takes effect 10 minutes later, that`s why i wasn't able to access this DB from other server (in my case took more than 30 minutes). Anyway it was a new experience, and also was challengin for me as a newbie at this mambo thing.

Aaron

Good catch on the security hole of the % I did not think to include that

__________________
NetFuel Professional Hosting Services