We have installed virtualbox 5.0 & successfully installed ERPNext-250216.ova.
It will run on localhost:8080 with blank data base. But if we try to restore , it shows Internal Server Error .
We have followed below steps to restore backup file:
Copy backup_sql_file into /frappe-bench directory
enter command: bench --force restore database_file_name.sql
It shows no error in terminal, but in browser it shows Internal Server Error
Kindly suggest correct method to restore SQL file in detail.
vjFaLk
April 21, 2016, 1:53pm
#2
Hi, can you download the latest VM and restore the backup?
Also run bench migrate
after you restore. That should do it.
1 Like
@vjFaLk how to copy back file to /frappe-bench of vm as its ip address is 10.0.2.15.?
But our local system ip is 192.168.0.72
@vjFaLk how to copy backup file to /frappe-bench of vm as its ip address is 10.0.2.15.?
But our local system ip is 192.168.0.72
[/quote]
vjFaLk
April 21, 2016, 2:44pm
#5
How did you copy it before?
You can change the VM Settings to change the network connection to Bridged, so it’ll connect directly to the network, and then transfer the file via File Share or FTP.
FTP Username and Password are frappe
and the port is 22
@vjFaLk as we are using linux, copied sql file to /frappe-bench/ using scp command.
What will be the next steps?
Do I need to create new site using “bench new-site site1.local”?
Then to restore “bench --site site1.local --force restore file_name.sql” ?
Then is there any commands?
vjFaLk
April 22, 2016, 6:11am
#7
@Ram_Gopal_Rao Try first without creating a new site
bench --force restore file_name.sql
bench migrate
@vjFaLk It Shows error: no module named frappe_subscription
@vjFaLk still shows the same error
@Ram_Gopal_Rao i just had almost the same problem, but when i tried it with root user instead of frappe user it worked and restored already…
if you rely in your ERP on frappe_subscription then reinstall it then try as root user…
@ramielian what is root password?
@Ram_Gopal_Rao did you activate root user? if not then using your main user (the main user not frappe user) make:
sudo passwd root
then enter your password once
then enter root password twice…
vjFaLk
April 22, 2016, 6:40am
#14
@ramielian frappe_subscription is an app that is installed on our cloud servers. @Ram_Gopal_Rao has probably downloaded the backup from their cloud server. I’m unsure if running it as root would work.
@Ram_Gopal_Rao Try this then
bench --site erpnext.vm --force restore file_name.sql
bench --site erpnext.vm remove-from-installed-apps frappe_subscription
bench --site erpnext.vm migrate
@vjFaLk
To restore i used “bench --force --site ramgopal restore file_name.sql”
It asked Mysql password & completed the process.
But when I used “bench --site ramgopal migrate” It Shows error: no module named frappe_subscription.
vjFaLk
April 22, 2016, 7:38am
#16
Did you make a new site ramgopal
?
Did you do bench --site ramgopal remove-from-installed-apps frappe_subscription
?
Now it shows eroor: no module named mandrill_integration
1 Like
@vjFaLk
i usd
bench --site ramgopal remove-from-installed-apps mandrill_integration
bench --site ramgopal remove-from-installed-apps knowledge_base
and completed “bench --site ramgopal migrate” successfully.
But how to open new site in browser? when I used http://localhost:8080 it dint accepted my user name & password…
kindly help
1 Like
vjFaLk
April 22, 2016, 8:19am
#19
Because you made a new site you gotta change some setting to make it work.
bench config dns_multitenant off
bench set-nginx-port ramgopal 80
bench setup nginx
sudo service nginx restart
You should see your website at http://localhost
@vjFaLk
it shows error while “bench set-nginx-port ramgopal 80”
“Port 80 is being used by another site ramgopal”