[horde] Fatal error with whups
Erling Preben Hansen
erling at eph.dk
Sat Feb 28 13:48:29 UTC 2015
Citat af Hanns Mattes <hanns at hannsmattes.de>:
> Hi,
>
> Am 27.02.2015 um 23:24 schrieb erling at eph.dk:
>> Citat af Hanns Mattes <hanns at hannsmattes.de>:
>>
>>> Any other ideas, what could cause this error? Though there is no need
>>> for a ticket system in my use case - I don't like it, if things aren't
>>> working the way they should.
>>
>> Let us se your config.
>> I have it installed on my test server.
>> With sql backend.
>> Perhaps we can find out what is wrong if we get some more info.
>> I don't get that error.
>
> Here we go:
>
> horde/whups is installed under /usr/share/php5/PEAR/www/horde/*
>
> Basically it is an rpm-installation with opensuse 13.2 using the RPMs,
> Ralf (I think) provided and since then upgrade via pear.
>
> Preference system ist sql with horde defaults.
>
> whups/config/conf.php
>
> <?php
> /* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
> // $Id: 56c6fd76ea2179142484c6e1ae4147df8b7ab6bf $
> $conf['tickets']['params']['driverconfig'] = 'horde';
> $conf['tickets']['driver'] = 'Sql';
> $conf['guests']['figlet_font'] = '/usr/share/figlet/big.flf';
> $conf['guests']['captcha'] = true;
> $conf['mail']['return_path'] = 'admin at bruecko.de';
> $conf['mail']['always_copy'] = 'hannsldap at hannsmattes.de';
> $conf['mail']['reply'] = false;
> $conf['mail']['include_headers'] = true;
> $conf['mail']['attach_message'] = false;
> $conf['mail']['commenthistory'] = 'new';
> $conf['mail']['link_attach'] = true;
> $conf['mail']['incl_resp'] = true;
> $conf['mail']['server_name'] = 'horde.bruecko.de';
> $conf['mail']['server_port'] = 80;
> $conf['mail']['username'] = 'admin at bruecko.de';
> $conf['prefs']['autolink_terms'] = 'bug|ticket|issue';
> $conf['prefs']['assign_all_groups'] = false;
> $conf['states']['1']['name'] = 'Unconfirmed';
> $conf['states']['1']['desc'] = 'A ticket has been reported but not yet
> analyzed';
> $conf['states']['1']['category'] = 'unconfirmed';
> $conf['states']['1']['active'] = 'active';
> $conf['states']['2']['name'] = 'Accepted';
> $conf['states']['2']['desc'] = 'The ticket has been analyzed and
> accepted as valid.';
> $conf['states']['2']['category'] = 'new';
> $conf['states']['2']['active'] = 'active';
> $conf['states']['3']['name'] = 'Assigned';
> $conf['states']['3']['desc'] = 'Someone has accepted responsibility for
> the ticket.';
> $conf['states']['3']['category'] = 'assigned';
> $conf['states']['3']['active'] = 'active';
> $conf['states']['4']['name'] = 'Resolved';
> $conf['states']['4']['desc'] = 'The ticket has been resolved.';
> $conf['states']['4']['category'] = 'resolved';
> $conf['states']['4']['active'] = 'active';
> $conf['states']['5']['name'] = 'Canceled';
> $conf['states']['5']['desc'] = 'The ticket is no longer valid for one
> reason or another.';
> $conf['states']['5']['category'] = 'resolved';
> $conf['states']['5']['active'] = 'active';
> $conf['states']['6']['active'] = 'inactive';
> $conf['states']['7']['active'] = 'inactive';
> $conf['states']['8']['active'] = 'inactive';
> $conf['priorities']['1']['name'] = '1. Low';
> $conf['priorities']['1']['desc'] = 'This is a very low priority ticket';
> $conf['priorities']['1']['active'] = 'active';
> $conf['priorities']['2']['name'] = '2. Medium';
> $conf['priorities']['2']['desc'] = 'This is an important task, but not
> urgent.';
> $conf['priorities']['2']['active'] = 'active';
> $conf['priorities']['3']['name'] = '3. High';
> $conf['priorities']['3']['desc'] = 'This ticket is very urgent';
> $conf['priorities']['3']['active'] = 'active';
> $conf['priorities']['4']['active'] = 'inactive';
> $conf['priorities']['5']['active'] = 'inactive';
> $conf['priorities']['6']['active'] = 'inactive';
> /* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */
>
> prefs.php (No changes, so no prefs.local.php):
>
> <?php
> /**
> * See horde/config/prefs.php for documentation on the structure of this
> file.
> *
> * IMPORTANT: DO NOT EDIT THIS FILE! DO NOT COPY prefs.php TO
> prefs.local.php!
> * Local overrides ONLY MUST be placed in prefs.local.php or prefs.d/.
> * If the 'vhosts' setting has been enabled in Horde's configuration,
> you can
> * use prefs-servername.php.
> */
>
> $prefGroups['display'] = array(
> 'column' => _("General Preferences"),
> 'label' => _("Display Preferences"),
> 'desc' => _("Change display preferences such as how search results
> are sorted."),
> 'members' => array(
> 'sortby', 'sortdir', 'comment_sort_dir', 'whups_default_view',
> 'summary_show_requested', 'summary_show_ticket_numbers',
> 'report_time_format', 'autolink_tickets'
> )
> );
>
> $prefGroups['notification'] = array(
> 'column' => _("General Preferences"),
> 'label' => _("Notification Preferences"),
> 'desc' => _("Change preferences for email notifications of ticket
> activity."),
> 'members' => array('email_others_only', 'email_comments_only'));
>
> $prefGroups['addressbooks'] = array(
> 'column' => _("General Preferences"),
> 'label' => _("Address Books"),
> 'desc' => _("Select address book sources for adding and searching
> for addresses."),
> 'members' => array('sourceselect'),
> 'suppress' => function() {
> return !$GLOBALS['registry']->hasMethod('contacts/sources');
> }
> );
>
> // the layout of the bugs portal.
> $_prefs['mybugs_layout'] = array(
> 'value' => 'a:0:{}'
> );
>
> // user preferred sorting column
> $_prefs['sortby'] = array(
> 'value' => 'id',
> 'type' => 'enum',
> 'enum' => array(
> 'id' => _("Id"),
> 'summary' => _("Summary"),
> 'state_name' => _("State"),
> 'type_name' => _("Type"),
> 'priority_name' => _("Priority"),
> 'queue_name' => _("Queue"),
> 'version_name' => _("Version"),
> 'timestamp' => _("Created"),
> 'date_assigned' => _("Assigned"),
> 'date_resolved' => _("Resolved")
> ),
> 'desc' => _("Default sorting criteria:")
> );
>
> // user preferred sorting direction
> $_prefs['sortdir'] = array(
> 'value' => 0,
> 'type' => 'enum',
> 'enum' => array(
> 0 => _("Ascending"),
> 1 => _("Descending")
> ),
> 'desc' => _("Default sorting direction:")
> );
>
> // default view
> $_prefs['whups_default_view'] = array(
> 'value' => 'mybugs',
> 'type' => 'enum',
> 'enum' => array(
> 'mybugs' => _("My Tickets"),
> 'search' => _("Search Tickets"),
> 'ticket/create' => _("Create Ticket")
> ),
> 'desc' => _("Select the view to display after login:")
> );
>
> // show requested tickets in the horde summary?
> $_prefs['summary_show_requested'] = array(
> 'value' => 1,
> 'type' => 'checkbox',
> 'desc' => _("Show tickets you have requested in the summary view?"),
> );
>
> // show ticket ids in the horde summary?
> $_prefs['summary_show_ticket_numbers'] = array(
> 'value' => 1,
> 'type' => 'checkbox',
> 'desc' => _("Show ticket IDs in the summary view?"),
> );
>
> // Allow custom time/date formats in reports
> $_prefs['report_time_format'] = array(
> 'value' => '%m/%d/%y',
> 'type' => 'enum',
> 'enum' => array(
> '%a %d %B' => _("Weekday Day Month"),
> '%c' => _("Weekday Day Month HH:MM:SS TZ"),
> '%m/%d/%y' => _("MM/DD/YY"),
> '%m/%d/%y %H:%M:%S' => _("MM/DD/YY HH:MM:SS"),
> '%d/%m/%y' => _("DD/MM/YY"),
> '%d/%m/%y %H:%M:%S' => _("DD/MM/YY HH:MM:SS"),
> '%y/%m/%d' => _("YY/MM/DD"),
> '%y/%m/%d %H:%M:%S' => _("YY/MM/DD HH:MM:SS"),
> ),
> 'desc' => _("Date/Time format for search results"),
> );
>
> // Skip notification of changes you added?
> $_prefs['email_others_only'] = array(
> 'value' => 1,
> 'type' => 'checkbox',
> 'desc' => _("Only notify me of ticket changes from other users?"),
> );
>
> // Skip notification without comments?
> $_prefs['email_comments_only'] = array(
> 'value' => 0,
> 'type' => 'checkbox',
> 'desc' => _("Only notify me of ticket changes with comments?")
> );
>
> // AutoLink to tickets references in comments
> $_prefs['autolink_tickets'] = array(
> 'value' => 1,
> 'type' => 'checkbox',
> 'desc' => _("Autolink to other tickets in comments?")
> );
>
> // Show ticket comments in ascending or descending order?
> $_prefs['comment_sort_dir'] = array(
> 'value' => 1,
> 'type' => 'enum',
> 'enum' => array(
> 0 => _("Chronological (oldest first)"),
> 1 => _("Most recent first")
> ),
> 'desc' => _("Show comments in chronological order, or most recent
> first?")
> );
>
> // address book selection widget
> $_prefs['sourceselect'] = array(
> 'type' => 'special',
> 'requires_nolock' => array('search_sources'),
> 'handler' => 'Whups_Prefs_Special_Sourceselect'
> );
>
> // Address book(s) to use when expanding addresses
> // Refer to turba/config/sources.php for possible source values
> //
> // You can provide default values this way:
> // 'value' => json_encode(array('source_one', 'source_two'))
>
> $_prefs['search_sources'] = array(
> 'value' => ''
> );
>
> // Field(s) to use when expanding addresses
> // Refer to turba/config/sources.php for possible source and field values
> //
> // If you want to provide a default value, this field depends on the
> // search_sources preference. For example:
> // 'value' => json_encode(array(
> // 'source_one' => array('field_one', 'field_two'),
> // 'source_two' => array('field_three')
> // ))
> // will search the fields 'field_one' and 'field_two' in source_one and
> // 'field_three' in source_two.
> $_prefs['search_fields'] = array(
> 'value' => ''
> );
>
> Regards Hanns
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/To unsubscribe, mail:
> horde-unsubscribe at lists.horde.org
Hey
Since the changes are made to the database but Horde tells you it isn't.
It can be a timeout thing.
Does sql complains about anything in the logs?
If horde is on the same server as mail server you can use:
$conf['mail']['server_name'] = '127.0.01';
Other than that I can't se anything different from my setup.
/erling
More information about the horde
mailing list