Author Topic: How to run a SQL mysql.sql file for plugin "rc-calendar"?  (Read 20895 times)

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« on: March 26, 2010, 05:03:16 AM »
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?
« Last Edit: March 26, 2010, 07:52:19 AM by Theet »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #1 on: March 26, 2010, 11:30:43 AM »
Do you have PHPMyAdmin? If you do, you can go into your RoundCube database and upload the file into the database.

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #2 on: March 26, 2010, 11:47:18 AM »
Quote from: skaero;26359
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?

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #3 on: March 26, 2010, 11:54:06 AM »
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.

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #4 on: March 26, 2010, 12:02:42 PM »
Quote from: skaero;26361
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....

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #5 on: March 26, 2010, 12:07:33 PM »
Quote from: skaero;26361
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?

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #6 on: March 26, 2010, 12:39:31 PM »
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.

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #7 on: March 26, 2010, 12:57:30 PM »
Quote from: skaero;26366
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...
« Last Edit: March 26, 2010, 01:20:21 PM by Theet »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #8 on: March 26, 2010, 01:21:01 PM »
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.

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #9 on: March 26, 2010, 01:24:18 PM »
Quote from: skaero;26373
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?

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #10 on: March 27, 2010, 05:25:29 AM »
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.

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #11 on: March 28, 2010, 05:39:28 AM »
Quote from: skaero;26382
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.
« Last Edit: March 28, 2010, 08:32:15 AM by Theet »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #12 on: March 28, 2010, 08:15:00 AM »
I sent him a PM.

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #13 on: March 29, 2010, 12:53:50 AM »
Sorry, but I have no knowledge about Postgres database.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline dziobak

  • Full Member
  • ***
  • Posts: 184
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #14 on: March 29, 2010, 04:49:23 AM »
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.