Martin Edenhofer | 2 Jun 2008 12:31

Re: Missing 2.3 branch in bugzilla ?

Hi Yann,

I see you got no follow up. It's fixed now in upcoming OTRS 2.3.0  
beta2. :)

Many thanks for your help! :)

  -Martin

On May 21, 2008, at 16:29 , Yann Richard wrote:

> Hi,
>
> I have posted bug for otrs 2.3.0 beta 1 but there is no specific
> version for this new branch in the bugtracker
>
> I have posted it as CVS. it's good for you ?
>
> the bug:
> http://bugs.otrs.org/show_bug.cgi?id=2940
>
> Regards,
> -- 
> M. Yann Richard
> yann.richard on gmail.com
> _______________________________________________
> OTRS mailing list: dev - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/dev
> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

(Continue reading)

Sune T. Tougaard | 3 Jun 2008 10:24
Favicon

Time Units - Normal- vs. Overtime

Hi,
Have tried on the user list but it doesn't appear to be an issue over there. Perhaps you can help?

I'd like to "expand" the "Time Units" field when handling tickets.
My users have a need to distinguish between normal time used on a ticket and overtime used.
(for billing and statistical purposes, for example)

I'm imagining that it's a fairly simple thing to do, but i have no idea how to, as i'm really not a coder.
Just another time field called Overtime, or something.

Of course, the values typed in should be "viewable" in reports and stats and so on, just like the time units is today.

Is it as simple as i think it is?

Have also had a look at the "Time Accounting" module, but... I just didn't get it. And it seems a bit overkill for what i need.

Thanks.

--
/Sune

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
Manuel Hecht - OTRS AG | 3 Jun 2008 13:15
Gravatar

Re: MySQL 5.1 fixes

!W1*.uʋvG^j,)"+,jeɩ׫kקquاZ+a,^~n2I{,(ޮ(!94Rv۬zzw
+v
Manuel Hecht - OTRS AG | 3 Jun 2008 13:24
Gravatar

Re: MySQL 5.1 fixes

Hi Gilles

Many thanks for your feedback!

> If I were you, I'd keep the apostrophes ( ` )... it is simply a matter 
> of prudence and avoiding clashes with possible future MySQL keywords

You're right. But OTRS doesn't use reserved words of ALL supported databases
(MySQL, MSSQL, Oracle, ...). I think, apostrophes are not necessary in the
.sql files.

BTW: We doesn't use apostrophes in ALL .SQL files. If we implemented the
apostrophes in the otrs-schema-post.mysql.sql file, we must also implemented
the apostrophes in all other database-SQL-files.

  Best regards,
  Manuel Hecht

