dakira / myroundcube

Automatically exported from code.google.com/p/myroundcube
0 stars 0 forks source link

[sabredav] - Database issue #483

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
Token: c5cbb74a4dd6539f444801b45bd24c11 (Don't modify this token!)
Version: 4.1.4 (09-03-2013)
PHP: 5.3.15
RCMAIL: 0.8.5
Database: mysql
SERVER: Apache
----
I.  Issue Description:

II. Steps to reproduce the Issue:
1. installed carddav
2. installed sabredav as per instructions
3. cannot connect

see attached log files.

Original issue reported on code.google.com by phalou...@gmail.com on 12 Mar 2013 at 3:04

Attachments:

GoogleCodeExporter commented 8 years ago
It looks like something went wrong with the database script for sabredav 4.1.4 
release.
Could you please run this script against sabredav database?

[code]

ALTER TABLE  `addressbooks` CHANGE  `user_id`  `user_id` INT( 10 ) UNSIGNED 
NULL DEFAULT NULL ;
ALTER TABLE  `calendars` CHANGE  `user_id`  `user_id` INT( 10 ) UNSIGNED NULL 
DEFAULT NULL ;

[/code]

Original comment by roland.l...@gmail.com on 12 Mar 2013 at 4:23

GoogleCodeExporter commented 8 years ago
When looking closer to it, it is a Roundcube database error. Did you create the 
necessary carddav database tables in Roundcube database?

NOTE: sabredav SQL must be created in a separate database 'sabredav'. carddav 
SQL has to be created in Roundcube database.

Original comment by roland.l...@gmail.com on 12 Mar 2013 at 4:29

GoogleCodeExporter commented 8 years ago
I think I did what had to done in both databases. I also just ran the sql you 
included above. Note that carddav is working ok with Google.
I attach print screens from both databases structure for you to check.

I also suppose that roundcube can 'see' sabredav since it allowed me what 
categories to share. See also attach image of addressbooks categories that 
automaticaly was showed in carddav settings

Original comment by phalou...@gmail.com on 13 Mar 2013 at 8:06

Attachments:

GoogleCodeExporter commented 8 years ago
We don't have any complaints that sabredav plugin is not working. We have it 
productive in dozens of servers. It must be any kind of misconfiguration. 
Please mail me access data for your server (myroundcube [at] mail4us [dot] net).

I need:
- Webmail URL
- SabreDAV URL
- IMAP test accoun
- FTP access to Roundcube and SabreDAV root folder (full permissions)
- PHPMyAdmin to Roundcube and SabreDAV database

Original comment by roland.l...@gmail.com on 13 Mar 2013 at 8:21

GoogleCodeExporter commented 8 years ago
[deleted comment]
GoogleCodeExporter commented 8 years ago
[deleted comment]
GoogleCodeExporter commented 8 years ago
I have deleted the comment. You have posted the access data to your server for 
public.
Everyone who subrcibed to this repository has received the data as email. Close 
the access immediately and change passwords.

Mail me the access data again privately:

myroundcube [at] mail4us [dot] net.

Original comment by roland.l...@gmail.com on 13 Mar 2013 at 12:25

GoogleCodeExporter commented 8 years ago
I forgot to mention:

I didn't touch you server. So if there is any kind of damage, it was not me.

Original comment by roland.l...@gmail.com on 13 Mar 2013 at 12:52

GoogleCodeExporter commented 8 years ago
[deleted comment]
GoogleCodeExporter commented 8 years ago
hi! I just replied in the mail notifier I got on my mail. I hope that is your 
private mail.

Original comment by phalou...@gmail.com on 13 Mar 2013 at 1:57

GoogleCodeExporter commented 8 years ago
[deleted comment]
GoogleCodeExporter commented 8 years ago
Don't reply to notifier emails when sending confidential data. These replies go 
straight ahead to the issue tracker and are visible for public !!!

Contact me by: myroundcube [at] mail4us [dot] net

Original comment by roland.l...@gmail.com on 13 Mar 2013 at 2:40

GoogleCodeExporter commented 8 years ago
Fix your database permission issues.

Original comment by roland.l...@gmail.com on 14 Mar 2013 at 12:11