Use Separate Database Server for ERPNEXT installation

Hi,

How to install ERPNEXT using separate database server. I can't find anything where I can provide database host name. Please help me.


Thanks,
Dhaval Patel



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/76ea5c41-daac-407e-b77b-0b564b4194db%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.

On Thu, Jul 10, 2014 at 7:45 PM, Dhaval Patel pa...@gmail.com wrote:

Hi,

How to install ERPNEXT using separate database server. I can’t find anything
where I can provide database host name. Please help me.

Thanks,
Dhaval Patel


Note:

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much
    information as you can. Please see it from the point of view of the person
    receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send
    only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do
    not send images as attachments. Links are good. Same goes for any file you
    are going to send.

End of Note

You received this message because you are subscribed to the Google Groups
“ERPNext Developer Forum” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/erpnext-developer-forum/76ea5c41-daac-407e-b77b-0b564b4194db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Dhaval,

You can specify db_host in site_config.json


Pratik
erpnext

Pratik,

Great, it worked for installed erpnext instance. How to specify host name while installing the erpnext.


On Thursday, July 10, 2014 7:47:20 PM UTC+5:30, Pratik Vyas wrote:
On Thu, Jul 10, 2014 at 7:45 PM, Dhaval Patel <pa...@gmail.com> wrote:
> Hi,
>
> How to install ERPNEXT using separate database server. I can't find anything
> where I can provide database host name. Please help me.
>
>
> Thanks,
> Dhaval Patel
>
> --
> Note:
>
> If you are posting an issue,
> 1. We should be able to replicate it at our end. So please give us as much
> information as you can. Please see it from the point of view of the person
> receiving the communication.
> 2. Paste your code at http://pastebin.com or http://gist.github.com and send
> only the URL via email
> 3. For sending images, use http://imgur.com or other similar services. Do
> not send images as attachments. Links are good. Same goes for any file you
> are going to send.
>
> End of Note
> ---
> You received this message because you are subscribed to the Google Groups
> "ERPNext Developer Forum" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to erpnext-developer-forum+un...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/erpnext-developer-forum/76ea5c41-daac-407e-b77b-0b564b4194db%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

Hi Dhaval,

You can specify db_host in site_config.json

--
Pratik
erpnext



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/e44b092b-7ede-418f-9fdd-aec474ed1e9e%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.

On Thu, Jul 10, 2014 at 8:48 PM, Dhaval Patel pa...@gmail.com wrote:

Pratik,

Great, it worked for installed erpnext instance. How to specify host name
while installing the erpnext.

I haven’t tried that and I don’t it’s covered in the installer. Can
you raise a github issue for this (in frappe/frappe)?

On Thursday, July 10, 2014 7:47:20 PM UTC+5:30, Pratik Vyas wrote:

On Thu, Jul 10, 2014 at 7:45 PM, Dhaval Patel pa...@gmail.com
wrote:

Hi,

How to install ERPNEXT using separate database server. I can’t find
anything
where I can provide database host name. Please help me.

Thanks,
Dhaval Patel


Note:

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as
    much
    information as you can. Please see it from the point of view of the
    person
    receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and
    send
    only the URL via email
  3. For sending images, use http://imgur.com or other similar services.
    Do
    not send images as attachments. Links are good. Same goes for any file
    you
    are going to send.

End of Note

You received this message because you are subscribed to the Google
Groups
“ERPNext Developer Forum” group.
To unsubscribe from this group and stop receiving emails from it, send
an
email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit

https://groups.google.com/d/msgid/erpnext-developer-forum/76ea5c41-daac-407e-b77b-0b564b4194db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Dhaval,

You can specify db_host in site_config.json


Pratik
erpnext


Note:

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much
    information as you can. Please see it from the point of view of the person
    receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send
    only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do
    not send images as attachments. Links are good. Same goes for any file you
    are going to send.

End of Note

You received this message because you are subscribed to the Google Groups
“ERPNext Developer Forum” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/erpnext-developer-forum/e44b092b-7ede-418f-9fdd-aec474ed1e9e%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.


Pratik
erpnext

I don't think db_host is a parameter yet (yes raise the issue). hardcode here for now:

https://github.com/frappe/frappe/blob/develop/frappe/database.py#L23



On 10-Jul-2014, at 8:48 pm, Dhaval Patel <pa...@gmail.com> wrote:

Pratik,

Great, it worked for installed erpnext instance. How to specify host name while installing the erpnext.


On Thursday, July 10, 2014 7:47:20 PM UTC+5:30, Pratik Vyas wrote:
On Thu, Jul 10, 2014 at 7:45 PM, Dhaval Patel <pa...@gmail.com> wrote:
> Hi,
>
> How to install ERPNEXT using separate database server. I can't find anything
> where I can provide database host name. Please help me.
>
>
> Thanks,
> Dhaval Patel
>
> --
> Note:
>
> If you are posting an issue,
> 1. We should be able to replicate it at our end. So please give us as much
> information as you can. Please see it from the point of view of the person
> receiving the communication.
> 2. Paste your code at http://pastebin.com or http://gist.github.com and send
> only the URL via email
> 3. For sending images, use http://imgur.com or other similar services. Do
> not send images as attachments. Links are good. Same goes for any file you
> are going to send.
>
> End of Note
> ---
> You received this message because you are subscribed to the Google Groups
> "ERPNext Developer Forum" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to erpnext-developer-forum+un...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/erpnext-developer-forum/76ea5c41-daac-407e-b77b-0b564b4194db%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

Hi Dhaval,

You can specify db_host in site_config.json

--
Pratik
erpnext



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/e44b092b-7ede-418f-9fdd-aec474ed1e9e%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/4DAF5F25-FED9-4C72-8A68-CCC09E4E41BE%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.
Thank you for your prompt replies. I did created an issue in frappe/frappe as requested.

On Thursday, July 10, 2014 7:45:16 PM UTC+5:30, Dhaval Patel wrote:
Hi,

How to install ERPNEXT using separate database server. I can't find anything where I can provide database host name. Please help me.


Thanks,
Dhaval Patel



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/4ebe6b24-1265-42da-ac3c-8c9f3165b54a%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
Dear Experts,

I could change the line "self.host = host or frappe.conf.db_host or 'localhost'" to "self.host = host or frappe.conf.db_host or 'DB_SERVER_IP'" and the install program would create the database in the external DB server which is great.

But it will also create user accounts in the database server that will limit the account to be connected from "localhost" only. Which script can we specify such that, the user account that is created, can be accessed from remotely?

Thank you.


Javier

On Friday, July 11, 2014 12:39:36 AM UTC+8, rushabh wrote:
I don't think db_host is a parameter yet (yes raise the issue). hardcode here for now:

https://github.com/frappe/frappe/blob/develop/frappe/database.py#L23



On 10-Jul-2014, at 8:48 pm, Dhaval Patel <pa...@gmail.com> wrote:

Pratik,

Great, it worked for installed erpnext instance. How to specify host name while installing the erpnext.


On Thursday, July 10, 2014 7:47:20 PM UTC+5:30, Pratik Vyas wrote:
On Thu, Jul 10, 2014 at 7:45 PM, Dhaval Patel <pa...@gmail.com> wrote:
> Hi,
>
> How to install ERPNEXT using separate database server. I can't find anything
> where I can provide database host name. Please help me.
>
>
> Thanks,
> Dhaval Patel
>
> --
> Note:
>
> If you are posting an issue,
> 1. We should be able to replicate it at our end. So please give us as much
> information as you can. Please see it from the point of view of the person
> receiving the communication.
> 2. Paste your code at http://pastebin.com or http://gist.github.com and send
> only the URL via email
> 3. For sending images, use http://imgur.com or other similar services. Do
> not send images as attachments. Links are good. Same goes for any file you
> are going to send.
>
> End of Note
> ---
> You received this message because you are subscribed to the Google Groups
> "ERPNext Developer Forum" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to erpnext-developer-forum+un...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/erpnext-developer-forum/76ea5c41-daac-407e-b77b-0b564b4194db%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

Hi Dhaval,

You can specify db_host in site_config.json

--
Pratik
erpnext



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/e44b092b-7ede-418f-9fdd-aec474ed1e9e%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/3d9a1c70-bb67-45eb-9c78-665c06fc7d9f%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.