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

[Theet]

I have installed the plugin "calendar":

RoundCube Calendar

In step 3: Run the SQL file in /calendar/SQL/

How do I run this SQL file?

The plugin have I uploaded into:
/volume1/@appstore/MailStation/roundcubemail/plugins/calendar

Then I have a link for the plugin to the calendar like:
/volume1/@appstore/MailStation/target/roundcubemail/config/main.inc.php

$rcmail_config['plugins'] = array(
'emoticons',
'calendar'
);

Now I will see "SERVER ERROR (OK)" after clicking on de button Calendar.
I will see the calendar and above the ERROR.

When I make an appointment, I will get the message "SERVER CURRENTLY NOT AVAILABLE"

In the forum of the rc-calendar they have write:

If the plugin has a SQL folder:

Adjust "Roundcube" Database as shown in the mysql.sql script.
By default MyRoundcube plugins support MySQL database.

Please who wants to help me?

[SKaero]

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

[Theet]

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?

[SKaero]

RoundCube has to have a database to work, look in the /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.

[Theet]

RoundCube has to have a database to work, look in the /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.

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....

[Theet]

RoundCube has to have a database to work, look in the /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.

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?

[SKaero]

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

[Theet]

What does your /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:pass@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...

[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.

[Theet]

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://user:password@host/database
// For examples see http://pear.php.net/manual/en/package.database.mdb2.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?

[SKaero]

Yes Rosali is another moderator and is also working on the calendar plugin, he may have a better idea if it would work with Postgres SQL.

[Theet]

Yes Rosali is another moderator and is also working on the calendar plugin, he may have a better idea if it would work with Postgres SQL.

Will you please inform Rosali about this forum item?
I'm very interested for a solution, because there are more plugins which are working with SQL... Thanks in advance.

[SKaero]

I sent him a PM.

[rosali]

Sorry, but I have no knowledge about Postgres database.

[dziobak]

you can install 'phpPgAdmin' and make in easy way that table in database.
I don't know if there is only sql language used for mysql. If yes, you should contact with author of this plugin.