[Spce-user] Utilizing Remote Database
Kevin Masse
kmasse at questblue.com
Mon Dec 8 14:51:16 EST 2014
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>
More information about the Spce-user
mailing list