Exception while creating PDO object:SQLSTATE[08006] [7] could not connect to server: Connection refused
Is the server running on host “localhost” (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host “localhost” (127.0.0.1) and accepting
TCP/IP connections on port 5432?
Don’t change tt-rss/classes/config.php
Copy tt-rss/config.php.dist to config.php and edit that.
Please, just stop. You’re basically doing everything wrong.
This is not the forum to educate you about setting up a web stack. You’ll need to learn that elsewhere.
For starters, if you’re not going the Docker route, that’s fine. It’s technically not supported but many people do. I do not use Docker and TT-RSS runs just fine. What you want to do is SSH into your web server and git pull the repository into a directory (e.g. tt-rss).
You shouldn’t be modifying any files in the classes directory. Do what markwaters said above with the config file.
If you’re setting this up on a shared host, you probably need to use MySQL and not PostgreSQL because most shared hosts simply don’t offer anything other than MySQL.
Next, read the wiki. You can start with GlobalConfig since you’ve mentioned you’re trying to set that up.
fox
17
https://git.tt-rss.org/fox/tt-rss/wiki/InstallationNotesHost
i’m feeling uncharacteristically merciful so i’ve updated host installation notes to reflect the removal of easy installer and recent move to new configuration schema.
if i’ve missed something, suggestions to add/change are welcome.
thank you so much, now I change put tt-rss/classes/config.php to be old default one,
and I copy tt-rss/config.php.dist to config.php and edit it.
now my tt-rss/config.php is that
<?php
putenv('TTRSS_DB_HOST=myserver');
putenv('TTRSS_SELF_URL_PATH=https://rss.myebsite.com/tt-rss');
putenv('TTRSS_SESSION_COOKIE_LIFETIME='.(86400*30));
define('LEGACY_CONSTANT', 'value');
putenv('TTRSS_SESSION_COOKIE_LIFETIME='.(86400*30));
putenv("TTRSS_SESSION_COOKIE_LIFETIME='2592000'");
# => 0, because '2592000' is an invalid number
putenv('TTRSS_SESSION_COOKIE_LIFETIME=86400*30');
# => 86400, because expression is not evaluated, so you're just casting a string literal "86400*30" to integer
?>
thank you so much, let me try it again
thank you so much I will read it
thank you so much, now I create a config.php in tt-rss/config.php, and I already set up the setting,
but still doesnt work
<?php
putenv('TTRSS_DB_HOST=localhost');
putenv('TTRSS_DB_NAME=xqnccuxxxx');
putenv('TTRSS_DB_USER=xqnccuxxxx');
putenv('TTRSS_DB_PASS=rnRCjMhxxxx');
putenv('TTRSS_SELF_URL_PATH=https://rss.mywebsitecom/tt-rss');
?>
when I go to https://rss.mywebsitecom/tt-rss it shows
Exception while creating PDO object:SQLSTATE[08006] [7] could not connect to server: Connection refused
Is the server running on host “localhost” (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host “localhost” (127.0.0.1) and accepting
TCP/IP connections on port 5432?
Did you see this part of my post:
If you’re not using PostgreSQL you’ll need to also set DB_TYPE and DB_PORT.
It would also help us if you posted your code in actual code blocks. To do that, please type three backticks ``` on its own line, paste your code, then another three backticks ``` on its own line.
e: It also occurs to me that some shared hosts might host the database on separate servers. Usually whatever control panel software they have will tell you what you need to put in DB_HOST for your application to reach the database.
e2: Can you please tell us if you’re hosting this on a VPS/VDS or shared hosting? You don’t have to mention any company, but it will aid in providing advice.
fox
23
it’s likely a shared hosting, database credentials should be in the hosting control panel somewhere.
thank you so much in fact I am using VPS with cloudways, but my server is running with mariadb. so is this mean I can not use tiny tiny rss?
thank you so much in fact I am using VPS with cloudways, but my server is running with mariadb. so is this mean I can not use tiny tiny rss?
MariaDB is a drop-in replacement for MySQL; TT-RSS will work with it. Just change DB_TYPE to MySQL and DB_PORT to 3306.
thank you so much
now I go to https://rss.mywebsitecom/tt-rss it shows
Startup failed
Please fix errors indicated by the following messages:
Base database schema is missing. Either load it manually or perform a migration (update.php --update-schema)
You might want to check tt-rss wiki or the forums for more information. Please search the forums before creating new topic for your question.
fox
28
you need to run this in tt-rss directory:
php ./update.php --update-schema
i’ll mention that in the installation guide
Open your Tiny Tiny RSS installation and login with default credentials (username: admin, password: password).
I get it thank you all so much
fox
32
maybe you should read the guide i’ve linked above.
I dont know why my tiny tiny rss can not update feeds,
it shows Update daemon is not updating feeds.
please help thank you so much
You’ve got to actually read and follow the guides buddy. You aren’t even making an effort.