cake-php
[Arriba] [Todas las Listas]

Re: Conecta a remoto server (mi sql apache)

To: cake-php@xxxxxxxxxxxxxxxx
Subject: Re: Conecta a remoto server (mi sql apache)
From: lowpass <zijn.digital@xxxxxxxxx>
Date: Sat, 1 Jun 2013 13:19:13 -0400
Delivery-date: Sat, 01 Jun 2013 13:19:24 -0400
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlegroups.com; s=20120806; h=x-beenthere:mime-version:in-reply-to:references:date:message-id :subject:from:to:x-original-sender:x-original-authentication-results :reply-to:precedence:mailing-list:list-id:x-google-group-id :list-post:list-help:list-archive:sender:list-subscribe :list-unsubscribe:content-type; bh=difu9fKPkeNJODgDG+7RLYwToNIM9oX4xVJgpdxfeI4=; b=byS6kV/7sxDetD/+F5SeC6JpHMvFOiA30Cnu0Dd7+/MxVi5Cls1zW1dNpPB7NL70mF zQXUibU/RINIRQvGDhlt2fHtVUgxMJKCZ4IJ+dq5701DXBPwKDv6QX6lIYpWpInfGVg6 8LnxSP80HHsp3I0Y304FtGFR6hit7xD1uOb7cIsTZKl6i/bXKqtWiKXAJlB18e7cGzel lgEOGnfANjjL3kwSSga2zQ5NZtrAsrZo0/TwMnFMIAvcmhWZYHb9M3QFsBwMMHw62lcg Id3mCpvQkAxxY98jgElJ0TAStsyqIp9aN2Sv2bdoZBMFabYdH1UhdYzEgXPSgRIaz7nj SvcA==
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=x-beenthere:mime-version:in-reply-to:references:date:message-id :subject:from:to:x-original-sender:x-original-authentication-results :reply-to:precedence:mailing-list:list-id:x-google-group-id :list-post:list-help:list-archive:sender:list-subscribe :list-unsubscribe:content-type; bh=difu9fKPkeNJODgDG+7RLYwToNIM9oX4xVJgpdxfeI4=; b=RLzngiDSg6Y3+OE+WNRx4SY69vBvBC+i/RnYQTMQYZuKQKmIGiIkCPaGLHhzziY1xR 3fPvknx/Vg5U6b+NteOTncpAnEc7Zbmc/CAJGNdyMctXv3zpy+KGGhWklqWYpqgDDxqP j441szA9ndODZFbdY0iYGVr2HKfjj/i7DbnrAu47FuTC9lN8a+qE6tT3FfhAebeT/sdY fP3+a3eW4tt/k+kffmQjtRzl/OfxdYoMiiFmIJW3fvm9sgFtnr5oSmieYPMR3NreflU6 Mh3BTUILX63Wg2PmKU9Uw23ePzoAXyjwBrjSI2rrnmFacJLUEImgsUiIhwQUGv/bzZ68 RKDg==
Envelope-to: traductor@xxxxxxxxxxx
In-reply-to: <e1e38735-68ea-40c4-bf16-91f9bab9f12a@googlegroups.com>
List-archive: <http://groups.google.com/group/cake-php?hl=en>
List-help: <http://groups.google.com/support/?hl=en>, <mailto:cake-php+help@googlegroups.com>
List-id: <cake-php.googlegroups.com>
List-post: <http://groups.google.com/group/cake-php/post?hl=en>, <mailto:cake-php@googlegroups.com>
List-subscribe: <http://groups.google.com/group/cake-php/subscribe?hl=en>, <mailto:cake-php+subscribe@googlegroups.com>
List-unsubscribe: <http://groups.google.com/group/cake-php/subscribe?hl=en>, <mailto:googlegroups-manage+1003367825667+unsubscribe@googlegroups.com>
Mailing-list: list cake-php@xxxxxxxxxxxxxxxx; contact cake-php+owners@xxxxxxxxxxxxxxxx
References: <e1e38735-68ea-40c4-bf16-91f9bab9f12a@googlegroups.com>
Reply-to: cake-php@xxxxxxxxxxxxxxxx
Sender: cake-php@xxxxxxxxxxxxxxxx
Proporcionas la dirección de IP remota y puerto # en el *config. Aun así, el
remoto *db tiene que ser configurado para dejar para conexiones de red. Control
el DB remoto *config para el *skip-*networking y ligar-opciones de dirección.

