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 the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
