--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/2WDjsPBW1EAJ.
For more options, visit https://groups.google.com/groups/opt_out.
Aditya,We are still not sure what caused the outage - our logs did not show up anything, it could be the query we are not sure yet.To make your local copy, download you backup on your virtual machine, unzip it and go to the erpnext folder and execute:lib/wnf.py --install [dbname] [path to the download]
On 18-Dec-2012, at 9:14 AM, Aditya Duggal <aditya...@gmail.com> wrote:
Hi,
First of all, I would like to present my sincere apologies to the developing team for the unintentional but still extremely catastrophic effects of my queries on the server.
I have recently downloaded the VM image for erpnext from the website and to be honest this is the first time I have been able to login to the offline system. Now my real query is that how can I make an exact copy of my online account with the DB and the customizations so that I could do thorough testing before doing any harm to the system in use for others.
Any help in this regards would be deeply appreciated.--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer-forum+unsub...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/QDLxKZfl_XgJ.
<class '_mysql_exceptions.OperationalError'> | Python 2.7.3: /usr/bin/python Wed Dec 19 10:36:49 2012 |
A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.
/var/www/erpnext/public/web.py in () |
44 return website.utils.render(webnotes.form_dict.get('page')) |
45 |
46 if __name__=="__main__": |
=> 47 init() |
48 respond() |
init = <function init> |
/var/www/erpnext/public/web.py in init() |
37 import webnotes.handler |
38 webnotes.handler.get_cgi_fields() |
=> 39 webnotes.connect() |
40 |
41 def respond(): |
webnotes = <module 'webnotes' from '../lib/webnotes/__init__.pyc'>, webnotes.connect = <function connect> |
/var/www/erpnext/lib/webnotes/__init__.py in connect(db_name=None, password=None) |
163 import webnotes.db |
164 global conn |
=> 165 conn = webnotes.db.Database(user=db_name, password=password) |
166 |
167 global session |
global conn = None, webnotes = <module 'webnotes' from '../lib/webnotes/__init__.pyc'>, webnotes.db = <module 'webnotes.db' from '../lib/webnotes/db.pyc'>, webnotes.db.Database = <class webnotes.db.Database>, global user = None, db_name = None, password = None |
/var/www/erpnext/lib/webnotes/db.py in __init__(self=<webnotes.db.Database instance>, host=None, user=None, password=None, ac_name=None, use_default=0) |
51 self.password = password or webnotes.get_db_password(self.user) |
52 |
=> 53 self.connect() |
54 if self.user != 'root': |
55 self.use(self.user) |
self = <webnotes.db.Database instance>, self.connect = <bound method Database.connect of <webnotes.db.Database instance>> |
/var/www/erpnext/lib/webnotes/db.py in connect(self=<webnotes.db.Database instance>) |
62 Connect to a database |
63 """ |
=> 64 self._conn = MySQLdb.connect(user=self.user, host=self.host, passwd=self.password, use_unicode=True, charset='utf8') |
65 self._conn.converter[246]=float |
66 self._cursor = self._conn.cursor() |
self = <webnotes.db.Database instance>, self._conn undefined, global MySQLdb = <module 'MySQLdb' from '/usr/lib/python2.7/dist-packages/MySQLdb/__init__.pyc'>, MySQLdb.connect = <function Connect>, user undefined, self.user = 'rigpl', host undefined, self.host = u'localhost', passwd undefined, self.password = 'erpnext', use_unicode undefined, builtin True = True, charset undefined |
/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py in Connect(*args=(), **kwargs={'charset': u'utf8', 'host': u'localhost', 'passwd': 'erpnext', 'use_unicode': True, 'user': 'rigpl'}) |
79 """Factory function for connections.Connection.""" |
80 from connections import Connection |
=> 81 return Connection(*args, **kwargs) |
82 |
83 connect = Connection = Connect |
Connection = <class 'MySQLdb.connections.Connection'>, args = (), kwargs = {'charset': u'utf8', 'host': u'localhost', 'passwd': 'erpnext', 'use_unicode': True, 'user': 'rigpl'} |
/usr/lib/python2.7/dist-packages/MySQLdb/connections.py in __init__(self=<_mysql.connection closed at 91cf97c>, *args=(), **kwargs={'charset': u'utf8', 'host': u'localhost', 'passwd': 'erpnext', 'use_unicode': True, 'user': 'rigpl'}) |
185 kwargs2['client_flag'] = client_flag |
186 |
=> 187 super(Connection, self).__init__(*args, **kwargs2) |
188 |
189 self.encoders = dict([ (k, v) for k, v in conv.items() |
builtin super = <type 'super'>, global Connection = <class 'MySQLdb.connections.Connection'>, self = <_mysql.connection closed at 91cf97c>, ).__init__ = <bound method Connection.__init__ of <_mysql.connection closed at 91cf97c>>, args = (), kwargs2 = {'client_flag': 196608, 'conv': {0: <class 'decimal.Decimal'>, 1: <type 'int'>, 2: <type 'int'>, 3: <type 'long'>, 4: <type 'float'>, 5: <type 'float'>, 7: <function mysql_timestamp_converter>, 8: <type 'long'>, 9: <type 'int'>, 10: <function Date_or_None>, ...}, 'host': u'localhost', 'passwd': 'erpnext', 'user': 'rigpl'} |
<class '_mysql_exceptions.OperationalError'>: (1045, "Access denied for user 'rigpl'@'localhost' (using password: YES)")
args =
(1045, "Access denied for user 'rigpl'@'localhost' (using password: YES)")
message =
''
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ZFX2DSvEZDAJ.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/67I8j4qtK80J.
Hi Aditya,
The backup file is db password agnostic. It doesn't need the db password to restore. Just follow these steps I mentioned again and it should work.
This is how we restore our databases in our local system. You might've skipped a step.
Try following the exact sequence of steps. Make sure that before you restore your db, you specify the db_name and db_password in the conf.py file.
Thanks,
Anand.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/5OrxBaq7eCwJ.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/5OrxBaq7eCwJ.
Hi aditya,
This is a different error and hence you have made progress.
Try running:
lib/wnf.py --update origin master
lib/wnf.py --clear_web
--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/kL_Hs26yVoAJ.
To unsubscribe from this group, send email to erpnext-developer-forum+unsub...@googlegroups.com.