Thread: How to run a SQL mysql.sql file for plugin "rc-calendar"?

Do you have PHPMyAdmin? If you do, you can go into your RoundCube database and upload the file into the database.

Originally Posted by skaero

Do you have PHPMyAdmin? If you do, you can go into your RoundCube database and upload the file into the database.

You make me happy, I do have phpMyAdmin, but I don't see a database from RoundCube / MailStation / roundcubemail....

What to do?

RoundCube has to have a database to work, look in the <RC root>/config/db.inc.php look for the $rcmail_config['db_dsnw'] it should have a string like: mysql://roundcube:pass@localhost/roundcubemail the last part (mysql://roundcube:pass@localhost/roundcubemail) is the database that RoundCube is using.

Originally Posted by skaero

RoundCube has to have a database to work, look in the <RC root>/config/db.inc.php look for the $rcmail_config['db_dsnw'] it should have a string like: mysql://roundcube***@localhost/roundcubemail the last part (mysql://roundcube***@localhost/roundcubemail) is the database that RoundCube is using.

I have never done this before, once is the first time:

How to import this database into phpMyAdmin?
roundcubemail is a part of AJAX software in Synology

(Synology Inc. - NEW NAS Experience - - MailStation) the software of roundcubestation is
placed in a map called @appstore. I don't think so that I can import the database with the import button....

Originally Posted by skaero

RoundCube has to have a database to work, look in the <RC root>/config/db.inc.php look for the $rcmail_config['db_dsnw'] it should have a string like: mysql://roundcube***@localhost/roundcubemail the last part (mysql://roundcube***@localhost/roundcubemail) is the database that RoundCube is using.

With telnet I have a maps:

/volume1/homes/.Maildir (here is saved all personal mail by user)
/volume1/@appstore/MailStation/roundcubemail/plugins

I have looked into phpMyAdmin, but I don't see a SQL database called
"roundcube..."

roundcubemail is a part of AJAX software from Synology, software like
MailStation is covered behind @appstore map. How can I import the
database from roundcube?

What does your <RC root>/config/db.inc.php say that the database that RoundCube is using it doesn't have to have roundcube in the name.

Originally Posted by skaero

What does your <RC root>/config/db.inc.php say that the database that RoundCube is using it doesn't have to have roundcube in the name.

$rcmail_config['db_dsnw'] = 'pgsql://roundcube:@localhost/roundcubemail';
// postgres example: 'pgsql://roundcube***@localhost/roundcubemail';
// Warning: for SQLite use absolute path in DSN:
// sqlite example: 'sqlite:////full/path/to/sqlite.db?mode=0646';

This is what is says...

The db.inc.php file is listed in: /volume1/@appstore/MailStation/roundcubemail/config/db.inc.php

The databases from phpMyAdmin are saved in: /volume1/@database/mysql/ but there isn't a database who's look like roundcube...

Ah your using a Postgres SQL database not MySQL I don't know if the calendar plugin works with Postgres SQL, and I don't know as much about Postgres SQL management tools, maybe Rosali would have a bettor idea about getting it to work with Postgres SQL.

Originally Posted by skaero

Ah your using a Postgres SQL database not MySQL I don't know if the calendar plugin works with Postgres SQL, and I don't know as much about Postgres SQL management tools, maybe Rosali would have a bettor idea about getting it to work with Postgres SQL.

Above stands:

$rcmail_config = array();

// PEAR database DSN for read/write operations
// format is db_provider://userassword@host/database
// For examples see http://pear.php.net/manual/en/packag....intro-dsn.php
// currently supported db_providers: mysql, mysqli, pgsql, sqlite, mssql

Thank you for the help so far, Rosali is another moderator I guess?