[Spce-user] Utilizing Remote Database

[Kevin Masse]

Hello Daniel, I was still wondering if I missed something from your
answer on 11/26.

It seems you picked up from another part of a message.

 

Was there something before your post on the Grants?

 

The main outstanding question for sure is:  Do I only need to edit the
constants.yml as indicated below in the original post?

If that is accurate then I will deal with any permissions / Grants or
access issues on the remote server.  I just want to save time by not
chasing other potential issues.

 

Thank you in advance,

 

Kevin

 

 

 

 

From: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] On Behalf
Of Kevin Masse
Sent: Wednesday, November 26, 2014 2:56 PM
To: Daniel Grotti; spce-user at lists.sipwise.com
Subject: Re: [Spce-user] Utilizing Remote Database

 

Hello Daniel, thanks for the reply however I think your first thoughts
were not sent.  It seems this email picks up from a different part of
your conversation.

 

I do agree however regarding the GRANTS Etc, we are not having any
issues connecting to the external DB via command line.

I think we are only down to what parameters need to be set and which
file should be checked.

 

Thanks

Kevin

 

 

From: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] On Behalf
Of Daniel Grotti
Sent: Wednesday, November 26, 2014 8:04 AM
To: spce-user at lists.sipwise.com
Subject: Re: [Spce-user] Utilizing Remote Database

 

Hi,
another thing I have in mind are the GRANTS on the db.
if you dump the DB, the current mysql grants are for localhost only.
You should check this out.


Daniel



On 11/25/2014 11:16 PM, Kevin Masse wrote:

	Hello group:

	I have a question relating to using an external DB in v2.8

	 

	Are there specific steps that I can follow that are not in the
manual to use an external database.

	 

	In the constants.yml there is only one reference to the database
location:

	 

	Can I edit the following from

	database:

	  dbhost: localhost           

	  dbport: 3306

	 

	TO:

	database:

	  dbhost: x.x.x.x (IP Address)      

	  dbport: 3306

	 

	 

	What else would be required?

	 

	Of course that is with the understanding that I have a dump of
the database on the second machine.

	 

	Thanks

	Kevin

	 

	
	
	

	_______________________________________________
	Spce-user mailing list
	Spce-user at lists.sipwise.com
	https://lists.sipwise.com/listinfo/spce-user

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20141208/c12c55c6/attachment.html>