[otrs] Adding a database field

[Jonathon]

I need to add an expiration date to the customer_user table.  I need to
figure out how to add the expiration date to the Customer_User interface and
automatically set a user to invalid when that date arrives? Any ideas from
anyone on how to do this?

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

RE: [otrs] GetTableData SQL syntax error

[Jonathon]

To show all the just agents not administrators right?

 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rui
Silva
Sent: Wednesday, July 18, 2007 4:04 PM
To: User questions and discussions about OTRS.org
Subject: Re: [otrs] GetTableData SQL syntax error

 

I don't want customers. I want agents!!
But I think that that function is used for both.

I'll try to substitute the What => '$self... for What=> '*'

not sure that will do the trick but. 

regards,

Rui Silva

On 7/18/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]
 > wrote:


Try SELECT * FROM customer_user; and make that the limit is set to zero. 

--Original Mail--
From: "Rui Silva" <[EMAIL PROTECTED]>
To: 
Sent: Wed, 18 Jul 2007 17:50:48 +0100 
Subject: [otrs] GetTableData SQL syntax error

Good evening,

I'm deploying OTRS and I'm having a problem.

In User administration, the user list doesn't appear (no Users showed).
In the log file I have this errors regarding to this problem: 

[Wed Jul 18 16:11:56 2007][Error][Kernel::System::DB::GetTableData][668] You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '  ,  FROM 
system_user' at line 1, SQL: 'SELECT ,  ,  FROM system_user '
[Wed Jul 18 16:11:57
2007][Debug][Kernel::System::Web::InterfaceAgent::Run][714] Global handle
stopped.

