Problems showing calendars

View: New views
3 Messages — Rating Filter:   Alert me  

Problems showing calendars

by Martin Settle :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Hello

I am experiencing the same difficulty as Dale Miller in

http://lists.horde.org/archives/kronolith/Week-of-Mon-20080526/006845.html

I am using a fresh install of the horde groupware webmail edition, which
includes Horde 3.2.1 and Kronolith 2.2

Calendars are created in the kronolith_shares table, but do not appear
for the user in the Default select box or on the floating control panel.

The only thing I have noticed is that the kronolith_shares.share_owner
field is truncated: martin.settle@... becomes
martin.settle@...  Would this have an effect, and if so,
how do I 'fix' it?

Thanks for any help you might give. Config files follow...

Marti



kronolith/config/conf.php contains

$conf['calendar']['params']['table'] = 'kronolith_events';
$conf['calendar']['params']['driverconfig'] = 'horde';
$conf['calendar']['driver'] = 'sql';
$conf['storage']['params']['table'] = 'kronolith_storage';
$conf['storage']['params']['driverconfig'] = 'horde';
$conf['storage']['driver'] = 'sql';
$conf['metadata']['keywords'] = false;
$conf['autoshare']['shareperms'] = 'true';
$conf['holidays']['enable'] = true;
$conf['menu']['print'] = true;
$conf['menu']['import_export'] = true;
$conf['menu']['apps'] = array();

config/conf.php contains

$conf['vhosts'] = false;
$conf['debug_level'] = E_ALL;
$conf['max_exec_time'] = 0;
$conf['compress_pages'] = true;
$conf['umask'] = 077;
$conf['use_ssl'] = 2;
$conf['server']['name'] = $_SERVER['SERVER_NAME'];
$conf['server']['port'] = $_SERVER['SERVER_PORT'];
$conf['urls']['pretty'] = false;
$conf['safe_ips'] = array();
$conf['session']['name'] = 'Horde';
$conf['session']['use_only_cookies'] = true;
$conf['session']['cache_limiter'] = 'nocache';
$conf['session']['timeout'] = 0;
$conf['cookie']['domain'] = $_SERVER['SERVER_NAME'];
$conf['cookie']['path'] = '/';
$conf['sql']['persistent'] = true;
$conf['sql']['username'] = 'crabtree';
$conf['sql']['password'] = 'watt0n';
$conf['sql']['protocol'] = 'unix';
$conf['sql']['database'] = 'mydomains_staffhorde';
$conf['sql']['charset'] = 'iso-8859-1';
$conf['sql']['splitread'] = false;
$conf['sql']['phptype'] = 'mysql';
$conf['auth']['admins'] = array('martin.settle@...');
$conf['auth']['checkip'] = true;
$conf['auth']['checkbrowser'] = true;
$conf['auth']['alternate_login'] = false;
$conf['auth']['redirect_on_logout'] = false;
$conf['auth']['params']['dsn'] = '{localhost:143/imap/notls}';
$conf['auth']['params']['imapconfig'] = 'dsn';
$conf['auth']['driver'] = 'imap';
$conf['signup']['allow'] = false;
$conf['log']['enabled'] = false;
$conf['log_accesskeys'] = false;
$conf['prefs']['params']['driverconfig'] = 'horde';
$conf['prefs']['driver'] = 'sql';
$conf['alarms']['params']['driverconfig'] = 'horde';
$conf['alarms']['params']['ttl'] = 300;
$conf['alarms']['driver'] = 'sql';
$conf['datatree']['params']['driverconfig'] = 'horde';
$conf['datatree']['driver'] = 'sql';
$conf['group']['driverconfig'] = 'horde';
$conf['group']['driver'] = 'sql';
$conf['group']['cache'] = false;
$conf['perms']['driverconfig'] = 'horde';
$conf['perms']['driver'] = 'sql';
$conf['share']['no_sharing'] = false;
$conf['share']['any_group'] = false;
$conf['share']['cache'] = false;
$conf['share']['driver'] = 'sql';
$conf['cache']['default_lifetime'] = 86400;
$conf['cache']['params']['sub'] = 0;
$conf['cache']['driver'] = 'file';
$conf['lock']['params']['driverconfig'] = 'horde';
$conf['lock']['driver'] = 'sql';
$conf['token']['params']['driverconfig'] = 'horde';
$conf['token']['driver'] = 'sql';
$conf['mailer']['params']['sendmail_path'] = '/usr/lib/sendmail';
$conf['mailer']['params']['sendmail_args'] = '-oi';
$conf['mailer']['type'] = 'sendmail';
$conf['mailformat']['brokenrfc2231'] = false;
$conf['vfs']['params']['driverconfig'] = 'horde';
$conf['vfs']['type'] = 'sql';
$conf['sessionhandler']['type'] = 'none';
$conf['sessionhandler']['memcache'] = false;
$conf['problems']['email'] = 'webmaster@...';
$conf['problems']['maildomain'] = 'example.com';
$conf['problems']['tickets'] = false;
$conf['problems']['attachments'] = true;
$conf['menu']['apps'] = array();
$conf['menu']['always'] = false;
$conf['menu']['links']['help'] = 'all';
$conf['menu']['links']['options'] = 'authenticated';
$conf['menu']['links']['problem'] = 'all';
$conf['menu']['links']['login'] = 'all';
$conf['menu']['links']['logout'] = 'authenticated';
$conf['hooks']['permsdenied'] = false;
$conf['hooks']['username'] = false;
$conf['hooks']['preauthenticate'] = false;
$conf['hooks']['postauthenticate'] = false;
$conf['hooks']['authldap'] = false;
$conf['hooks']['groupldap'] = false;
$conf['portal']['fixed_blocks'] = array();
$conf['accounts']['driver'] = 'null';
$conf['user']['verify_from_addr'] = false;
$conf['imsp']['enabled'] = false;
$conf['kolab']['enabled'] = false;
$conf['memcache']['enabled'] = false;
$conf['categories']['driver'] = 'sql';



