Re: [otrs] Survey module : is there some manual, howto or informations somewhere about it ?
Hi, This has nothing to do with a reply to survey module informations but ... Did you go properly through all installation steps as defined in the documentation on otrs.org website : http://doc.otrs.org/2.2/en/html/c267.html Basically, Admin login/password are defined through the installer.pl step as you can see on screenshots provided on the page. Best regards, Laurent MINOST Cece Yaya Sudarya a écrit : Dear Laurent, Yes, I am a newbie looking for ticket number for application. I decided to download OTRS for Windows (since my company regulation is using Bill Gates :D), but after it has been installed, I tried to login the application and it said invalid/wrong user name and password :( I have reinstalled for 3 times, but it has same result :( I have tried yesterday to find any documentation for this issue, but I have no got any. Is there anybody could help me? Thank you for your attention and cooperation. Regards, Cece Yaya Sudarya On 11/5/07, *Laurent Minost* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi, I think all is in the subject :) How do we use this module please ? I have it installed on my OTRS 2.2.3 but don't know how to clearly and precisely use it. It could be useful but searching otrs.org/mailing http://otrs.org/mailing list archives and Google did not lead me to any clear documentations, howto or informations about it :( So if someone use it or if any OTRS dev could paste us a little how-to here or do a FAQ article, I think it will help a few people by now and in the future. Thanks by advance. Best regards, Laurent MINOST ___ 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] Automatically assigning people to a queue by their mail address domain
Hi, According to the OTRS doc (http://doc.otrs.org/2.2/en/html/x846.html#adminarea-customer-user-groups), you have to manually assign customers to a group (and therefor to a queue), or use the CustomerAlwaysGroup option to assign every new customer to a single group. My problem is that I have several queues, each assigned to a customer's company with some customers which I don't wan't to see/post any other queue than their company's queue. So : 1) Is there a way to configure OTRS so that every new customer is automatically assigned to a queue, according to the domain of his mail address? 2) If first answer is yes, is there a way to do the same with the customers that are already registered? Thx for the answers B. _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail ___ 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] MySQL Admin Problems
Hi, I'm running OTRS 2.1.7, and I've been having a problem with Apache failing. So I want to upgrade to 2.2 hoping this might fix it. What this entails is backing up the MySQL database, uninstalling the current version of OTRS, and then reinstalling the new one, making sure to copy over my config files. Now, I'm not knowledgeable of MySQL at all, so I want to use a user-friendly application to work with the database in order to avoid errors. I downloaded and installed MySQL tools from the MySQL website, and the Administrator tool is picking up the MySQL database using the default OTRS Username and Password. The Administrator isn't connecting to the database correctly however, when I so into User Administration, I get the following error: 'A MySQL error was encountered. The message is: Could not fetch user names. The following error occurred: SELECT command denied to user 'otrs'@'localhost' for table 'user' (1142). As far as I can find out, this means that the proper user privileges have not been set for the database, but I don't know how to fix this, or how to adjust and save the correct config files. If someone could point me in the right direction, I'd really appreciate it. Thanks! Emily ___ 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] Automatically assigning people to a queue by their mail address domain
Hi, I have no answer about your question, sorry. but I would just mention a thing : I think it's a bad idea to implement an automatic queue affecting system based on source domains like you want to do. Imagine this simple case : - Customer 1 from Company A with email [EMAIL PROTECTED] sends you a mail, this one will be directed to Queue A based on your established rules of domain email address. - Customer 2 from Company B with email [EMAIL PROTECTED] sends you another mail, this one could be badly directed to the wrong Queue A rather than Queue Other based on a malformed rule ... Just consider the problem and all the situations you will have to face ... and also consider that source email address can easily be forged. Best regards, Laurent MINOST Boris Ratak a écrit : Hi, According to the OTRS doc (http://doc.otrs.org/2.2/en/html/x846.html#adminarea-customer-user-groups), you have to manually assign customers to a group (and therefor to a queue), or use the CustomerAlwaysGroup option to assign every new customer to a single group. My problem is that I have several queues, each assigned to a customer's company with some customers which I don't wan't to see/post any other queue than their company's queue. So : 1) Is there a way to configure OTRS so that every new customer is automatically assigned to a queue, according to the domain of his mail address? 2) If first answer is yes, is there a way to do the same with the customers that are already registered? Thx for the answers B. Ne gardez plus qu'une seule adresse mail ! Copiez vos mails http://www.trueswitch.com/yahoo-fr/ vers Yahoo! Mail ___ 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] MySQL Admin Problems
Hi, Your problem seems to be only related with bad/insufficient privileges accorded to your otrs user. phpMyAdmin is a web-based tool to easily manage MySQL servers, it could help on your case : http://www.phpmyadmin.net/ You will probably also need to read some documentations about MySQL Administration, you will find many howtos on Google, this one can be a beginning : http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch34_:_Basic_MySQL_Configuration Basic steps of the OTRS installation procedure can also be useful since it seems all is not properly configure on your current installation : http://doc.otrs.org/2.2/en/html/c267.html Best regards, Laurent MINOST Emily Flynn a écrit : Hi, I’m running OTRS 2.1.7, and I’ve been having a problem with Apache failing. So I want to upgrade to 2.2 hoping this might fix it. What this entails is backing up the MySQL database, uninstalling the current version of OTRS, and then reinstalling the new one, making sure to copy over my config files. Now, I’m not knowledgeable of MySQL at all, so I want to use a user-friendly application to work with the database in order to avoid errors. I downloaded and installed MySQL tools from the MySQL website, and the Administrator tool is picking up the MySQL database using the default OTRS Username and Password. The Administrator isn’t connecting to the database correctly however, when I so into User Administration, I get the following error: ‘A MySQL error was encountered. The message is: Could not fetch user names. The following error occurred: SELECT command denied to user [EMAIL PROTECTED] for table ‘user’ (1142). As far as I can find out, this means that the proper user privileges have not been set for the database, but I don’t know how to fix this, or how to adjust and save the correct config files. If someone could point me in the right direction, I’d really appreciate it. Thanks! Emily ___ 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] MySQL Admin Problems
Thanks for your answer Laurent. It turns out I was logging into the database with the default MySQL 'user' as opposed to 'root'. So when I logged in as root admin, all was fine, I changed passwords, created a user, and I can go about managing the database. I'm actually running otrs on an XPSP2 machine, and I tried PHPMyAdmin already, but I had difficulties installing the PHP. During the installation of PHP, a list of available extensions are given and It's recommended to install only the necessary extensions as problems can arise if you install everything (I did try that - and problems did indeed arise..). I couldn't find out which were the correct extensions to install (this was my first encounter with PHP) and when someone suggested the desktop GUI MySQL Administrator, I thought I'd try that. I still would have like to get PHP installed, as it could be something I'd look into working with. If anyone knows what extensions I should install, I'd gladly take any advice! Thanks again -Emily -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Laurent Minost Sent: 06 November 2007 11:03 To: User questions and discussions about OTRS.org Subject: Re: [otrs] MySQL Admin Problems Hi, Your problem seems to be only related with bad/insufficient privileges accorded to your otrs user. phpMyAdmin is a web-based tool to easily manage MySQL servers, it could help on your case : http://www.phpmyadmin.net/ You will probably also need to read some documentations about MySQL Administration, you will find many howtos on Google, this one can be a beginning : http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch34_:_Basic _MySQL_Configuration Basic steps of the OTRS installation procedure can also be useful since it seems all is not properly configure on your current installation : http://doc.otrs.org/2.2/en/html/c267.html Best regards, Laurent MINOST Emily Flynn a écrit : Hi, Im running OTRS 2.1.7, and Ive been having a problem with Apache failing. So I want to upgrade to 2.2 hoping this might fix it. What this entails is backing up the MySQL database, uninstalling the current version of OTRS, and then reinstalling the new one, making sure to copy over my config files. Now, Im not knowledgeable of MySQL at all, so I want to use a user-friendly application to work with the database in order to avoid errors. I downloaded and installed MySQL tools from the MySQL website, and the Administrator tool is picking up the MySQL database using the default OTRS Username and Password. The Administrator isnt connecting to the database correctly however, when I so into User Administration, I get the following error: A MySQL error was encountered. The message is: Could not fetch user names. The following error occurred: SELECT command denied to user [EMAIL PROTECTED] for table user (1142). As far as I can find out, this means that the proper user privileges have not been set for the database, but I dont know how to fix this, or how to adjust and save the correct config files. If someone could point me in the right direction, Id really appreciate it. Thanks! Emily ___ 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: [otrs] Creating a new user agent (Postgres, Mac OSX)
Hi Andy, Here's the result of my running otrs.checkmodules: CGI ... ok Date::Pcalc ... ok Date::Format ... ok DBI ... ok DBD::mysql ... not installed! (required - use perl -MCPAN -e shell;) Digest::MD5 ... ok Crypt::PasswdMD5 ... ok LWP::UserAgent ... ok IO::Scalar ... ok IO::Wrap ... ok MIME::Base64 ... ok MIME::Tools ... ok Mail::Internet ... ok Net::DNS ... ok Net::POP3 ... ok Net::LDAP ... ok Net::SMTP ... ok Authen::SASL ... ok GD ... ok GD::Text ... ok GD::Graph ... ok GD::Graph::lines ... ok GD::Text::Align ... ok XML::Parser ... ok PDF::API2 ... ok Compress::Zlib ... ok Note that I am using Postgres so I shouldn't really need DBD::mysql. Thanks, - Manoj On Nov 5, 2007, at 5:48 PM, Andy Lubel wrote: Wow, this is proving annoying to do.. Taking more effort than I expected, the perl installed is multi-threaded Can you paste your otrs.checkmodules? This is mine: CGI ... ok Date::Pcalc ... not installed! Date::Format ... not installed! DBI ... ok DBD::mysql ... not installed! Digest::MD5 ... ok Crypt::PasswdMD5 ... not installed! LWP::UserAgent ... ok IO::Scalar ... ok IO::Wrap ... ok MIME::Base64 ... ok MIME::Tools ... ok Mail::Internet ... ok Net::DNS ... version 0.60 is not useable with OTRS. Please use an older or an newer one. Net::POP3 ... ok Net::LDAP ... ok Net::SMTP ... ok Authen::SASL ... ok GD ... not installed! (for stats - not required) GD::Text ... not installed! (for stats - not required) GD::Graph ... not installed! (for stats - not required) GD::Graph::lines ... not installed! (for stats - not required) GD::Text::Align ... not installed! (for stats - not required) XML::Parser ... ok PDF::API2 ... not installed! (for PDF output - not required) Compress::Zlib ... ok UGH. Well good news is I have a support contract, where they say they support OS X. -Andy On 11/4/07 11:00 AM, Manoj Patwardhan [EMAIL PROTECTED] wrote: Thanks Andy! Your help is greatly appreciated. - Manoj Patwardhan On Nov 4, 2007, at 10:53 AM, Andy Lubel wrote: dude, leopard has been out for a week.. us experts havent had a chance to test yet, although it should work. major difference that i can think of being apache. ill be running through an install on my dev environment with leopard and will try to replicate your issue. only thing is i use mysql instead of postgress. -Andy Lubel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manoj Patwardhan Sent: Sunday, November 04, 2007 9:40 AM To: otrs@otrs.org Subject: [otrs] Creating a new user agent (Postgres, Mac OSX) I downloaded OTRS 2.2.3 to install on Mac OS 10.5 (Leopard) and want to use Postgres as the back end. I followed instructions and was able to eventually log in as [EMAIL PROTECTED] and create groups and roles. However, when I try to create a new user agent, nothing happens. I looked at the Apache (2.2) error log and the message I see is the following: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: darwin Time: Sun Nov 4 09:22:10 2007, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] Message: Need UserID!, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] Traceback (858): , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Output::HTML::PreferencesCustomQueue::Param (v1.7) Line: 49, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Modules::AdminUser::_Edit (v1.42 ) Line: 383, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Modules::AdminUser::Run (v1.42 ) Line: 214, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::System::Web::InterfaceAgent::Run (v1.23) Line: 670, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: / Users/manoj/exp/httproot/otrs/bin/cgi-bin/index.pl (v1.81) Line: 47, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04
Re: [otrs] Creating a new user agent (Postgres, Mac OSX)
Hi Andy, Here's the result of my running otrs.checkmodules: CGI ... ok Date::Pcalc ... ok Date::Format ... ok DBI ... ok DBD::mysql ... not installed! (required - use perl -MCPAN - e shell;) Digest::MD5 ... ok Crypt::PasswdMD5 ... ok LWP::UserAgent ... ok IO::Scalar ... ok IO::Wrap ... ok MIME::Base64 ... ok MIME::Tools ... ok Mail::Internet ... ok Net::DNS ... ok Net::POP3 ... ok Net::LDAP ... ok Net::SMTP ... ok Authen::SASL ... ok GD ... ok GD::Text ... ok GD::Graph ... ok GD::Graph::lines ... ok GD::Text::Align ... ok XML::Parser ... ok PDF::API2 ... ok Compress::Zlib ... ok Note that I am using Postgres so I shouldn't really need DBD::mysql. Thanks, - Manoj On Nov 5, 2007, at 5:48 PM, Andy Lubel wrote: Wow, this is proving annoying to do.. Taking more effort than I expected, the perl installed is multi-threaded Can you paste your otrs.checkmodules? This is mine: CGI ... ok Date::Pcalc ... not installed! Date::Format ... not installed! DBI ... ok DBD::mysql ... not installed! Digest::MD5 ... ok Crypt::PasswdMD5 ... not installed! LWP::UserAgent ... ok IO::Scalar ... ok IO::Wrap ... ok MIME::Base64 ... ok MIME::Tools ... ok Mail::Internet ... ok Net::DNS ... version 0.60 is not useable with OTRS. Please use an older or an newer one. Net::POP3 ... ok Net::LDAP ... ok Net::SMTP ... ok Authen::SASL ... ok GD ... not installed! (for stats - not required) GD::Text ... not installed! (for stats - not required) GD::Graph ... not installed! (for stats - not required) GD::Graph::lines ... not installed! (for stats - not required) GD::Text::Align ... not installed! (for stats - not required) XML::Parser ... ok PDF::API2 ... not installed! (for PDF output - not required) Compress::Zlib ... ok UGH. Well good news is I have a support contract, where they say they support OS X. -Andy On 11/4/07 11:00 AM, Manoj Patwardhan [EMAIL PROTECTED] wrote: Thanks Andy! Your help is greatly appreciated. - Manoj Patwardhan On Nov 4, 2007, at 10:53 AM, Andy Lubel wrote: dude, leopard has been out for a week.. us experts havent had a chance to test yet, although it should work. major difference that i can think of being apache. ill be running through an install on my dev environment with leopard and will try to replicate your issue. only thing is i use mysql instead of postgress. -Andy Lubel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manoj Patwardhan Sent: Sunday, November 04, 2007 9:40 AM To: otrs@otrs.org Subject: [otrs] Creating a new user agent (Postgres, Mac OSX) I downloaded OTRS 2.2.3 to install on Mac OS 10.5 (Leopard) and want to use Postgres as the back end. I followed instructions and was able to eventually log in as [EMAIL PROTECTED] and create groups and roles. However, when I try to create a new user agent, nothing happens. I looked at the Apache (2.2) error log and the message I see is the following: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: darwin Time: Sun Nov 4 09:22:10 2007, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] Message: Need UserID!, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] Traceback (858): , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Output::HTML::PreferencesCustomQueue::Param (v1.7) Line: 49, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Modules::AdminUser::_Edit (v1.42 ) Line: 383, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Modules::AdminUser::Run (v1.42 ) Line: 214, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::System::Web::InterfaceAgent::Run (v1.23) Line: 670, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: / Users/manoj/exp/httproot/otrs/bin/cgi-bin/index.pl (v1.81) Line: 47, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] , referer:
Re: [otrs] Creating a new user agent (Postgres, Mac OSX)
Can you give me any insight into how you installed the needed modules or did you upgrade your OSX to a later version without erasing the disk? Im having a hell of a time just installing Date::Pcalc.. What architecture are you on, PPC or Intel? Thanks, -Andy On 11/6/07 8:52 AM, Manoj Patwardhan [EMAIL PROTECTED] wrote: Hi Andy, Here's the result of my running otrs.checkmodules: CGI ... ok Date::Pcalc ... ok Date::Format ... ok DBI ... ok DBD::mysql ... not installed! (required - use perl -MCPAN - e shell;) Digest::MD5 ... ok Crypt::PasswdMD5 ... ok LWP::UserAgent ... ok IO::Scalar ... ok IO::Wrap ... ok MIME::Base64 ... ok MIME::Tools ... ok Mail::Internet ... ok Net::DNS ... ok Net::POP3 ... ok Net::LDAP ... ok Net::SMTP ... ok Authen::SASL ... ok GD ... ok GD::Text ... ok GD::Graph ... ok GD::Graph::lines ... ok GD::Text::Align ... ok XML::Parser ... ok PDF::API2 ... ok Compress::Zlib ... ok Note that I am using Postgres so I shouldn't really need DBD::mysql. Thanks, - Manoj On Nov 5, 2007, at 5:48 PM, Andy Lubel wrote: Wow, this is proving annoying to do.. Taking more effort than I expected, the perl installed is multi-threaded Can you paste your otrs.checkmodules? This is mine: CGI ... ok Date::Pcalc ... not installed! Date::Format ... not installed! DBI ... ok DBD::mysql ... not installed! Digest::MD5 ... ok Crypt::PasswdMD5 ... not installed! LWP::UserAgent ... ok IO::Scalar ... ok IO::Wrap ... ok MIME::Base64 ... ok MIME::Tools ... ok Mail::Internet ... ok Net::DNS ... version 0.60 is not useable with OTRS. Please use an older or an newer one. Net::POP3 ... ok Net::LDAP ... ok Net::SMTP ... ok Authen::SASL ... ok GD ... not installed! (for stats - not required) GD::Text ... not installed! (for stats - not required) GD::Graph ... not installed! (for stats - not required) GD::Graph::lines ... not installed! (for stats - not required) GD::Text::Align ... not installed! (for stats - not required) XML::Parser ... ok PDF::API2 ... not installed! (for PDF output - not required) Compress::Zlib ... ok UGH. Well good news is I have a support contract, where they say they support OS X. -Andy On 11/4/07 11:00 AM, Manoj Patwardhan [EMAIL PROTECTED] wrote: Thanks Andy! Your help is greatly appreciated. - Manoj Patwardhan On Nov 4, 2007, at 10:53 AM, Andy Lubel wrote: dude, leopard has been out for a week.. us experts havent had a chance to test yet, although it should work. major difference that i can think of being apache. ill be running through an install on my dev environment with leopard and will try to replicate your issue. only thing is i use mysql instead of postgress. -Andy Lubel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manoj Patwardhan Sent: Sunday, November 04, 2007 9:40 AM To: otrs@otrs.org Subject: [otrs] Creating a new user agent (Postgres, Mac OSX) I downloaded OTRS 2.2.3 to install on Mac OS 10.5 (Leopard) and want to use Postgres as the back end. I followed instructions and was able to eventually log in as [EMAIL PROTECTED] and create groups and roles. However, when I try to create a new user agent, nothing happens. I looked at the Apache (2.2) error log and the message I see is the following: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: darwin Time: Sun Nov 4 09:22:10 2007, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] Message: Need UserID!, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] Traceback (858): , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Output::HTML::PreferencesCustomQueue::Param (v1.7) Line: 49, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Modules::AdminUser::_Edit (v1.42 ) Line: 383, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Modules::AdminUser::Run (v1.42 ) Line: 214, referer:
Re: [otrs] Creating a new user agent (Postgres, Mac OSX)
Can you give me any insight into how you installed the needed modules or did you upgrade your OSX to a later version without erasing the disk? It was a clean install of Leopard (after erasing the disk). To install the modules I used the CPAN shell running as root. It just worked first shot. Im having a hell of a time just installing Date::Pcalc.. What architecture are you on, PPC or Intel? Intel. - Manoj On 11/6/07 8:52 AM, Manoj Patwardhan [EMAIL PROTECTED] wrote: Hi Andy, Here's the result of my running otrs.checkmodules: CGI ... ok Date::Pcalc ... ok Date::Format ... ok DBI ... ok DBD::mysql ... not installed! (required - use perl - MCPAN - e shell;) Digest::MD5 ... ok Crypt::PasswdMD5 ... ok LWP::UserAgent ... ok IO::Scalar ... ok IO::Wrap ... ok MIME::Base64 ... ok MIME::Tools ... ok Mail::Internet ... ok Net::DNS ... ok Net::POP3 ... ok Net::LDAP ... ok Net::SMTP ... ok Authen::SASL ... ok GD ... ok GD::Text ... ok GD::Graph ... ok GD::Graph::lines ... ok GD::Text::Align ... ok XML::Parser ... ok PDF::API2 ... ok Compress::Zlib ... ok Note that I am using Postgres so I shouldn't really need DBD::mysql. Thanks, - Manoj On Nov 5, 2007, at 5:48 PM, Andy Lubel wrote: Wow, this is proving annoying to do.. Taking more effort than I expected, the perl installed is multi-threaded Can you paste your otrs.checkmodules? This is mine: CGI ... ok Date::Pcalc ... not installed! Date::Format ... not installed! DBI ... ok DBD::mysql ... not installed! Digest::MD5 ... ok Crypt::PasswdMD5 ... not installed! LWP::UserAgent ... ok IO::Scalar ... ok IO::Wrap ... ok MIME::Base64 ... ok MIME::Tools ... ok Mail::Internet ... ok Net::DNS ... version 0.60 is not useable with OTRS. Please use an older or an newer one. Net::POP3 ... ok Net::LDAP ... ok Net::SMTP ... ok Authen::SASL ... ok GD ... not installed! (for stats - not required) GD::Text ... not installed! (for stats - not required) GD::Graph ... not installed! (for stats - not required) GD::Graph::lines ... not installed! (for stats - not required) GD::Text::Align ... not installed! (for stats - not required) XML::Parser ... ok PDF::API2 ... not installed! (for PDF output - not required) Compress::Zlib ... ok UGH. Well good news is I have a support contract, where they say they support OS X. -Andy On 11/4/07 11:00 AM, Manoj Patwardhan [EMAIL PROTECTED] wrote: Thanks Andy! Your help is greatly appreciated. - Manoj Patwardhan On Nov 4, 2007, at 10:53 AM, Andy Lubel wrote: dude, leopard has been out for a week.. us experts havent had a chance to test yet, although it should work. major difference that i can think of being apache. ill be running through an install on my dev environment with leopard and will try to replicate your issue. only thing is i use mysql instead of postgress. -Andy Lubel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manoj Patwardhan Sent: Sunday, November 04, 2007 9:40 AM To: otrs@otrs.org Subject: [otrs] Creating a new user agent (Postgres, Mac OSX) I downloaded OTRS 2.2.3 to install on Mac OS 10.5 (Leopard) and want to use Postgres as the back end. I followed instructions and was able to eventually log in as [EMAIL PROTECTED] and create groups and roles. However, when I try to create a new user agent, nothing happens. I looked at the Apache (2.2) error log and the message I see is the following: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: darwin Time: Sun Nov 4 09:22:10 2007, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] Message: Need UserID!, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] Traceback (858): , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Output::HTML::PreferencesCustomQueue::Param (v1.7) Line: 49, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Modules::AdminUser::_Edit (v1.42 ) Line: 383, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Modules::AdminUser::Run (v1.42 ) Line: 214, referer:
Re: [otrs] Creating a new user agent (Postgres, Mac OSX)
Yeah, I'm still PPC here and its a little different than the intel perl I suspect. xservedev:~ root# perl --version This is perl, v5.8.8 built for darwin-thread-multi-2level What's yours say? On 11/6/07 10:18 AM, Manoj Patwardhan [EMAIL PROTECTED] wrote: Can you give me any insight into how you installed the needed modules or did you upgrade your OSX to a later version without erasing the disk? It was a clean install of Leopard (after erasing the disk). To install the modules I used the CPAN shell running as root. It just worked first shot. Im having a hell of a time just installing Date::Pcalc.. What architecture are you on, PPC or Intel? Intel. - Manoj On 11/6/07 8:52 AM, Manoj Patwardhan [EMAIL PROTECTED] wrote: Hi Andy, Here's the result of my running otrs.checkmodules: CGI ... ok Date::Pcalc ... ok Date::Format ... ok DBI ... ok DBD::mysql ... not installed! (required - use perl - MCPAN - e shell;) Digest::MD5 ... ok Crypt::PasswdMD5 ... ok LWP::UserAgent ... ok IO::Scalar ... ok IO::Wrap ... ok MIME::Base64 ... ok MIME::Tools ... ok Mail::Internet ... ok Net::DNS ... ok Net::POP3 ... ok Net::LDAP ... ok Net::SMTP ... ok Authen::SASL ... ok GD ... ok GD::Text ... ok GD::Graph ... ok GD::Graph::lines ... ok GD::Text::Align ... ok XML::Parser ... ok PDF::API2 ... ok Compress::Zlib ... ok Note that I am using Postgres so I shouldn't really need DBD::mysql. Thanks, - Manoj On Nov 5, 2007, at 5:48 PM, Andy Lubel wrote: Wow, this is proving annoying to do.. Taking more effort than I expected, the perl installed is multi-threaded Can you paste your otrs.checkmodules? This is mine: CGI ... ok Date::Pcalc ... not installed! Date::Format ... not installed! DBI ... ok DBD::mysql ... not installed! Digest::MD5 ... ok Crypt::PasswdMD5 ... not installed! LWP::UserAgent ... ok IO::Scalar ... ok IO::Wrap ... ok MIME::Base64 ... ok MIME::Tools ... ok Mail::Internet ... ok Net::DNS ... version 0.60 is not useable with OTRS. Please use an older or an newer one. Net::POP3 ... ok Net::LDAP ... ok Net::SMTP ... ok Authen::SASL ... ok GD ... not installed! (for stats - not required) GD::Text ... not installed! (for stats - not required) GD::Graph ... not installed! (for stats - not required) GD::Graph::lines ... not installed! (for stats - not required) GD::Text::Align ... not installed! (for stats - not required) XML::Parser ... ok PDF::API2 ... not installed! (for PDF output - not required) Compress::Zlib ... ok UGH. Well good news is I have a support contract, where they say they support OS X. -Andy On 11/4/07 11:00 AM, Manoj Patwardhan [EMAIL PROTECTED] wrote: Thanks Andy! Your help is greatly appreciated. - Manoj Patwardhan On Nov 4, 2007, at 10:53 AM, Andy Lubel wrote: dude, leopard has been out for a week.. us experts havent had a chance to test yet, although it should work. major difference that i can think of being apache. ill be running through an install on my dev environment with leopard and will try to replicate your issue. only thing is i use mysql instead of postgress. -Andy Lubel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manoj Patwardhan Sent: Sunday, November 04, 2007 9:40 AM To: otrs@otrs.org Subject: [otrs] Creating a new user agent (Postgres, Mac OSX) I downloaded OTRS 2.2.3 to install on Mac OS 10.5 (Leopard) and want to use Postgres as the back end. I followed instructions and was able to eventually log in as [EMAIL PROTECTED] and create groups and roles. However, when I try to create a new user agent, nothing happens. I looked at the Apache (2.2) error log and the message I see is the following: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: darwin Time: Sun Nov 4 09:22:10 2007, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] Message: Need UserID!, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] Traceback (858): , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Output::HTML::PreferencesCustomQueue::Param
[otrs] Attachments are broken after downloads
Hi, I have an urgent issue. It's unable to download attachments bigger than 3 Mb. If I click on the attachment link ie show the download size as 3 Mb and downloads this as a 3 Mb instead of the original size. TicketZoom shows it's size correctly. Due to this problem I unable to access some important files. ArticleStorage backend is DB. DB is Oracle 10g. In article_attachments table show also the correct size in content_size column. Thanks a lot. Regards., Sandor -- Üdvözlettel/Kind Regards, Fehér Sándor ...Fehér Sándor...---Sandor Feher fejlesztési vezető --- development manager Blue System Kft. --- Blue System Ltd. mailto:[EMAIL PROTECTED] http://www.bluesystem.hu [ - real men don't click - ] ___ 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] Creating a new user agent (Postgres, Mac OSX)
Yeah, I'm still PPC here and its a little different than the intel perl I suspect. xservedev:~ root# perl --version This is perl, v5.8.8 built for darwin-thread-multi-2level What's yours say? Same: This is perl, v5.8.8 built for darwin-thread-multi-2level - Manoj On 11/6/07 10:18 AM, Manoj Patwardhan [EMAIL PROTECTED] wrote: Can you give me any insight into how you installed the needed modules or did you upgrade your OSX to a later version without erasing the disk? It was a clean install of Leopard (after erasing the disk). To install the modules I used the CPAN shell running as root. It just worked first shot. Im having a hell of a time just installing Date::Pcalc.. What architecture are you on, PPC or Intel? Intel. - Manoj On 11/6/07 8:52 AM, Manoj Patwardhan [EMAIL PROTECTED] wrote: Hi Andy, Here's the result of my running otrs.checkmodules: CGI ... ok Date::Pcalc ... ok Date::Format ... ok DBI ... ok DBD::mysql ... not installed! (required - use perl - MCPAN - e shell;) Digest::MD5 ... ok Crypt::PasswdMD5 ... ok LWP::UserAgent ... ok IO::Scalar ... ok IO::Wrap ... ok MIME::Base64 ... ok MIME::Tools ... ok Mail::Internet ... ok Net::DNS ... ok Net::POP3 ... ok Net::LDAP ... ok Net::SMTP ... ok Authen::SASL ... ok GD ... ok GD::Text ... ok GD::Graph ... ok GD::Graph::lines ... ok GD::Text::Align ... ok XML::Parser ... ok PDF::API2 ... ok Compress::Zlib ... ok Note that I am using Postgres so I shouldn't really need DBD::mysql. Thanks, - Manoj On Nov 5, 2007, at 5:48 PM, Andy Lubel wrote: Wow, this is proving annoying to do.. Taking more effort than I expected, the perl installed is multi-threaded Can you paste your otrs.checkmodules? This is mine: CGI ... ok Date::Pcalc ... not installed! Date::Format ... not installed! DBI ... ok DBD::mysql ... not installed! Digest::MD5 ... ok Crypt::PasswdMD5 ... not installed! LWP::UserAgent ... ok IO::Scalar ... ok IO::Wrap ... ok MIME::Base64 ... ok MIME::Tools ... ok Mail::Internet ... ok Net::DNS ... version 0.60 is not useable with OTRS. Please use an older or an newer one. Net::POP3 ... ok Net::LDAP ... ok Net::SMTP ... ok Authen::SASL ... ok GD ... not installed! (for stats - not required) GD::Text ... not installed! (for stats - not required) GD::Graph ... not installed! (for stats - not required) GD::Graph::lines ... not installed! (for stats - not required) GD::Text::Align ... not installed! (for stats - not required) XML::Parser ... ok PDF::API2 ... not installed! (for PDF output - not required) Compress::Zlib ... ok UGH. Well good news is I have a support contract, where they say they support OS X. -Andy On 11/4/07 11:00 AM, Manoj Patwardhan [EMAIL PROTECTED] wrote: Thanks Andy! Your help is greatly appreciated. - Manoj Patwardhan On Nov 4, 2007, at 10:53 AM, Andy Lubel wrote: dude, leopard has been out for a week.. us experts havent had a chance to test yet, although it should work. major difference that i can think of being apache. ill be running through an install on my dev environment with leopard and will try to replicate your issue. only thing is i use mysql instead of postgress. -Andy Lubel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manoj Patwardhan Sent: Sunday, November 04, 2007 9:40 AM To: otrs@otrs.org Subject: [otrs] Creating a new user agent (Postgres, Mac OSX) I downloaded OTRS 2.2.3 to install on Mac OS 10.5 (Leopard) and want to use Postgres as the back end. I followed instructions and was able to eventually log in as [EMAIL PROTECTED] and create groups and roles. However, when I try to create a new user agent, nothing happens. I looked at the Apache (2.2) error log and the message I see is the following: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: darwin Time: Sun Nov 4 09:22:10 2007, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] Message: Need UserID!, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1] Traceback (858): , referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client 127.0.0.1]Module: Kernel::Output::HTML::PreferencesCustomQueue::Param (v1.7) Line: 49, referer: http://expsupport/otrs/index.pl?Action=AdminUser [Sun Nov 04 09:22:10 2007] [error] [client
[otrs] Proposal of how to setup OTRS on Ubuntu 7.04 server
It was piece of cake to setup the LAMP-server and install OTRS with apt-get but I'am unsure how to setup a secure mailserver. I own a domain that I want to dedicate for this. I could use the domain with google apps to setup a mailaccount but google only let me only connect by POP3+SSL and SMTP+TLS. I found an module for OTRS to connect to POP3+SSL but I guess it wasn't configed for ubuntu because I can't get it working. I installed Postfix after an HOWTO-guide and I think it works but I'am unsure how secure it is. I don't want do be abused to send SPAM. So I would like some links or help how I should solve my problem. I'am not totaly a newbi to linux but I'am unsure when it comes to setup an secure mailsystem. ___ 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] Upgrade OTRS v. 2.0.4 to v. 2.2.3
Hi All, I tried the upgrade this weekend on a test server. I'm getting this error message: Panic! No UserData!!!... I followed the instructions below. Any thoughts? Thanks for your help... On 10/18/07, Franz Ferdinand Esberger [EMAIL PROTECTED] wrote: Ivan De Masi schrieb am 17.10.2007 17:12 Uhr: Hello, we have a bit older installation of OTRS (v. 2.0.4 from the sources) and want to upgrade to v. 2.2.3. Can this be realized in one step or do I have to install some versions beetween (e.g. 2.1. an than 2.2. etc.) Has anyone expierence in such a major upgrade, especially with possible problems with the database (mysql) etc. I have found this post in this month with very helpful hints: http://lists.otrs.org/pipermail/otrs/2007-October/020536.html Is there somebody having also any other experience - any feedback is welcome! We run OTRS since the 1.3.x Series, upgraded to 2.0.4 and now to 2.2.1 recently. We are running with the same DB holding the Tickets ever since and are happy with this. The only thing you have to asure is to execute EVERY DB Upgrade Skript since your actual Version: .) backup everything eg.: cp -r /opt/otrs/Kernel/ destination /usr/bin/mysqldump -A -u otrs -p destination/backup.sql cat crontab -u otrs -e destination .) make sure you backuped everything .) update source to 2.2.x (our your desired Version) .) execute upgrade skript your.db to 2.x .) execute upgrade skript your.db to 2.1 .) execute upgrade skript your.db to 2.2 Worked like a charm for me. hth ___ 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: [otrs] Upgrade OTRS v. 2.0.4 to v. 2.2.3
I¹m guessing you are using LDAP? If not just disregard.. Most notably is in the old otrs it(the Config.pm) was: # UserSyncLDAPMap # (map if agent should create/synced from LDAP to DB after login) $Self-{UserSyncLDAPMap} = { # DB - LDAP Firstname = 'givenName', Lastname = 'sn', Email = 'mail', }; -- If so make sure that it looks like this now: # UserSyncLDAPMap # (map if agent should create/synced from LDAP to DB after login) $Self-{UserSyncLDAPMap} = { # DB - LDAP UserFirstname = 'givenName', UserLastname = 'sn', UserEmail = 'mail', }; That got me for about 45 minutes until I looked into the OTRS logs and saw the error it was logging. -Andy On 11/6/07 2:19 PM, touraman traore [EMAIL PROTECTED] wrote: Hi All, I tried the upgrade this weekend on a test server. I'm getting this error message: Panic! No UserData!!!... I followed the instructions below. Any thoughts? Thanks for your help... On 10/18/07, Franz Ferdinand Esberger [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Ivan De Masi schrieb am 17.10.2007 17:12 Uhr: Hello, we have a bit older installation of OTRS (v. 2.0.4 from the sources) and want to upgrade to v. 2.2.3. Can this be realized in one step or do I have to install some versions beetween (e.g. 2.1. an than 2.2. etc.) Has anyone expierence in such a major upgrade, especially with possible problems with the database (mysql) etc. I have found this post in this month with very helpful hints: http://lists.otrs.org/pipermail/otrs/2007-October/020536.html Is there somebody having also any other experience - any feedback is welcome! We run OTRS since the 1.3.x Series, upgraded to 2.0.4 and now to 2.2.1 recently. We are running with the same DB holding the Tickets ever since and are happy with this. The only thing you have to asure is to execute EVERY DB Upgrade Skript since your actual Version: .) backup everything eg.: cp -r /opt/otrs/Kernel/ destination /usr/bin/mysqldump -A -u otrs -p destination/backup.sql cat crontab -u otrs -e destination .) make sure you backuped everything .) update source to 2.2.x (our your desired Version) .) execute upgrade skript your.db to 2.x .) execute upgrade skript your.db to 2.1 .) execute upgrade skript your.db to 2.2 Worked like a charm for me. hth ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs 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/ 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: [otrs] Upgrade OTRS v. 2.0.4 to v. 2.2.3
Thanks for the reply. I'm not using LDAP at all. All the post I've read on this so far are mentioning LDAP, but no I'm not using LDAP. When I lookup into mysql database, I can see all my users in system_user table in my otrs database, but at the login screen it's throwing Panic! No UserData!!!. I took a look at my system log as well, I'm only getting the same error in there. Thanks for helping On 11/6/07, Andy Lubel [EMAIL PROTECTED] wrote: I'm guessing you are using LDAP? If not just disregard.. Most notably is in the old otrs it(the Config.pm) was: # UserSyncLDAPMap # (map if agent should create/synced from LDAP to DB after login) $Self-{UserSyncLDAPMap} = { # DB - LDAP Firstname = 'givenName', Lastname = 'sn', Email = 'mail', }; -- If so make sure that it looks like this now: # UserSyncLDAPMap # (map if agent should create/synced from LDAP to DB after login) $Self-{UserSyncLDAPMap} = { # DB - LDAP UserFirstname = 'givenName', UserLastname = 'sn', UserEmail = 'mail', }; That got me for about 45 minutes until I looked into the OTRS logs and saw the error it was logging. -Andy On 11/6/07 2:19 PM, touraman traore [EMAIL PROTECTED] wrote: Hi All, I tried the upgrade this weekend on a test server. I'm getting this error message: Panic! No UserData!!!... I followed the instructions below. Any thoughts? Thanks for your help... On 10/18/07, *Franz Ferdinand Esberger* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Ivan De Masi schrieb am 17.10.2007 17:12 Uhr: Hello, we have a bit older installation of OTRS (v. 2.0.4 from the sources) and want to upgrade to v. 2.2.3. Can this be realized in one step or do I have to install some versions beetween (e.g. 2.1. an than 2.2. etc.) Has anyone expierence in such a major upgrade, especially with possible problems with the database (mysql) etc. I have found this post in this month with very helpful hints: http://lists.otrs.org/pipermail/otrs/2007-October/020536.html Is there somebody having also any other experience - any feedback is welcome! We run OTRS since the 1.3.x Series, upgraded to 2.0.4 and now to 2.2.1 recently. We are running with the same DB holding the Tickets ever since and are happy with this. The only thing you have to asure is to execute EVERY DB Upgrade Skript since your actual Version: .) backup everything eg.: cp -r /opt/otrs/Kernel/ destination /usr/bin/mysqldump -A -u otrs -p destination/backup.sql cat crontab -u otrs -e destination .) make sure you backuped everything .) update source to 2.2.x (our your desired Version) .) execute upgrade skript your.db to 2.x .) execute upgrade skript your.db to 2.1 .) execute upgrade skript your.db to 2.2 Worked like a charm for me. hth ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs http://lists.otrs.org/pipermail/otrshttp://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/ http://www.otrs.com/ 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/
[otrs] OTRS Installation on Debian Etch
Working on an initial installation of OTRS on Debian Etch, Apache was working fine for other applications, but after the LDAP configuration, it stopped working. Now when trying to start apache, I get the following errors: [warn] Useless use of AllowOverride in line 22. failed! In the apache error log, it reports the following: [Tue Nov 06 15:34:49 2007] [error] syntax error at /usr/share/otrs//Kernel/Confi g.pm line 85, near 'AuthModule::LDAP::Host'}\nCompilation failed in require at /usr/share/otrs/scripts/apache2-perl-startup.pl line 27.\nBEGIN failed--compila tion aborted at /usr/share/otrs/scripts/apache2-perl-startup.pl line 27.\nCompil ation failed in require at (eval 2) line 1.\n I've checked and re-checked the line with the AuthModule::LDAP::Host, I don't see anything unusual here. I've read a few posts about ORTS not being Apache2 compliant and have made the recommended changes, but still no luck. Anyone else had the same issue and resolved it? Thanks in advance. ___ 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] Attachments are broken after downloads
Sándor Fehér írta: Hi, It did not let me sleep. I investigated the process. I put a little hack into the ArticleStorageDB.pm which provides me the size of the attachment read. It was correct. The second turn I put the whole encoded content into a temp file. It's size also looked me good. Then I run perl -w -MMIME::Base64 -ne 'print decode_base64($_)' oo.txt oo.pdf The result is then the decode process cut the output at 3 Mb however it's 3.5 Mb. It happened at the same size 3104874. It's a kind of magic number. I did not find any restrictions related to MIME::Base64. Of course I double checked the filesystem allocation as well. For a different approach I encoded a tgz (quite big, around 35 Mb) then decoded it again It was perfect. So I suspect there is something in the stored content which drives decode_base64 onto wrong way. Regards.,Sandor Hi, I have an urgent issue. It's unable to download attachments bigger than 3 Mb. If I click on the attachment link ie show the download size as 3 Mb and downloads this as a 3 Mb instead of the original size. TicketZoom shows it's size correctly. Due to this problem I unable to access some important files. ArticleStorage backend is DB. DB is Oracle 10g. In article_attachments table show also the correct size in content_size column. Thanks a lot. Regards., Sandor ___ 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] Attachments are broken after downloads
Hi Sandor Did you set up the maximal size of uploaded files? Sysconfig = Framework = Core::Web = WebMaxFileUpload Carlos, -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Sándor Fehér Enviado el: Martes, 06 de Noviembre de 2007 09:53 a.m. Para: User questions and discussions about OTRS.org Asunto: [otrs] Attachments are broken after downloads Hi, I have an urgent issue. It's unable to download attachments bigger than 3 Mb. If I click on the attachment link ie show the download size as 3 Mb and downloads this as a 3 Mb instead of the original size. TicketZoom shows it's size correctly. Due to this problem I unable to access some important files. ArticleStorage backend is DB. DB is Oracle 10g. In article_attachments table show also the correct size in content_size column. Thanks a lot. Regards., Sandor -- Üdvözlettel/Kind Regards, Fehér Sándor ...Fehér Sándor...---Sandor Feher fejlesztési vezető --- development manager Blue System Kft. --- Blue System Ltd. mailto:[EMAIL PROTECTED] http://www.bluesystem.hu [ - real men don't click - ] ___ 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] Installing on a shared hosted server
Hi, Is it possible to install OTRS on a shared hosted server where there is no access to the terminal(command line)? If so, are there any instructions on how to do it? Thanks Nishen ___ 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-de] OTRS-Modul zum Mail-Weiterleiten eines Tickets?
Liebe Kollegen, wir würden gern erreichen, dass Tickets beim verschieben in eine Queue automatisch als Mail an eine bestimmte Adresse weitergeleitet werden, und zwar am liebsten mit der kompletten Historie (eventuell ohne note-internal-Beiträge). Hat vielleicht jemand von euch schon mal so etwas geschrieben oder eine Idee zur Umsetzung? Viele Grüße Karsten -- Karsten Heymann [EMAIL PROTECTED] ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
[otrs-de] eingehende E-Mails an OTRS-Ticket anhaengen
Hallo zusammen, ich verwende OTRS unter anderem auch, um Projekte mit externen Dienstleistern zu verfolgen. Antwortet einer der Dienstleister auf ein Ticket, so kopiere ich dies bisher mühsam manuell in eine Notiz des entsprechenden Tickets. Das geht doch bestimmt auch einfacher, indem man die Mail an OTRS weiterleitet und diese dann mehr oder weniger automatisch Bestandteil der Tickethistorie wird. Habe dazu leider nichts im Netz gefunden. Hat jemand einen Tipp dazu? Vielen Dank! Grüsse, Klaus Stärk ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/