Non-Local MySQL/MariaDB Database Server Instance

1
Dear All,
First of all, thank you very much for this great piece of software.
I have been trying to install ERPNext via Frappe using a non-local MySQL/MariaDB database server, but fail to see where I can enter the appropriate database login credentials and connection details. It seems that Frappe/ERPNext is hard-coded to use a local MySQL/MariaDB socket.
Is there, other than using socat, a clean way around it by modifying some configuration file in the setup?
Thanks a lot for letting me know.
Bests,
Chris

–

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/8d6e12ee-1938-453f-b6aa-1b39ebc6386f%40googlegroups.com.

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

Sorry thats not intuitive at the moment, we will fix it soon.

Once you create a site, add "db_host" as your remote host in `site_config.json` in your site folder and run --reinstall

Related issue: https://github.com/frappe/frappe/issues/692

@Pratik - second query in a week. Can you fix this on priority today.

thanks,
Rushabh



@rushabh_mehta

On 18-Jul-2014, at 9:05 am, Christoph H. Larsen <ch...@gmail.com> wrote:

Dear All,
First of all, thank you very much for this great piece of software.
I have been trying to install ERPNext via Frappe using a non-local MySQL/MariaDB database server, but fail to see where I can enter the appropriate database login credentials and connection details. It seems that Frappe/ERPNext is hard-coded to use a local MySQL/MariaDB socket.
Is there, other than using socat, a clean way around it by modifying some configuration file in the setup?
Thanks a lot for letting me know.
Bests,
Chris

–

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/8d6e12ee-1938-453f-b6aa-1b39ebc6386f%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/AE593F29-4572-49C3-BDD5-D65575E1124B%40gmail.com.

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

On Fri, Jul 18, 2014 at 10:03 AM, Rushabh Mehta rm...@gmail.com wrote:

Chris,

Sorry thats not intuitive at the moment, we will fix it soon.

Once you create a site, add “db_host” as your remote host in
site_config.json in your site folder and run --reinstall

Related issue: Specify Database host name while installing the erpnext · Issue #692 · frappe/frappe · GitHub

@Pratik - second query in a week. Can you fix this on priority today.

Yes, will look into this today.

thanks,
Rushabh

@rushabh_mehta
https://erpnext.org

On 18-Jul-2014, at 9:05 am, Christoph H. Larsen
ch...@gmail.com wrote:

Dear All,
First of all, thank you very much for this great piece of software.
I have been trying to install ERPNext via Frappe using a non-local
MySQL/MariaDB database server, but fail to see where I can enter the
appropriate database login credentials and connection details. It seems that
Frappe/ERPNext is hard-coded to use a local MySQL/MariaDB socket.
Is there, other than using socat, a clean way around it by modifying some
configuration file in the setup?
Thanks a lot for letting me know.
Bests,
Chris

–
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/8d6e12ee-1938-453f-b6aa-1b39ebc6386f%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/AE593F29-4572-49C3-BDD5-D65575E1124B%40gmail.com.

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

–
Pratik
erpnext

4

I have responded in details here:
Specify Database host name while installing the erpnext · Issue #692 · frappe/frappe · GitHub, with some extra
suggestions. Thanks a lot!

On 18/07/14 12:21, Pratik Vyas wrote:

On Fri, Jul 18, 2014 at 10:03 AM, Rushabh Mehta rm...@gmail.com wrote:

Chris,

Sorry thats not intuitive at the moment, we will fix it soon.

Once you create a site, add “db_host” as your remote host in
site_config.json in your site folder and run --reinstall

Related issue: Specify Database host name while installing the erpnext · Issue #692 · frappe/frappe · GitHub

@Pratik - second query in a week. Can you fix this on priority today.

Yes, will look into this today.

thanks,
Rushabh

@rushabh_mehta
https://erpnext.org

On 18-Jul-2014, at 9:05 am, Christoph H. Larsen
ch...@gmail.com wrote:

Dear All,
First of all, thank you very much for this great piece of software.
I have been trying to install ERPNext via Frappe using a non-local
MySQL/MariaDB database server, but fail to see where I can enter the
appropriate database login credentials and connection details. It seems that
Frappe/ERPNext is hard-coded to use a local MySQL/MariaDB socket.
Is there, other than using socat, a clean way around it by modifying some
configuration file in the setup?
Thanks a lot for letting me know.
Bests,
Chris

–
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/53C8B5D8.4040700%40gmail.com.
For more options, visit https://groups.google.com/d/optout.