Blast! Verify your database configuration. : Access to database is denied for freshrss_rw: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for mariadb failed: No such host is known.

[rusegithub]

I've almost installed FreshRSS for the first time (thanks).

But I get this error when I click Submit in Database configuration:

• Blast! Verify your database configuration. : Access to database is denied for freshrss_rw: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for mariadb failed: No such host is known.

I have been following this guide: https://i12bretro.github.io/tutorials/0234.html (video here: https://www.youtube.com/watch?v=u_iQufgPkMo&t=6s ).

So the problem happens at the end of step 19.

• Windows 11 Home - Version 23H2

• Firefox 122.0.1

• FreshRSS 1.23.1

• Database version: [e.g. Mysql 5.7]
  I don't know how to check this.
  In C:\xampp\mysql\mysql_error.log it says:

  2024-02-19 21:55:07 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 11908
  2024-02-19 21:55:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  2024-02-19 21:55:07 0 [Note] InnoDB: Uses event mutexes
  2024-02-19 21:55:07 0 [Note] InnoDB: Compressed tables use zlib 1.3
  2024-02-19 21:55:07 0 [Note] InnoDB: Number of pools: 1
  2024-02-19 21:55:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
  2024-02-19 21:55:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
  2024-02-19 21:55:07 0 [Note] InnoDB: Completed initialization of buffer pool
  2024-02-19 21:55:07 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
  2024-02-19 21:55:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
  2024-02-19 21:55:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  2024-02-19 21:55:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  2024-02-19 21:55:07 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  2024-02-19 21:55:07 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
  2024-02-19 21:55:07 0 [Note] InnoDB: Waiting for purge to start
  2024-02-19 21:55:07 0 [Note] InnoDB: 10.4.32 started; log sequence number 300297; transaction id 170
  2024-02-19 21:55:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
  2024-02-19 21:55:07 0 [Note] Plugin 'FEEDBACK' is disabled.
  2024-02-19 21:55:07 0 [Note] InnoDB: Buffer pool(s) load completed at 240219 21:55:07
  2024-02-19 21:55:07 0 [Note] Server socket created on IP: '::'.

• PHP version: [e.g. PHP 7.4]
  Again, not sure how to check.
  C:\xampp\php\php-win.exe has a modification date of 25 ‎October ‎2023, ‏‎04:56:48

• Installation type: [e.g. Yunohost]
  Don't know

• I used this: xampp-portable-windows-x64-8.2.12-0-VS16.zip

I'll be very grateful for any help.

[Frenzie]

It's generally the easiest to use SQLite btw.

[rusegithub]

@Frenzie Thanks.

I could do that (although I've no idea how?) but, in trying to find out how, I found this: #961 where the person wants to migrate from SQLite to Mysql.

So I wonder if I'm better sticking with Mysql?

If I'm better off with SQLite, please could you guide me how to do that.

As I said, I've been following this guide: https://i12bretro.github.io/tutorials/0234.html - except that at the end I go to http://localhost/freshrss - as it says in the video https://www.youtube.com/watch?v=u_iQufgPkMo&t=6s - instead of http://DNSorIP:8089.

Then I select a Language and click Submit
Click the Go to the next step button
Complete the database configuration form as follows

Type of database: MySQL
Host: mariadb
Database username: freshrss_rw
Database password: Fr3s4R$S!!
Database: freshrss
Table prefix:

What should I do instead of the above in order to use SQLite?

[rusegithub]

I've sorted this out now. I should not have been specifying a host.

But, @Frenzie, if you have any advice on using SQLite instead, I'd still appreciate it.

[Alkarex]

SQLite is built-in and easiest and has fine performances for most cases.
If not enough, PostgreSQL would be the more powerful alternative (cf. #5648 (comment) )