Entonces también el usuario de DB para la aplicación remota tiene que tener permiso para
conectar. Control el *mysql.Mesa de usuario en el *remoto* *server. Si la columna
Anfitriona para vuestro Usuario sólo incluye un registro para *localhost entonces necesitarás
a GRANT otra vez para el *server IP:

GRANT SELECCIONA,INSERTA,ACTUALIZA,ELIMINA EN *db_remoto.* A 'usuario'@'*xxx.*xxx.*xxx.*xxx'
IDENTIFICADO POR '*thepassword';
*FLUSH PRIVILEGIOS;

(O *db_remoto.Nombre_de mesa si no requieres todo de ellos para ser accedido.)


En *Wed, mayo 29, 2013 en 8:41 AM, *Nikunj *Amipara <*nikamipara29@*xxxxxxxxx>escribió:

> *hi todo,
>  cualquiera tiene cualquier idea cómo para conectar a remoto *server en *cakephp???
> *i Tiene uno local *database que tiene la mayoría de información requerida para
> aplicación para correr pero algún dato es necesitado de remoto *server.
> Significa *i quiere conectar *cakephp a 2 *databases a la vez uno local y uno
> remoto lo es posible?
> Puede cualquiera ayuda ?
>
> *thanks.
>
> --
> Gustarnos en *FaceBook *https://www.facebook.com/*CakePHP
> nos Encuentra en *Twitter *http://*twitter.*com/*CakePHP
>
> ---
> Recibiste este mensaje porque eres *subscribed al *Google Grupos
> "*CakePHP" grupo.
> A *unsubscribe de este grupo y la parón que recibe *emails de él, enviar un
> *email a pastel-*php+unsubscribe@xxxxxxxxxxxxxxxx.
> A correo a este grupo, envía *email a pastel-php@xxxxxxxxxxxxxxxx.
> Visita este grupo en *http://grupos.*google.*com/Pastel/de grupo-*php?*hl=*en.
> Para más opciones, visita *https://grupos.*google.*com/Los Grupos/optan_fuera.
>
>
>

-- 
Gustarnos en *FaceBook *https://www.facebook.com/*CakePHP
nos Encuentra en *Twitter *http://*twitter.*com/*CakePHP

--- 
Recibiste este mensaje porque eres *subscribed al *Google Grupos "*CakePHP" grupo.
A *unsubscribe de este grupo y la parón que recibe *emails de él, enviar un *email a pastel-*php+unsubscribe@xxxxxxxxxxxxxxxx.
A correo a este grupo, envía *email a pastel-php@xxxxxxxxxxxxxxxx.
Visita este grupo en *http://grupos.*google.*com/Pastel/de grupo-*php?*hl=*en.
Para más opciones, visita *https://grupos.*google.*com/Los Grupos/optan_fuera.


You provide the remote IP address and port # in the config. However, the
remote db must be configured to allow for network connections. Check the
remote DB config for the skip-networking and bind-address options.

Then also the DB user for the remote application must have permission to
connect. Check the mysql.user table on the *remote* server. If the Host
column for your User only includes a record for localhost then you'll need
to GRANT again for the server IP:

GRANT SELECT,INSERT,UPDATE,DELETE ON db_remote.* TO 'user'@'xxx.xxx.xxx.xxx'
IDENTIFIED BY 'thepassword';
FLUSH PRIVILEGES;

(Or db_remote.table_name if you don't require all of them to be accessed.)


On Wed, May 29, 2013 at 8:41 AM, Nikunj Amipara <nikamipara29@xxxxxxxxx>wrote:

> hi all,
> Does any one have any idea how to connect to remote server in cakephp???
> i have one local database which does have most of required information for
> application to run but some data is needed from remote server.
> it means i want to connect cakephp to 2 databases at a time one local and
> one remote is it possible?
> can any one help ?
>
> thanks.
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscribe@xxxxxxxxxxxxxxxx.
> To post to this group, send email to cake-php@xxxxxxxxxxxxxxxx.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@xxxxxxxxxxxxxxxx.
To post to this group, send email to cake-php@xxxxxxxxxxxxxxxx.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


<Anterior por Tema] Tema Actual [Siguiente por Tema>
  • Re: Conecta a remoto server (mi sql apache), lowpass <=