The error says: FATAL: password authentication failed for user "myuser" Given that, as far as I can see it's related to postgres rather than web2py
Paolo 2015-04-26 10:24 GMT+02:00 weheh <[email protected]>: > Thanks for the response, but no, before restoring the database I created > the user and the database directly in postgres. Then I ran web2py and got > the error. Then I restored the database from the old server and ran web2py > and got the same error. I dropped the database and tried again and got the > same result. > > > On Sunday, April 26, 2015 at 1:14:38 AM UTC-7, Paolo Valleri wrote: >> >> you have to setup the user on the new postgres server. You have probably >> restored only the data of the database. >> >> On Sunday, April 26, 2015 at 9:10:11 AM UTC+2, weheh wrote: >>> >>> I'm moving my app to a new server. It's running Windows 8.1 (sorry about >>> that, but it can't be avoided for technical reasons). Regardless, I backed >>> up my postgres db on my old server and moved it over to the new server and >>> sucked it into postgres. The db is associated with the same user name and >>> password. Now, however, when I try to start my app, I get the error message: >>> >>> Traceback (most recent call last): >>> File "C:\web2py\gluon\restricted.py", line 224, in restricted >>> exec ccode in environment >>> File "C:/web2py/applications/myapp/models/0_0_globals.py", line 25, in >>> <module> >>> migrate=False, # enable in production for increased performance >>> File "C:\web2py\gluon\dal\base.py", line 432, in __init__ >>> raise RuntimeError("Failure to connect, tried %d times:\n%s" % >>> (attempts, tb)) >>> RuntimeError: Failure to connect, tried 10 times: >>> Traceback (most recent call last): >>> File "C:\web2py\gluon\dal\base.py", line 410, in __init__ >>> self._adapter = ADAPTERS[self._dbname](**kwargs) >>> File "C:\web2py\gluon\dal\adapters\base.py", line 47, in __call__ >>> obj = super(AdapterMeta, cls).__call__(*args, **kwargs) >>> File "C:\web2py\gluon\dal\adapters\postgres.py", line 144, in __init__ >>> if do_connect: self.reconnect() >>> File "C:\web2py\gluon\dal\connection.py", line 113, in reconnect >>> self.connection = f() >>> File "C:\web2py\gluon\dal\adapters\postgres.py", line 142, in connector >>> return self.driver.connect(msg,**driver_args) >>> File "C:\Program Files >>> (x86)\Python27\lib\site-packages\psycopg2\__init__.py", line 164, in connect >>> conn = _connect(dsn, connection_factory=connection_factory, >>> async=async) >>> OperationalError: FATAL: password authentication failed for user >>> "myuser" >>> >>> I'm using the same credentials as before. Nothing has changed. psychopg2 >>> is installed. The password has been validated multiple times directly in >>> postgres. >>> >>> This is all running on web2py >>> 2.9.12-stable+timestamp.2015.01.17.06.11.03 (Running on Rocket 1.2.6, >>> Python 2.7.8) >>> >>> >>> >>> Anybody have any ideas how to get this running again? >>> >> -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/F-IN0huIabA/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