My config is.
OTRS 2.1.7 
LDAP Backend for agents and customers
Windows XP ( I know it's not the best way to do it, but :( )


I couldn't find the answer using google, so I'm hoping that you gurus out
there help me with this. 

Regards,

Rui Silva
Portugal


___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
> http://www.otrs.com/




-- 
Rui Silva
http://rukinhas.no-ip.org 

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

Re: [otrs] GetTableData SQL syntax error

[jonathon]

Try SELECT * FROM customer_user; and make that the limit is set to zero.

--Original Mail--
From: "Rui Silva" <[EMAIL PROTECTED]>
To: 
Sent: Wed, 18 Jul 2007 17:50:48 +0100
Subject: [otrs] GetTableData SQL syntax error

Good evening,

I'm deploying OTRS and I'm having a problem.

In User administration, the user list doesn't appear (no Users showed).
In the log file I have this errors regarding to this problem:

[Wed Jul 18 16:11:56 2007][Error][Kernel::System::DB::GetTableData][668] You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '  ,  FROM
system_user' at line 1, SQL: 'SELECT ,  ,  FROM system_user '
[Wed Jul 18 16:11:57
2007][Debug][Kernel::System::Web::InterfaceAgent::Run][714] Global handle
stopped.

My config is.
OTRS 2.1.7
LDAP Backend for agents and customers
Windows XP ( I know it's not the best way to do it, but :( )


I couldn't find the answer using google, so I'm hoping that you gurus out
there help me with this.

Regards,

Rui Silva
Portugal


___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

RE: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being Set -

[Jonathon]

You can set the kernel.domainname in linux by "sysctl -w
kernel.domainname=". That is without the <> of course. Linux is
a bit touchy. Typically is the domain name is not setup during installation
you have to jump through hoops to get it to work. I imagine that you set the
domain name in the hosts file and in the resolv.conf file. They all work
together.  

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Sanson, Rick
Sent: Wednesday, July 18, 2007 11:02 AM
To: otrs
Subject: RE: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being Set -

Thanks!

And I said I was Linux savvy...

The kernel.domainname = none

The FQDN that keeps popping up (for hours and hours!) is fc4

We sure learn a lot finding the answer to these things don't we! I think 
that is what drives us as technologists... I does me!

-Original Message-
From: Nils Breunese (Lemonbit) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 9:37 AM
To: User questions and discussions about OTRS.org
Subject: Re: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being Set 
-

Rick Sanson wrote:

> No I haven't, Jonathon!
>
> Where is that? I am unable to search from sysconfig (for whatever
> reason) and I dont see it in framework...
>
> ???
>
> Please advise!

He is talking about sysctl (a commandline tool not related to OTRS),  
not about SysConfig in OTRS. I have never needed to use sysctl to get  
this to work though.

Nils Breunese,

> -Original Message-
> From: Jonathon [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 18, 2007 9:09 AM
> To: 'User questions and discussions about OTRS.org'
> Subject: RE: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being  
> Set
> -
> Importance: High
>
>
> Did you try setting the domain name in the kernel settings also?  
> You can
> look at the kernel.domainname setting using sysctl.
>
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On  
> Behalf Of
> Sanson, Rick
> Sent: Wednesday, July 18, 2007 9:28 AM
> To: otrs
> Subject: RE: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being  
> Set
> -
>
> Thank you guys!
>
> This installation is a VM that came from VMware's repository and was
> built buy unknown.
>
> I am Linux savvy so I'll do as Steve Carr suggests and rebuild as  
> these
> symptoms make no sense. I really used the VM to do some evaluation  
> work
> anyway, have decided to go with OTRS and need to implement a more
> production-like server anyway. This cannot be that hard and the  
> FQDN is
> defined in the place where all indications point; Config.pm.
>
> I do intend to restore this setup just to see if the OS had any impact
> on the FQDN issue (I doubt it).
>
> Thank you all!
>
>
> -Original Message-
> From: Nils Breunese (Lemonbit) [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 18, 2007 2:26 AM
> To: User questions and discussions about OTRS.org
> Subject: Re: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being  
> Set
> -
>
> Steven Carr wrote:
>
>> Sanson, Rick wrote:
>>> This is properly configured with the hostname of my actual FQDN...
>>>
>>> What is the matter here???
>>
>> Pass, not too sure, have you thought about upgrading to a newer
>> version
>> of fedora? just incase there is some bug/issue with that particular
>> version of fedora, not sure how many (if any) others are using FC4  
>> for
>> their OTRS installations.
>
> FC5 is went EOL a couple of weeks ago, so if Rick is really still
> running FC4 it might be time to upgrade, yeah. Still that shouldn't
> keep him from setting his FQDN. I also have no idea why the change
> won't stick. Have you tried enabling verbose logging? Maybe the logs
> will show something interesting.
>
> Nils Breunese.


___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=http://www.otrs.com/

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

RE: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being Set -

[Jonathon]

No I meant in the linux OS itself. The command to find the kernel setting
for linux for the domainname is "sysctl kernel.domainname" Is you FQDN an
actual domain name or are you using a "dummy" FQDN?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Sanson, Rick
Sent: Wednesday, July 18, 2007 10:30 AM
To: otrs
Subject: RE: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being Set -

No I haven't, Jonathon!

Where is that? I am unable to search from sysconfig (for whatever 
reason) and I dont see it in framework...

???

Please advise!

Thank you!

-Original Message-
From: Jonathon [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 9:09 AM
To: 'User questions and discussions about OTRS.org'
Subject: RE: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being Set 
-
Importance: High


Did you try setting the domain name in the kernel settings also? You can
look at the kernel.domainname setting using sysctl.




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Sanson, Rick
Sent: Wednesday, July 18, 2007 9:28 AM
To: otrs
Subject: RE: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being Set 
-

Thank you guys!

This installation is a VM that came from VMware's repository and was 
built buy unknown.

I am Linux savvy so I'll do as Steve Carr suggests and rebuild as these 
symptoms make no sense. I really used the VM to do some evaluation work 
anyway, have decided to go with OTRS and need to implement a more 
production-like server anyway. This cannot be that hard and the FQDN is 
defined in the place where all indications point; Config.pm.

I do intend to restore this setup just to see if the OS had any impact 
on the FQDN issue (I doubt it).

Thank you all!


-Original Message-
From: Nils Breunese (Lemonbit) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 2:26 AM
To: User questions and discussions about OTRS.org
Subject: Re: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being Set 
-

Steven Carr wrote:

> Sanson, Rick wrote:
>> This is properly configured with the hostname of my actual FQDN...
>>
>> What is the matter here???
>
> Pass, not too sure, have you thought about upgrading to a newer  
> version
> of fedora? just incase there is some bug/issue with that particular
> version of fedora, not sure how many (if any) others are using FC4 for
> their OTRS installations.

FC5 is went EOL a couple of weeks ago, so if Rick is really still  
running FC4 it might be time to upgrade, yeah. Still that shouldn't  
keep him from setting his FQDN. I also have no idea why the change  
won't stick. Have you tried enabling verbose logging? Maybe the logs  
will show something interesting.

Nils Breunese.



___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=http://www.otrs.com/

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/


___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=http://www.otrs.com/

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

RE: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being Set -

[Jonathon]

Did you try setting the domain name in the kernel settings also? You can
look at the kernel.domainname setting using sysctl.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Sanson, Rick
Sent: Wednesday, July 18, 2007 9:28 AM
To: otrs
Subject: RE: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being Set -

Thank you guys!

This installation is a VM that came from VMware's repository and was 
built buy unknown.

I am Linux savvy so I'll do as Steve Carr suggests and rebuild as these 
symptoms make no sense. I really used the VM to do some evaluation work 
anyway, have decided to go with OTRS and need to implement a more 
production-like server anyway. This cannot be that hard and the FQDN is 
defined in the place where all indications point; Config.pm.

I do intend to restore this setup just to see if the OS had any impact 
on the FQDN issue (I doubt it).

Thank you all!


-Original Message-
From: Nils Breunese (Lemonbit) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 2:26 AM
To: User questions and discussions about OTRS.org
Subject: Re: No-one has setup the FQDN??? RE: [otrs] FQDN Not Being Set 
-

Steven Carr wrote:

> Sanson, Rick wrote:
>> This is properly configured with the hostname of my actual FQDN...
>>
>> What is the matter here???
>
> Pass, not too sure, have you thought about upgrading to a newer  
> version
> of fedora? just incase there is some bug/issue with that particular
> version of fedora, not sure how many (if any) others are using FC4 for
> their OTRS installations.

FC5 is went EOL a couple of weeks ago, so if Rick is really still  
running FC4 it might be time to upgrade, yeah. Still that shouldn't  
keep him from setting his FQDN. I also have no idea why the change  
won't stick. Have you tried enabling verbose logging? Maybe the logs  
will show something interesting.

Nils Breunese.



___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=http://www.otrs.com/

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

[otrs] Register Company Users

[Jonathon]

Is there a way to change the Company User registration in the Administration
Module so that the Email is not required? I need to load some test data and
the users won't be real users so they will not have valid email addresses.

 

Thank You

Jonathon

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

RE: [otrs] RE: Changing the Customer View

[Jonathon]

Thank you! I imagine I need to register the "pm"? 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Gerhard Weber
Sent: Thursday, July 12, 2007 8:18 AM
To: otrs@otrs.org
Subject: [otrs] RE: Changing the Customer View

Hi,

according to
http://doc.otrs.org/developer/2.2/en/html/c684.html#custom-translation-f
ile 
the way you "should" do it, is create a "Custom Translation File"
Kernel/Language/en_Custom.pm
(probably /opt/otrs/Kernel/Language/en_Custom.pm).
This way it might be simpler to update the system.

Something like this:

sub Data {
my $Self = shift;
my %Param = @_;

# $$START$$

# own translations
$Self->{Translation}->{'CompanyTickets'} = 'School Ticket';

# $$STOP$$
}

Greetings,
gerhard

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=http://www.otrs.com/

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

[otrs] Changing the Customer View

[Jonathon]

I have OTRS 2.2.1 and am using it for school district ticket management. I
was wondering if there is an easy way to display the "Company Ticket" as
"School Ticket"? Anyone have any ideas ?

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

RE: [otrs] setting up to email out

[Jonathon]

The Config.pm file should be under /opt/otrs/Kernel/ or where ever you
installed the otrs software. The easiest way to find it would be to do a
"find / -name Config.pm" without the quotations of course.

 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Meyer
Sent: Tuesday, July 10, 2007 12:15 PM
To: otrs@otrs.org
Subject: [otrs] setting up to email out

 

What files do I need to edit to get OTRS to send email out?  I can't seem to
find it in the Config.pm file.  Where is it?  I'm on Debian Etch.  

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

[otrs] Customer Ticket View

[Jonathon]

I am new to OTRS and was wondering if there was a way I could limit customer
users to only see their tickets. Would it be as simple as removing the
CompanyTicket module from the Customer View?

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

[otrs] Customer to Company relationship

[Jonathon]

Is there a way to only allow a user to register to a certain company? Or add
the Company name to the Self Registration Module?

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

[otrs] Company Logo in the header

[Jonathon]

I have been trying to insert a image in the header portion of the css.dtl
but the image is repeating even though I have the background-repeat set to
no-repeat. Has anyone successfully done this?

___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/