--
Local Food Links
Bridport Centre for Local Food
Unit 17, St.Michael's Trading Estate
Bridport, Dorset, DT6 3RR
(01308) 420269

E-mail: firstname.lastname(at)localfoodlinks.org.uk
http://www.localfoodlinks.org.uk

Local Food Links Limited is an
Industrial & Provident Society no. 30173R.
Registered in England & Wales.
Registered office as above.
VAT Number: 903 6418 39

This message is intended only for the use of the addressee and may
contain information that is privileged, confidential and exempt from
disclosure under applicable law. If the reader of this message is not
the intended recipient, or the employee or agent responsible for
delivering the message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this e-mail
in error, please notify us immediately by return e-mail and delete this
e-mail and all attachments from your system

--
Kronolith mailing list - Join the hunt: http://horde.org/bounties/#kronolith
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: kronolith-unsubscribe@...

Re: SOLVED Problems showing calendars

by Martin Settle :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


As it turns out, the problem was with the truncating of the mysql _owner
fields, which meant that the SQL queries based on login were not
associating.  This has been resolved by having all of the _owner and
_uid field lengths changed to 60 rather than 32.  Slightly tedious, but
it works.

Probably would have been easier to build a different authorisation
system, but I like the seamlessness of using imap...

Marti.


On Tue, 2008-09-02 at 10:31 +0100, Martin Settle wrote:

> Hello
>
> I am experiencing the same difficulty as Dale Miller in
>
> http://lists.horde.org/archives/kronolith/Week-of-Mon-20080526/006845.html
>
> I am using a fresh install of the horde groupware webmail edition, which
> includes Horde 3.2.1 and Kronolith 2.2
>
> Calendars are created in the kronolith_shares table, but do not appear
> for the user in the Default select box or on the floating control panel.
>
> The only thing I have noticed is that the kronolith_shares.share_owner
> field is truncated: martin.settle@... becomes
> martin.settle@...  Would this have an effect, and if so,
> how do I 'fix' it?

>
--
Local Food Links
Bridport Centre for Local Food
Unit 17, St.Michael's Trading Estate
Bridport, Dorset, DT6 3RR
(01308) 420269

E-mail: firstname.lastname(at)localfoodlinks.org.uk
http://www.localfoodlinks.org.uk

Local Food Links Limited is an
Industrial & Provident Society no. 30173R.
Registered in England & Wales.
Registered office as above.
VAT Number: 903 6418 39

This message is intended only for the use of the addressee and may
contain information that is privileged, confidential and exempt from
disclosure under applicable law. If the reader of this message is not
the intended recipient, or the employee or agent responsible for
delivering the message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this e-mail
in error, please notify us immediately by return e-mail and delete this
e-mail and all attachments from your system

--
Kronolith mailing list - Join the hunt: http://horde.org/bounties/#kronolith
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: kronolith-unsubscribe@...

Re: Problems showing calendars

by Michael Rubinsky-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Quoting Martin Settle <martin.settle@...>:

>
> Hello
>
> I am experiencing the same difficulty as Dale Miller in
>
> http://lists.horde.org/archives/kronolith/Week-of-Mon-20080526/006845.html
>
> I am using a fresh install of the horde groupware webmail edition, which
> includes Horde 3.2.1 and Kronolith 2.2
>
> Calendars are created in the kronolith_shares table, but do not appear
> for the user in the Default select box or on the floating control panel.
>
> The only thing I have noticed is that the kronolith_shares.share_owner
> field is truncated: martin.settle@... becomes
> martin.settle@...  Would this have an effect, and if so,
> how do I 'fix' it?

http://cvs.horde.org/kronolith/scripts/upgrades/2008-06-17_fix_varchar_lengths.sql

Thanks,
mike

--
The Horde Project (www.horde.org)
mrubinsk@...

"Time just hates me. That's why it made me an adult." - Josh Joplin


--
Kronolith mailing list - Join the hunt: http://horde.org/bounties/#kronolith
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: kronolith-unsubscribe@...

attachment0 (196 bytes) Download Attachment