((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing
  Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18
   http://www.otrs.com/ :: Communication with success!

-----Ursprüngliche Nachricht-----
Von: dev-bounces <at> otrs.org [mailto:dev-bounces <at> otrs.org] Im Auftrag von
Gilles Massen
Gesendet: Donnerstag, 22. Mai 2008 21:56
An: Development community of OTRS.org
Betreff: Re: [dev] MySQL 5.1 fixes

Hello Martin and Philip,

If I were you, I'd keep the apostrophes ( ` )... it is simply a matter of
prudence and avoiding clashes with possible future MySQL keywords: 
it's not only reserved characters, but everything that could have a meaning
somewhere. BTW, considering that there are already table names with
underscores (which is a special character...), you are pretty much obliged
to keep them. Additionally readability gets better. On the other I do
appreciate the difficulties in handling string delimiters in code :-/.

BTW, just fyi: the (wrong) syntax was working so far because the foreign key
part was simply ignored by MySQL for MyISAM tables (and the statements
produced plain indexes). If you switched to a foreign key aware engine (e.g.
like InnoDB), MySQL (5.0) complained. Maybe 5.1 got a little more picky on
the syntax...

Regards,
Gilles

Martin Edenhofer wrote:
> Hi Philip,
> 
> I tried to fix it but I saw it's already fixed for upcoming 2.2.7 and 
> higher. :)
> 
> -> http://bugs.otrs.org/show_bug.cgi?id(82
> 
> Both, .sql and .pm file.
> 

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

System Healer | 3 Jun 2008 23:16
Picon

sugarCRM sync

Hello list,

This is my first post.  I'm sorry if this too-oft repeated, but has anybody successfully synced OTRS to SugarCRM?  I'd love to know how!

-Brian

On Tue, Jun 3, 2008 at 10:15 AM, <dev-request <at> otrs.org> wrote:
Welcome to the dev <at> otrs.org mailing list!

To post to this list, send your email to:

 dev <at> otrs.org

General information about the mailing list is at:

 http://lists.otrs.org/cgi-bin/listinfo/dev

If you ever want to unsubscribe or change your options (eg, switch to
or from digest mode, change your password, etc.), visit your
subscription page at:

 http://lists.otrs.org/cgi-bin/options/dev/system.healer%40gmail.com

You can also make such adjustments via email by sending a message to:

 dev-request <at> otrs.org

with the word `help' in the subject or body (don't include the
quotes), and you will get back a message with instructions.

You must know your password to change your options (including changing
the password, itself) or to unsubscribe.  It is:

 k0nr4d

Normally, Mailman will remind you of your otrs.org mailing list
passwords once every month, although you can disable this if you
prefer.  This reminder will also include instructions on how to
unsubscribe or change your account options.  There is also a button on
your options page that will email your current password to you.

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
J.J. | 4 Jun 2008 13:41
Picon
Picon

Kerberos Authentication / HTTPBasicAuth::Replace

hi List!

 

i´ve succesfully configured Kerberos Single Sign On with Apache 2.2 and mod_auth_kerb on Linux and Microsoft ActiveDirectory with OTRS HTTPBasicAuth.

 

It works fine - our Customers / Agents don´t have to logon manually, they get authenticated automagically by Internet Explorer. Only the Agents have to be created before in the OTRS System, Customer Attributes are synchronized via LDAP. Feel free to ask me, if you have more questions about this configuration...  

 

A Problem was that the Username is passed as " USERNAME <at> DOMAIN.COM " from the mod_auth_kerb modul.

So when a customer is authenticated as CUSTOMER <at> DOMAIN.COM AND you want to use samAccountName as customer-id, you have to cut off the <at> DOMAIN.COM from the username. Instead of using samAccountName as customer-id mapping you also can use "userPrincipalName" which would be in the USERNAME <at> DOMAIN.COM Format..

 

for some strange reasons we have to use samAccountName and we can set:

 

$Self->{'AuthModule::HTTPBasicAuth::Replace'} =' <at> DOMAIN.COM;

$Self->{'Customer::AuthModule::HTTPBasicAuth::Replace'} =' <at> DOMAIN.COM';

 

but in the Code it looks like this:

 

--HTTPBasicAuth.pm--

Line 77: $User =~ s/^\Q$Replace\E//;

 

IMHO it should look like this:

 

$User =~ s/\Q$Replace\E//i;

 

( without the ^  - Match the beginning of the line )

 

because Username-Domain-Format can vary depending on the used Webserver-Modul, e.g. modntlm or mod_auth_kerb:

 

NTLM: domain.com\username

 

Kerberos: username <at> domain.com

 

more?...

 

maybe it is worthy enough to change it in the code?

 

thanks/greets

 

jakob

 

 

 

 

 

 




--
GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen!
Jetzt dabei sein: http://www.shortview.de/?mc=sv_ext_mf <at> gmx
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
Martin Edenhofer | 5 Jun 2008 18:50

Re: sugarCRM sync

Hi Healer,

unfortunately I do not know some activity from somebody regarding this  
topic. :-/

  -Martin

PS: JFI, if you need a solution you can contact http://otrs.com/ to  
get commercial help.

On Jun 3, 2008, at 23:16 , System Healer wrote:

> Hello list,
>
> This is my first post.  I'm sorry if this too-oft repeated, but has  
> anybody successfully synced OTRS to SugarCRM?  I'd love to know how!
>
> -Brian
>
> On Tue, Jun 3, 2008 at 10:15 AM, <dev-request <at> otrs.org> wrote:
> Welcome to the dev <at> otrs.org mailing list!
>
> To post to this list, send your email to:
>
>  dev <at> otrs.org
>
> General information about the mailing list is at:
>
>  http://lists.otrs.org/cgi-bin/listinfo/dev
>
> If you ever want to unsubscribe or change your options (eg, switch to
> or from digest mode, change your password, etc.), visit your
> subscription page at:
>
>  http://lists.otrs.org/cgi-bin/options/dev/system.healer%40gmail.com
>
> You can also make such adjustments via email by sending a message to:
>
>  dev-request <at> otrs.org
>
> with the word `help' in the subject or body (don't include the
> quotes), and you will get back a message with instructions.
>
> You must know your password to change your options (including changing
> the password, itself) or to unsubscribe.  It is:
>
>  k0nr4d
>
> Normally, Mailman will remind you of your otrs.org mailing list
> passwords once every month, although you can disable this if you
> prefer.  This reminder will also include instructions on how to
> unsubscribe or change your account options.  There is also a button on
> your options page that will email your current password to you.
>
> _______________________________________________
> OTRS mailing list: dev - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/dev
> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

