How to configure a separate Database server for ERPNext

I want to install ERPNext files on one server and MySQL Database on a separate server. Please tell the location of configuration file and the parameters to add.

Thanks.



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.

    For more options, visit https://groups.google.com/groups/opt_out.
Yes please, I am interested to know too.

On Wednesday, 13 November 2013 14:51:51 UTC+8, Haris Khan wrote:
I want to install ERPNext files on one server and MySQL Database on a separate server. Please tell the location of configuration file and the parameters to add.

Thanks.



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.

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

P

lease, see my configuration

gunicorn.conf for supervisor

[program:gunicorn_mxmo]
command=gunicorn -b 127.0.0.1:7999 -w 2 lib.webnotes.app:application
directory=home/apra/mxmo
process_name=%(program_name)s
autostart=True
autorestart=True
redirect_stderr=True

[program:gunicorn_realize]
command=gunicorn -b 127.0.0.1:8000 -w 2 lib.webnotes.app:application
directory=/home/apra/next
user=erpnext
process_name=%(program_name)s
autostart=True
autorestart=True
redirect_stderr=True

[program:gunicorn_demo]
command=gunicorn -b 127.0.0.1:8001 -w 2 lib.webnotes.app:application
directory=/home/apra/demo
process_name=%(program_name)s
autostart=True
autorestart=True
redirect_stderr=True

erpnext-mxmo.conf

upstream erpnextmxmo {
server <a href="http://127.0.0.1:7999">127.0.0.1:7999</a> fail_timeout=0;    

}

server {
listen 80;
server_name $hostname;
client_max_body_size 4G;
server_name localhost;
keepalive_timeout 5;
root /home/maxwell/mxmo;

location / {
    try_files $uri @magic;
}

location @magic {
    proxy_set_header X-Forwaded-For $proxy_add_x_forwarded_for;
    proxy_set_header Host $http_host;
    proxy_redirect off;
    proxy_pass <a href="http://erpnextmxmo">http://erpnextmxmo</a>;
}

}

erpnext-realize.conf

upstream erpnextrealize {
    server 127.0.0.1:8000 fail_timeout=0;    
}

server {
listen 8080;
server_name $hostname;
client_max_body_size 4G;
server_name localhost;
keepalive_timeout 5;
root /home/maxwell/next/public;

location / {
    try_files $uri @magic;
}

location @magic {
    proxy_set_header X-Forwaded-For $proxy_add_x_forwarded_for;
    proxy_set_header Host $http_host;
    proxy_redirect off;
    proxy_pass <a href="http://erpnextrealize">http://erpnextrealize</a>;
}

}

erpnext-demo.conf

upstream erpnextdemo {
    server 127.0.0.1:8001 fail_timeout=0;    
}

server {
listen 8081;
server_name $hostname;
client_max_body_size 4G;
server_name localhost;
keepalive_timeout 5;
root /home/apra/demo;

location / {
    try_files $uri @magic;
}

location @magic {
    proxy_set_header X-Forwaded-For $proxy_add_x_forwarded_for;
    proxy_set_header Host $http_host;
    proxy_redirect off;
    proxy_pass <a href="http://erpnextdemo">http://erpnextdemo</a>;
}

}



2013/11/13 CJ <jo...@gmail.com>
Yes please, I am interested to know too.


On Wednesday, 13 November 2013 14:51:51 UTC+8, Haris Khan wrote:
I want to install ERPNext files on one server and MySQL Database on a separate server. Please tell the location of configuration file and the parameters to add.

Thanks.



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.

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




--

Maxwell Morais
Tecnologia da Informação
+55 11 3931-1412 Ramal 31

www.realizemodulados.com.br



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.

    For more options, visit https://groups.google.com/groups/opt_out.
I'm sorry, this response is to another thead



2013/11/13 Maxwell Morais <ma...@gmail.com>
P
lease, see my configuration

gunicorn.conf for supervisor

[program:gunicorn_mxmo]
command=gunicorn -b 127.0.0.1:7999 -w 2 lib.webnotes.app:application
directory=home/apra/mxmo
process_name=%(program_name)s
autostart=True
autorestart=True
redirect_stderr=True

[program:gunicorn_realize]
command=gunicorn -b 127.0.0.1:8000 -w 2 lib.webnotes.app:application
directory=/home/apra/next
user=erpnext
process_name=%(program_name)s
autostart=True
autorestart=True
redirect_stderr=True

[program:gunicorn_demo]
command=gunicorn -b 127.0.0.1:8001 -w 2 lib.webnotes.app:application
directory=/home/apra/demo
process_name=%(program_name)s
autostart=True
autorestart=True
redirect_stderr=True

erpnext-mxmo.conf

upstream erpnextmxmo {
server <a href="http://127.0.0.1:7999" target="_blank">127.0.0.1:7999</a> fail_timeout=0;    

}

server {
listen 80;
server_name $hostname;
client_max_body_size 4G;
server_name localhost;
keepalive_timeout 5;
root /home/maxwell/mxmo;

location / {
    try_files $uri @magic;
}

location @magic {
    proxy_set_header X-Forwaded-For $proxy_add_x_forwarded_for;
    proxy_set_header Host $http_host;
    proxy_redirect off;
    proxy_pass <a href="http://erpnextmxmo" target="_blank">http://erpnextmxmo</a>;
}

}

erpnext-realize.conf

upstream erpnextrealize {
    server 127.0.0.1:8000 fail_timeout=0;    
}

server {
listen 8080;
server_name $hostname;
client_max_body_size 4G;
server_name localhost;
keepalive_timeout 5;
root /home/maxwell/next/public;

location / {
    try_files $uri @magic;
}

location @magic {
    proxy_set_header X-Forwaded-For $proxy_add_x_forwarded_for;
    proxy_set_header Host $http_host;
    proxy_redirect off;
    proxy_pass <a href="http://erpnextrealize" target="_blank">http://erpnextrealize</a>;
}

}

erpnext-demo.conf

upstream erpnextdemo {
    server 127.0.0.1:8001 fail_timeout=0;    
}

server {
listen 8081;
server_name $hostname;
client_max_body_size 4G;
server_name localhost;
keepalive_timeout 5;
root /home/apra/demo;

location / {
    try_files $uri @magic;
}

location @magic {
    proxy_set_header X-Forwaded-For $proxy_add_x_forwarded_for;
    proxy_set_header Host $http_host;
    proxy_redirect off;
    proxy_pass <a href="http://erpnextdemo" target="_blank">http://erpnextdemo</a>;
}

}





--

Maxwell Morais

Tecnologia da Informação

+55 11 3931-1412 Ramal 31
www.realizemodulados.com.br



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.

    For more options, visit https://groups.google.com/groups/opt_out.
1. use lib/wnf.py --backup for backup the database
2. import the backuped database to the mysql server
3. create a user on the mysql server
4. modify erpnext/conf.py:
    a. add db_host = '<mysql server ip>'
    b. update the db_name and db_password as the new one.
5. start the erpnext server and try
6. if you created mysql user can't connect the DB, see the error message and create another one that match the error message mentioned user and host
 
I've tried these steps, only the error that the us...@host is wrong. Just create a user with right host.
 
BTW, if you want to user the local DB, just comment out the db_host line.
 

On Wednesday, November 13, 2013 2:51:51 PM UTC+8, Haris Khan wrote:
I want to install ERPNext files on one server and MySQL Database on a separate server. Please tell the location of configuration file and the parameters to add.

Thanks.



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/ea047d94-99f4-4c7a-bf64-a80d9e4723b0%40googlegroups.com.

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