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 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.