Alfred Baumann | 9 Jun 2008 18:43
Picon

Additional Field

Hi,

I m an OTRS-Newbie and I have to add an additinal Field to the New Ticket-Form
(including a new Fielt to the Database).
Do I have to insert these field manually or is there an easier way ?

Thanks in advance

Alfred

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
Christoph Nagel | 11 Jun 2008 13:04
Picon
Picon

Re: Java WebServiceClient for OTRS

Hi,

Has anybody a proposal how I can search for tickets?

SOAP only provides search by TicketID. For example, I want to search by
Title.

Regards

Christoph

-----Ursprüngliche Nachricht-----
Von: dev-bounces <at> otrs.org [mailto:dev-bounces <at> otrs.org] Im Auftrag von
jonathan sartin
Gesendet: Freitag, 30. Mai 2008 14:11
An: Development community of OTRS.org
Betreff: Re: [dev] Java WebServiceClient for OTRS

On 30 May 2008, at 12:08, jonathan sartin wrote:

>
> On 30 May 2008, at 10:51, Christoph Nagel wrote:
>
>> Hi Jonathan,
>>
>> have you tested the WSDL with Axis2 1.4 or Axis 1.4?
>
> Works for me with AXIS 1.4 (I have other dependencies on 1.4). I'm  
> using the wsdl2java ant target and which generates stubs just fine.  
> Sorry to be a bit terse, but I'm kind of busy with the day job  
> right now ;-). Sometime I'll package all this up more neatly, but  
> for now I'm rather out of time.
>
> BTW, code has moved to http://opennms.svn.sourceforge.net/viewvc/ 
> opennms/otrs-opennms/
>

Ah, read the AXIS 2 docs. You don't really want rpc/encoded, do  
you ;-) (fair point felix).

So, here's your choice.

1. Use Axis 1.4 and put up with the rpc/encoded nastiness for now.
2. Wait for me to fix it (could be a few weeks - I'm out of time on  
this for now).
3. Fix it yourself.

Cheers ... J
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

Тен Костя | 11 Jun 2008 23:02
Picon
Favicon

(Без темы)

94R≥╗╔┼x%┼к]zУ·n√═zm╖ЪХ╤╩(╝ю╜хb╫Хm╤÷Ъ√+-╡▀k╡┼ЮЧ≤╘z╧ ┼_щzТХ╨{.nг+┴╥║╤зЧX╛╤й-╝й+┐В ┴╦╖ЧX╛╤)ъёВ^

Gmane