[otrs] Database Conversion from MySQL to PostgreSQL
Good day! I'm moving my otrs installation from MySQL to PostgreSQL. Almost everything went fine, except article_attachment table. Is there any available instructions on how to move that data? Thanks. -- [ ]'s Aledr - Alexandre - 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
Re: [otrs] Database Conversion from MySQL to PostgreSQL
Used mysqldump for data only; Added 'set backslash_quote = on;' and 'set standard_conforming_strings = off;' in the header of the dump file. After that you need to create the PostgreSQL schema from OTRS scripts, import your data, run OTRS post database script and adjust sequences (you can generate the queries for that with py-mysql2pgsql and some scripting). Solved the article_attachment with otrs.ArticleStorageSwitch.pl. Dropped files to filesystem, moved files to the new server and imported to database again. Thanks. On Thu, Mar 28, 2013 at 12:18 PM, Bogdan Iosif wrote: > Does OTRS have a tool that you used to move the data? > > > On Thu, Mar 28, 2013 at 5:12 PM, aledr wrote: >> >> Good day! >> >> I'm moving my otrs installation from MySQL to PostgreSQL. >> Almost everything went fine, except article_attachment table. >> >> Is there any available instructions on how to move that data? >> >> Thanks. >> -- >> [ ]'s >> Aledr - Alexandre >> - >> 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 > > > > - > 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 -- [ ]'s Aledr - Alexandre - 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
Re: [otrs] Database Conversion from MySQL to PostgreSQL
It seems faster, but we've made no performance tests at all. We moved fo the sake of simplicity (keeping just one RDBMS to maintain). On Thu, Mar 28, 2013 at 2:12 PM, Bogdan Iosif wrote: > An interesting and ingenious method. I was thinking you're using some ETL > tool. > > I'm strongly considering doing the same switch as you did but I'm wary of > performance issues. Initially, I tried running OTRS on top of SQL Server but > Perl's database interface implementation for this RDBMS is very weak (5x > slower) compared to MySQL. > > Did you run tests that showed PostgreSQL would be better performance-wise > or, if not, why did you move? > > > On Thu, Mar 28, 2013 at 6:55 PM, aledr wrote: >> >> Used mysqldump for data only; >> Added 'set backslash_quote = on;' and 'set standard_conforming_strings >> = off;' in the header of the dump file. >> After that you need to create the PostgreSQL schema from OTRS scripts, >> import your data, run OTRS post database script and adjust sequences >> (you can generate the queries for that with py-mysql2pgsql and some >> scripting). >> >> Solved the article_attachment with otrs.ArticleStorageSwitch.pl. >> Dropped files to filesystem, moved files to the new server and >> imported to database again. >> >> Thanks. >> >> On Thu, Mar 28, 2013 at 12:18 PM, Bogdan Iosif >> wrote: >> > Does OTRS have a tool that you used to move the data? >> > >> > >> > On Thu, Mar 28, 2013 at 5:12 PM, aledr >> > wrote: >> >> >> >> Good day! >> >> >> >> I'm moving my otrs installation from MySQL to PostgreSQL. >> >> Almost everything went fine, except article_attachment table. >> >> >> >> Is there any available instructions on how to move that data? >> >> >> >> Thanks. >> >> -- >> >> [ ]'s >> >> Aledr - Alexandre >> >> - >> >> 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 >> > >> > >> > >> > - >> > 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 >> -- >> [ ]'s >> Aledr - Alexandre >> - >> 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 > > > > - > 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 -- [ ]'s Aledr - Alexandre - 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
[otrs] Can't go after Login
Hi there! Suddenly I'm not able to go after login on index.pl, but customer.pl still works normally. No message on logs, no error, nothing... It just keeps "loading". How can I debug this? Thanks. -- [ ]'s Aledr - Alexandre - 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
Re: [otrs] Can't go after Login
Hi Carlos! It is 4.0.3 and I can reach https://cloud.otrs.com from it. I can open "index.pl?Action=Admin <http://index.pl/?Action=Admin>" but not " index.pl?Action=AgentDashboard <http://index.pl/?Action=AgentDashboard>" or "index.pl?Action=AgentTicketResponsibleView <http://index.pl/?Action=AgentTicketResponsibleView>" as example. Thanks. On Mon, Feb 23, 2015 at 9:55 PM, Carlos Rodríguez wrote: > Hi Aledr, > > If you are using OTRS 4, please make sure you can reach > https://cloud.otrs.com from your OTRS box. > > ((enjoy)) > > Carlos Rodríguez > > > > > On Feb 23, 2015, at 1:28 PM, aledr wrote: > > Hi there! > > Suddenly I'm not able to go after login on index.pl, but customer.pl > still works normally. > No message on logs, no error, nothing... It just keeps "loading". > > How can I debug this? > > Thanks. > -- > [ ]'s > Aledr - Alexandre > > - > 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 > > > > - > 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 > -- [ ]'s Aledr - Alexandre - 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
Re: [otrs] Can't go after Login
Seems that otrs.GenericAgent.pl have a problem too. It keeps running after showing: Job: 'send escalation notifications' - Use module (Kernel::System::GenericAgent::NotifyAgentGroupOfCustomQueue) for Ticket (...) Thanks. On Mon, Feb 23, 2015 at 10:09 PM, aledr wrote: > Hi Carlos! > > It is 4.0.3 and I can reach https://cloud.otrs.com from it. > I can open "index.pl?Action=Admin <http://index.pl/?Action=Admin>" but > not "index.pl?Action=AgentDashboard > <http://index.pl/?Action=AgentDashboard>" or " > index.pl?Action=AgentTicketResponsibleView > <http://index.pl/?Action=AgentTicketResponsibleView>" as example. > > Thanks. > > On Mon, Feb 23, 2015 at 9:55 PM, Carlos Rodríguez < > carlos.rodrig...@otrs.com> wrote: > >> Hi Aledr, >> >> If you are using OTRS 4, please make sure you can reach >> https://cloud.otrs.com from your OTRS box. >> >> ((enjoy)) >> >> Carlos Rodríguez >> >> >> >> >> On Feb 23, 2015, at 1:28 PM, aledr wrote: >> >> Hi there! >> >> Suddenly I'm not able to go after login on index.pl, but customer.pl >> still works normally. >> No message on logs, no error, nothing... It just keeps "loading". >> >> How can I debug this? >> >> Thanks. >> -- >> [ ]'s >> Aledr - Alexandre >> >> - >> 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 >> >> >> >> - >> 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 >> > > > > -- > [ ]'s > Aledr - Alexandre > > -- [ ]'s Aledr - Alexandre Gerente de T.I. - Equipe Exata T.I. 44 3029-6416 44 9116-3154 (TIM) www.exatati.com.br - 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
Re: [otrs] Can't go after Login
Hi! We just found that the problem is at Kernel/System/SLA.pm line 275. It stuck at this query on the database: "SELECT service_id FROM service_sla WHERE sla_id = $1 ORDER BY service_id ASC' I expected to see a value in place of "$1". Any hint from here? Thanks. On Tue, Feb 24, 2015 at 1:52 AM, aledr wrote: > Seems that otrs.GenericAgent.pl have a problem too. > It keeps running after showing: > > Job: 'send escalation notifications' > - Use module > (Kernel::System::GenericAgent::NotifyAgentGroupOfCustomQueue) for Ticket > (...) > > Thanks. > > On Mon, Feb 23, 2015 at 10:09 PM, aledr > wrote: > >> Hi Carlos! >> >> It is 4.0.3 and I can reach https://cloud.otrs.com from it. >> I can open "index.pl?Action=Admin <http://index.pl/?Action=Admin>" but >> not "index.pl?Action=AgentDashboard >> <http://index.pl/?Action=AgentDashboard>" or " >> index.pl?Action=AgentTicketResponsibleView >> <http://index.pl/?Action=AgentTicketResponsibleView>" as example. >> >> Thanks. >> >> On Mon, Feb 23, 2015 at 9:55 PM, Carlos Rodríguez < >> carlos.rodrig...@otrs.com> wrote: >> >>> Hi Aledr, >>> >>> If you are using OTRS 4, please make sure you can reach >>> https://cloud.otrs.com from your OTRS box. >>> >>> ((enjoy)) >>> >>> Carlos Rodríguez >>> >>> >>> >>> >>> On Feb 23, 2015, at 1:28 PM, aledr wrote: >>> >>> Hi there! >>> >>> Suddenly I'm not able to go after login on index.pl, but customer.pl >>> still works normally. >>> No message on logs, no error, nothing... It just keeps "loading". >>> >>> How can I debug this? >>> >>> Thanks. >>> -- >>> [ ]'s >>> Aledr - Alexandre >>> >>> - >>> 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 >>> >>> >>> >>> - >>> 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 >>> >> >> >> >> -- >> [ ]'s >> Aledr - Alexandre >> >> > > > -- > [ ]'s > Aledr - Alexandre > - 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
Re: [otrs] Can't go after Login
Just to point that It seemed to be a rare condition caused by the daylight saving change. Last sunday clock went backward one hour and after that SLA.pm was never finishing to process the tickets. Here is what we have done to solve this: 1 - Change all "open" tickets to "new": UPDATE ticket SET ticket_state_id = 1 WHERE ticket_state_id = 4 2 - Reset times on them: UPDATE ticket SET escalation_time = 0, escalation_update_time = 0, escalation_solution_time = 0, escalation_response_time = 0, timeout = 0 WHERE ticket_state_id = 1 3 - Unlock. UPDATE ticket SET ticket_lock_id = 1 WHERE ticket_state_id = 1 AND ticket_lock_id = 2 Problem solved and OTRS updated to 4.0.6. (If some developer wants do debug it I can send a backup with this behaviour.) Thanks. On Tue, Feb 24, 2015 at 5:11 PM, aledr wrote: > Hi! > > We just found that the problem is at Kernel/System/SLA.pm line 275. > It stuck at this query on the database: > > "SELECT service_id FROM service_sla WHERE sla_id = $1 ORDER BY service_id > ASC' > > I expected to see a value in place of "$1". > Any hint from here? > > Thanks. > > On Tue, Feb 24, 2015 at 1:52 AM, aledr > wrote: > >> Seems that otrs.GenericAgent.pl have a problem too. >> It keeps running after showing: >> >> Job: 'send escalation notifications' >> - Use module >> (Kernel::System::GenericAgent::NotifyAgentGroupOfCustomQueue) for Ticket >> (...) >> >> Thanks. >> >> On Mon, Feb 23, 2015 at 10:09 PM, aledr >> wrote: >> >>> Hi Carlos! >>> >>> It is 4.0.3 and I can reach https://cloud.otrs.com from it. >>> I can open "index.pl?Action=Admin <http://index.pl/?Action=Admin>" but >>> not "index.pl?Action=AgentDashboard >>> <http://index.pl/?Action=AgentDashboard>" or " >>> index.pl?Action=AgentTicketResponsibleView >>> <http://index.pl/?Action=AgentTicketResponsibleView>" as example. >>> >>> Thanks. >>> >>> On Mon, Feb 23, 2015 at 9:55 PM, Carlos Rodríguez < >>> carlos.rodrig...@otrs.com> wrote: >>> >>>> Hi Aledr, >>>> >>>> If you are using OTRS 4, please make sure you can reach >>>> https://cloud.otrs.com from your OTRS box. >>>> >>>> ((enjoy)) >>>> >>>> Carlos Rodríguez >>>> >>>> >>>> >>>> >>>> On Feb 23, 2015, at 1:28 PM, aledr wrote: >>>> >>>> Hi there! >>>> >>>> Suddenly I'm not able to go after login on index.pl, but customer.pl >>>> still works normally. >>>> No message on logs, no error, nothing... It just keeps "loading". >>>> >>>> How can I debug this? >>>> >>>> Thanks. >>>> -- >>>> [ ]'s >>>> Aledr - Alexandre >>>> >>>> -- [ ]'s Aledr - Alexandre - 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
Re: [otrs] Error Since doing 4.x to 5.01 Upgrade
I see the same messages on logs and e-mail task is getting locked.
Looking for if it is related to the mail task.
On Tue, Nov 3, 2015 at 8:13 PM, Vander Ploeg, Daniel B
wrote:
> Since upgrading to 5.0.1 (and now 5.0.2), I've been seeing the following
> error in the system log:
>
> OTRS-otrs.Daemon.pl - Daemon
> Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-10
> Data->{Params} format is invalid
>
> It happens every 10 minutes. Can anyone point me in the right direction
> to track this down?
>
> Thanks,
>
> Dan
> -
> 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
>
--
[ ]'s
Aledr - Alexandre
-
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
[otrs] MailAccountFetch Stuck
Hi! On OTRS 5.0.X (running 5.0.3) MailAccountFetch is getting locked after a while. Looking at the Daemon summary we see it running for minutes or hours without fetching new messages and not closing connection to our mail server (netstat shows an open connection). --- sudo -u wwwrun /srv/otrs/bin/otrs.Console.pl <http://otrs.console.pl/> Maint::Daemon::Summary Handled Worker Tasks: NAME TYPE NID PID DURATION MailAccountFetch Cron 001 00014971 9.8 Minute(s) netstat -apn | grep XXX.XXX.XXX.XXX tcp0 0 192.168.100.4:58715 XXX.XXX.XXX.XXX:993 ESTABLISHED 16218/perl --- And also, after stoping Daemon one process still running. sudo -u wwwrun /srv/otrs/bin/otrs.Daemon.pl stop otrs.Daemon.pl - the otrs daemon Copyright (C) 2001-2015 OTRS AG, http://otrs.com/ Daemon stopped ps aux | grep otrs wwwrun 16218 0.0 1.2 151564 52436 ?SNov19 0:00 /usr/bin/perl -X /srv/otrs/bin/otrs.Daemon.pl start Thanks. -- [ ]'s Aledr - Alexandre - 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
