What does it mean? I did check airtime user at system exists, I checked that airtime user has been created in DB.
I was looked at /var/lib/pgsql/data/pg_hba.conf - there are all used ident method of authentication that mean the system user credentials will be used connect to DB.
If anybody know what to look?
www.actionsch.com - Bringing talents in life! + Action Radio School +
The only time I've seen this when installing Airtime is when I had both postgresql 8.4 and postgresql 9.1 installed and it was trying to connect to the wrong one.
That's why I suggest "psql -U airtime -h localhost -d airtime". It will connect db "airtime" by db user "airtime". By default the password should be "airtime".
If you've updated password in postgresql, you should update airtime's config files under /etc/airtime/, too.
I did not updated anything beside the install does. Now just looked at /etc/airtime/ and noticed that only airtime.conf has no pypo:pypo ownership. changed it and ran:
php install_minimal/include/airtime-db-install.php y
* Database Installation
* Creating Airtime database user
ERROR: role "airtime" already exists
* Database user 'airtime' already exists.
* Creating Airtime database
Unable to open PDO connection [wrapped: SQLSTATE[08006] [7] FATAL: Ident authentication failed for user "airtime"]
Database connection problem.
Check if database 'airtime' exists with corresponding permissions.
Still the same error... what to dig further?
I know that error is from Propel.php line: 630
public static function initConnection($conparams, $name, $defaultClass = Propel::CLASS_PROPEL_PDO)
Post edited by Alex Gainulin at 2014-04-11 23:38:26
www.actionsch.com - Bringing talents in life! + Action Radio School +
What is preventing you from upgrade your database.
If you are not using it for any other purpose purge it and reinstall
as @Noami suggest the database connection might be the problem
Good Luck VOISSES
Anyone reading this a find it funny about my grammar , I make no apology ,Go get a translator. "The Problem with education today is that it takes a university degree to switch on a light bulb" "You learn from your mistakes but wise people learn from others mistakes avoid Making mistakes there is not sufficient rooms to make them" "Innuendo","If's","Assumptions" and "Fear" are for politician.Who,What,where,When and How are for those seeking knowledge and care about Humanity. "I might be in Mud but that does not Make me a Wild Hog(pig)" “Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius — and a lot of courage to move in the opposite direction.” "The only thing that remains constant is change itself" May the force be with you,until our path or destiny bring us in tandem.
Nothing prevented me from upgrade (are you sure it really helps?), just was wondering why such silly error is not recognizable...
I found the workaround to fix (just replace ident with md5 in /var/lib/pgsql/data/pg_hba.conf), but surprised why it is so complicated to find the problem...
Sure, I will try to upgrade - there is nothing used it. Will see then will it get work with ident or...
www.actionsch.com - Bringing talents in life! + Action Radio School +
I commented out the second line and was able to login. Simply removing 'localhost' from that line might do it as well. Do not forget to restart the 'network' service.
Hope that works for you as well. Klaus
Post edited by Klaus Hofeditz at 2014-05-31 15:07:39