Author Topic: Config file and sqlite database file not created  (Read 4479 times)

Offline sergiortc

  • Newbie
  • *
  • Posts: 9
Config file and sqlite database file not created
« on: August 14, 2022, 08:27:52 PM »
I am trying to install Roundcube 1.6.0
My server is Windows Server 2022 version 21H2 (OS Build 20348.825)
My IIS is version 10.0.20348.1
I have installed PHP Version 8.1.6
I added the write permission on folders Logs, Database, Temp for the IIS_IUSRS user
SQLite 3.39.2 ins installed in the server and C:\sqlite is in the system path
I downloaded roundcubemail-1.6.0-complete.tar.gz and extracted it under wwwroot
After following the install instructions I connected to localhost/roundcubemail-1.6.0/installer

I get this:
Checking PHP version
Version:  OK(PHP 8.1.6 detected)
Checking PHP extensions
The following modules/extensions are required to run Roundcube:

PCRE:  OK
DOM:  OK
Session:  OK
XML:  OK
Intl:  OK
JSON:  OK
PDO:  OK
Multibyte:  OK
OpenSSL:  OK
Filter:  OK
Ctype:  OK

The next couple of extensions are optional and recommended to get the best performance:
cURL:  OK
FileInfo:  OK
Exif:  OK
Iconv:  OK
LDAP:  OK
GD:  OK

Imagick:  NOT AVAILABLE(See https://www.php.net/manual/en/book.imagick.php)

XMLWriter:  OK
Zip:  OK

Checking available databases
Check which of the supported extensions are installed. At least one of them is required.

MySQL:  NOT AVAILABLE(See https://www.php.net/manual/en/ref.pdo-mysql.php)
PostgreSQL:  NOT AVAILABLE(See https://www.php.net/manual/en/ref.pdo-pgsql.php)

SQLite:  OK

SQLite (v2):  NOT AVAILABLE(See https://www.php.net/manual/en/ref.pdo-sqlite.php)
SQL Server (SQLSRV):  NOT AVAILABLE(See https://www.php.net/manual/en/ref.pdo-sqlsrv.php)
SQL Server (DBLIB):  NOT AVAILABLE(See https://www.php.net/manual/en/ref.pdo-dblib.php)
Oracle:  NOT AVAILABLE(See https://www.php.net/manual/en/book.oci8.php)
Check for required 3rd party libs
This also checks if the include path is set correctly.

PEAR:  OK
Auth_SASL:  OK
Net_SMTP:  OK
Mail_mime:  OK
GuzzleHttp\Client:  OK
Net_LDAP3:  OK
Checking php.ini/.htaccess settings
The following settings are required to run Roundcube:

file_uploads:  OK
session.auto_start:  OK
mbstring.func_overload:  OK
suhosin.session.encrypt:  OK
The following settings are optional and recommended:

date.timezone:  OK

I click Next and set configuration values as this:

Support url: a mailto: link
Identities level: one identity with possibility of editing all parameters except email address
Database setup
SQLite
C:\inetpub\wwwroot\roundcubemail-1.6.0\Database\RcDb.db

All other values are the default
I enabled the following plugins
attachment_reminder
emoticons
filesystem_attachments
Help
Password

When i click on Create Config
Config file is not created
database is not created
I get 251 warnings of the form:
PHP Warning:  Undefined array key "db_dsnw" in C:\inetpub\wwwroot\roundcubemail-1.6.0\program\include\rcmail_install.php on line 220
PHP Warning:  Undefined array key "db_dsnr" in C:\inetpub\wwwroot\roundcubemail-1.6.0\program\include\rcmail_install.php on line 220

Can you help me solve this problem?
Thank you
« Last Edit: August 14, 2022, 08:38:44 PM by sergiortc »

Offline sergiortc

  • Newbie
  • *
  • Posts: 9
Re: Config file and sqlite database file not created
« Reply #1 on: August 15, 2022, 11:42:46 AM »
I followed the manual installation procedure and everything seems to be working just fine. :D
Thanks.

Offline hartmut

  • Newbie
  • *
  • Posts: 2
Re: Config file and sqlite database file not created
« Reply #2 on: December 06, 2022, 04:27:24 AM »
Hi sergiortc,

i'v the same problem.

But what exactly is your solution to solve the problem?

greetings

hartmut

Offline sergiortc

  • Newbie
  • *
  • Posts: 9
Re: Config file and sqlite database file not created
« Reply #3 on: December 06, 2022, 09:04:55 AM »
The most important thing to do is to read carefully the INSTALL file.
It has a section called "Manual Configuration". This section tells you to "First of all, copy the sample configuration file config/config.inc.php.sample to config/config.inc.php and make the necessary adjustments according to your environment and your needs."
I did that making sure that the different variables I saw in the install script were given the correct values in the config.inc.php file.
I use SQLite for the database (mine is a very small installation for 20 users or so) so I did not have to create the database.
I tried to open http://mydomain/roundcubemail-1.6.0/ from my server and checked the error messages and error log while it did not work and made any adjustment that those suggested.
Eventually (maybe after 2 or 3 trials) it worked.
Sorry I cannot be more specific.