You can query this:
mysql -u *otrs* -p*hot*
*
*
mysql> use *otrs*;
mysql> select count(id) from ticket;
+-+
| count(id) |
+-+
| 18 |
+-+
1 row in set (0.00 sec)
--! *Dilson Tomé Rainov *
On Tue, Sep 25, 2012 at 6:00 PM, Andrew
Behalf Of Dilson
Tomé
Sent: Tuesday, September 25, 2012 10:53 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Mysql Help
Andrew.
I removed 45k ticket with Generic Agent.
You can create a Generic Agent for this tickets and run on Command Line on
linux ;-)
su - otrs -c '
>
> ** **
>
> *From:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *On Behalf
> Of *Muhammad El-Sergani
> *Sent:* Tuesday, September 25, 2012 10:36 AM
> *To:* User questions and discussions about OTRS.
> *Subject:* Re: [otrs] Mysql Help
>
> ** **
>
> I
:47 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Mysql Help
Actually it migth take you about 1 hour or more.
Be Patient.
Regards
On Tue, Sep 25, 2012 at 9:45 AM, Andrew Meyer
mailto:ame...@precisionpractice.com>> wrote:
Not working... I guess it might take some t
M
> *To:* User questions and discussions about OTRS.
> *Subject:* Re: [otrs] Mysql Help
>
> ** **
>
> I vote for Generic Agent as well.
> Works very good.
>
>
> ** **
>
> Thanks
>
> //M
>
>
>
>
>
> On Tue, Sep 25,
Muhammad El-Sergani
Sent: Tuesday, September 25, 2012 10:36 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Mysql Help
I vote for Generic Agent as well.
Works very good.
Thanks
//M
On Tue, Sep 25, 2012 at 4:57 PM, Alvaro Cordero
mailto:alv...@gridshield.net>> wrote:
Hello
I vote for Generic Agent as well.
Works very good.
Thanks
//M
On Tue, Sep 25, 2012 at 4:57 PM, Alvaro Cordero wrote:
> Hello Andrew,
>
> I believe it is better to do it through the Generic Agent Interface, since
> there are more than one database table involved into ticket information.
> You c
Hello Andrew,
I believe it is better to do it through the Generic Agent Interface, since
there are more than one database table involved into ticket information.
You could run a delete from ticket command, but it will still keep data
into ticket history, article and other tables.
Best Regards.
Hello Andrew,
The Generic Agent is your friend on those cases
http://doc.otrs.org/3.1/en/html/adminarea-genericagent.html
Leonardo Certuche
Medellín, Colombia
On 25 September 2012 09:52, Andrew Meyer wrote:
> I need to close about 25,000 tickets all with the same email address. I
> was hopin
I need to close about 25,000 tickets all with the same email address. I was
hoping to do this within the MySQL Workbench or at the command line.
Can anyone assist me in executing this command?
Thanks,
Andrew Meyer
Unix Systems Administrator
Precision Practice Management
The business behind the
Hi there!
I have migrated our otrs installation to an ubuntu 12.04 lts server
(formerly 8.04).
The Support overview states "everything is fine" - is made a view
commandline
benchmark tests of the mysql 5.5 server ... all stated a very good
performance,
the Otrs itself "feels" very fast
BUT
I am trying to set up a new OTRS 3.0.3 schema in MySQL (to receive 3.0.3
data from MSSQL before I upgrade the server to 3.1). The relevant(?)
my.ini excerpts are below:
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLE
Hello,
On 05.04.11 12:44, André Bauer wrote:
> If you´re using OTRS 2.4.x you could use the community extension
> "MySQL Booster".
>
> You can find it here: http://forums.otrs.org/viewtopic.php?f=21&t=8062
>
> It will speed up OTRS MySQL Performance a lot when y
Guten Tag Matus UHLAR - fantomas,
If you´re using OTRS 2.4.x you could use the community extension
"MySQL Booster".
You can find it here: http://forums.otrs.org/viewtopic.php?f=21&t=8062
It will speed up OTRS MySQL Performance a lot when you´re also using a customer
DB.
Ch
Hello,
we have a few years of tickets stored in MySQL database, in MyISAM tables.
Last few weeks the OTRS is becoming slow. I feel it could be caused by
using MyISAM tables since locking is working at table level, while with
InnoDB it's done at row level.
OTOH, the InnoDB tables do not support f
http://lmgtfy.com/?q=Host+mypc.domain.local+is+not+allowed+to+connect+to+this+MySQL+server
:D (btw I think that should be an issue for mysql forum, doesn't it ?)
On Fri, Mar 4, 2011 at 5:11 PM, Boniforti Flavio wrote:
> Hello all.
>
> I've installed OTRS 3 on a Windows 2003 Server and now I'd l
Hello all.
I've installed OTRS 3 on a Windows 2003 Server and now I'd like to
access it's database from my PC in LAN.
Using mySQL Workbench, I only get error connecting to it. I get "Host
mypc.domain.local is not allowed to connect to this MySQL server".
So, how do I have to proceed to enable it
This is becoz the application module lost the connection with database.
Regards
Sourabh Sarwate
On Tue, Feb 2, 2010 at 11:20 AM, Ivo Veseli wrote:
> Hi,
>
>
>
> I got an error message in OTRS admin area system log:
>
>
>
> MySQL server has gone away, SQL: 'SELECT tn FROM ticket WHERE id = ? LIM
Hi,
I got an error message in OTRS admin area system log:
MySQL server has gone away, SQL: 'SELECT tn FROM ticket WHERE id = ? LIMIT
1'
Does anyone know the cause this error and how to fix it?
Thanks,
Ivo Veseli
---
Hi Rodrigo,
I had the same problem and I used this script in bash :
###
#!/bin/bash
echo Script to convert MySQL latin1 charsets to utf8.
echo Usage: $0 dbname
echo Dumping out $1 database
mysqldump -u root -p --add-drop-table $1 > db.sql
mydate=`date +%y%m%d`
Hi,
I have the need to convert the collation of a database in Mysql (14Gb).
My database is using collation latin1 (ISO-8859-1), I need to convert it to
UTF-8.
I found the forum two ways of doing this, (FAQ: 4200202 and 4200315). The
message recommends FAQ 4200202 perform the procedure usin
Thank u for info MichielBeijen..
Ravi Shankar
From: Michiel Beijen
To: User questions and discussions about OTRS.
Sent: Wednesday, May 20, 2009 11:38:57 PM
Subject: Re: [otrs] configuring POP3 mail account to otrs(mysql).
Dear mr shanker,
First of all
uring POP3 mail account to otrs(mysql).
have configured pop3 account with hostname,pwd ..etc in admin area of user
interface.
after that when i create phone ticket,email ticket from my account i'm not
recieving mail notifications for cases created.
i dont have perl installed in system.is any
Hi all,
Help me with configuring POP3 mail account to otrs(mysql).
have configured pop3 account with hostname,pwd ..etc in admin area of user
interface.
after that when i create phone ticket,email ticket from my account i'm not
recieving mail notifications for cases created.
i dont have
Hello,
since we've done the update from 2.0.4 to 2.3.1 (spent some days testing 2.2.7
before applying the patches for 2.3.1), we're have massive problems with the
number of database-connections. Our MySQL database (5.0.51) runs on a different
server, with the customer user data stored in a sepa
Hi all,
While searching tickets from search module of otrs, it takes hell lotta time to
give results...finally ending up with
"Internal Server error".
Pullin the SQL script that lists distinct tickets, from code, and running it
directly in MYSQL client also takes hell lot of
time,
Hi all,
While searching tickets from search module of otrs, it takes hell lotta time to
give results...finally ending up with
"Internal Server error".
Pullin the SQL script that lists distinct tickets, from code, and running it
directly in MYSQL client also takes hell lot of
ti
Hi,
Snehal Desai schrieb:
Hello,
I am trying to extract data from mysql database using mysql tools. I
am a newbie(new college-grad), so I can't seem to find the data in the
inventory(config item) that I have loaded. I have tried a sql dump,
but the .sql file is not readable. Do you know unde
Hello,
I am trying to extract data from mysql database using mysql tools. I am a
newbie(new college-grad), so I can't seem to find the data in the
inventory(config item) that I have loaded. I have tried a sql dump, but the
.sql file is not readable. Do you know under what schema/table this is u
Buice, David R wrote:
I need to migrate our existing OTRS database (version 1.2.3!) which
currently resides on a Linux box onto a Solaris server which has
OTRS 2.2.4 installed.
I was thinking that perhaps I would do a backup on the Linux server
and then a restore on the Solaris server...
Hello,
I need to migrate our existing OTRS database (version 1.2.3!) which
currently resides on a Linux box onto a Solaris server which has OTRS
2.2.4 installed.
I was thinking that perhaps I would do a backup on the Linux server and
then a restore on the Solaris server... But I thought I shou
Hi.
Is there some kind of script, to migrate from Mysql to PostgreSQL?
--
Best regards ,
Andrey Feldman
http://alt-lan.ru
+7(495)96-100-96
___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscr
007 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 :
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
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 co
now what is the faster of these dabase servers for OTRS:
>> MySQL or PostgreSQL.
>>
>
> ...you may produce some flame war with this question ;-). Anyway, due to
> the many parameters, it's not possible to answer this question reliably.
> If data integrity is
if you're junior on db management.. MySQL is the one...
Adriano Amaral
NetAdmin
Torsten Thau a écrit:
> Rodriguez Garcia, Jose Luis schrieb:
> > I am doing the installation of a otrs server on a Solaris box, and I
> > will like to know what is the faster of these dabase
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rodriguez Garcia, Jose Luis schrieb:
>
> I am doing the installation of a otrs server on a Solaris box, and I
> will like to know what is the faster of these dabase servers for OTRS:
> MySQL or PostgreSQL.
>
...you may produce some
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Lubel
Sent: Wednesday, September 19, 2007 1:25 PM
To: User questions and discussions about OTRS.org
Subject: Re: [otrs] What is more faster for otrs: MySQL or PostgreSQL
Mysql hands down.
On 9/19/07 3
a otrs server on a Solaris box, and I
will like to know what is the faster of these dabase servers for OTRS:
MySQL or PostgreSQL.
Jose Luis Rodriguez
___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otr
lation of a otrs server on a Solaris box, and I
will like to know what is the faster of these dabase servers for OTRS:
MySQL or PostgreSQL.
Jose Luis Rodriguez
___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pip
, September 19, 2007 1:25 PM
To: User questions and discussions about OTRS.org
Subject: Re: [otrs] What is more faster for otrs: MySQL or PostgreSQL
Mysql hands down.
On 9/19/07 3:33 PM, "Rodriguez Garcia, Jose Luis"
<[EMAIL PROTECTED]> wrote:
>
> I am doing the installation
Mysql hands down.
On 9/19/07 3:33 PM, "Rodriguez Garcia, Jose Luis"
<[EMAIL PROTECTED]> wrote:
>
> I am doing the installation of a otrs server on a Solaris box, and I
> will like to know what is the faster of these dabase servers for OTRS:
> MySQL or PostgreSQL.
I am doing the installation of a otrs server on a Solaris box, and I
will like to know what is the faster of these dabase servers for OTRS:
MySQL or PostgreSQL.
Jose Luis Rodriguez
___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive
Jeff,
As I mentioned in my last email, 59 tables *by default*, so just after a
fresh installation of OTRS v2.2.2 without any packages.
My current pre-production OTRS is using 79 tables and some add-on
packages are installed : Survey / FAQ / Webmail ...) :
mysql> show tables;
+---
Hi Laurent,
59 tables? Are you sure? I'm showing 77 in my database. Are there
ones created depending on features/setup options? Such as the
additional items you can install?
-Jeff
Laurent Minost wrote:
Hi,
Hard to say, it depends on your OTRS version I think and also
additional package
Hi,
Hard to say, it depends on your OTRS version I think and also additional
packages installed.
It seems that with OTRS v2.2.2, 59 tables by default.
BR,
Laurent Minost
Le jeudi 30 août 2007 à 07:33 -0700, Jeff Shepherd a écrit :
> Hello,
> I was wondering how many tables OTRS v2.2.2 should
Jeff Shepherd wrote:
I was wondering how many tables OTRS v2.2.2 should have for the
MySQL database. I'm having a few MySQL problems and I just want to
make sure that I'm not missing any tables.
I guess any errors would show missing tables. The full database
schema is available on the FT
Hello,
I was wondering how many tables OTRS v2.2.2 should have for the MySQL
database. I'm having a few MySQL problems and I just want to make sure
that I'm not missing any tables.
Thanks!
-Jeff
___
OTRS mailing list: otrs - Webpage: http://otrs.o
Martin Rodriguez wrote:
Is any way to solve this?
http://dev.mysql.com/doc/refman/4.1/en/repair.html
Nils Breunese.
PGP.sig
Description: Dit deel van het bericht is digitaal ondertekend
___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archi
Hi. Can anyone explain to me the following message?. How can this affect my
system?. Is any way to solve this?. Thanks in advance.
otrs2.article
warning : 1 client is using or hasn't closed the table properly
otrs2.article_plain
warning : 1 client is using or hasn't closed the table properly
ot
Hello there,
I am having an issue with attaching some files to some ticket. In my
last example, the file is 3.5 MB. When we restore the production db to
our development server , I can attach the doc without a problem( Both
servers are suppose to be identical, obviously, they are not..).
Following
hello,
Is there a recommanded MySQL version for OTRS 2.1.1 ? I have problems with
articles stored in database that contains french accents. I am using MySQL
4.1.21 with latin1_general_ci collation.
Regards.
Eric Boudrand
___
OTRS mailing list: otrs -
Danie wrote:
I actually did a migration from one server to another just this
morning , and it was amazingly simple :)
In Windows , stop your mysql database (so no writing possible to
it) , then simply copy the *.MYI files from your win32 system to
your Suse system ( thinks it's in /var/li
Hi Jared ,
I actually did a migration from one server to another just this morning
, and it was amazingly simple :)
In Windows , stop your mysql database (so no writing possible to it) ,
then simply copy the *.MYI files from your win32 system to your Suse
system ( thinks it's in /var/lib/mys
thanks very helpful
>>> [EMAIL PROTECTED] 07/18/06 1:03 PM >>>
Jared Cebada wrote:
> What is the best way to move the database, I am new to MySQL??
Go to http://www.mysql.com/ and search for the mysqldump and
mysqlrestore commands.
> I see that there is a backup.pl but I belive I can't execut
Jared Cebada wrote:
What is the best way to move the database, I am new to MySQL??
Go to http://www.mysql.com/ and search for the mysqldump and
mysqlrestore commands.
I see that there is a backup.pl but I belive I can't execute that
without a
native linux kernel?? Would cygwin be of any
What is the best way to move the database, I am new to MySQL?? I see
that there is a backup.pl but I belive I can't execute that without a
native linux kernel?? Would cygwin be of any use??
___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive:
Morning/Afternoon,
I had a few issue with crashed tables last week and haven't been able to
resolve these.
Since last week I have repaired all associated database tables (ALL tables),
with "mysql repair table ..."
and via myisamchk. Either repair function returns an all clean yet the
GenericAge
Obviously your MySQL table is crashed (error: 145). You should repair it...
http://dev.mysql.com/doc/refman/5.0/en/repair-table.html
Buchner, Daniel wrote:
Weirdest thing ever.
I am able to perform all operations except the ones which require the
genericAgent.pl when i had a closer look I got
Weirdest thing ever.
I am able to perform all operations except the ones which require the
genericAgent.pl when i had a closer look I got the below.
Question is - has anyone else come across this? I have not made any changes,
nor has anyone else. Don't really know who or
what would have removed t
Hi!
Solaris User wrote:
Marco Geweke,
I tried your method, but it did not work. For one thing, there is no
crypt() function in MySQL. I tried encrypt, and decrypt, but it did not
work.
You asked for a way to encrypt the password in PHP the same way otrs
does in Perl, and that's the way:
Oops and in
/opt/otrs/Kernel/System/Auth/DB.pm
this uses a crypt function from mod_perl
Original Message
Subject: Re: [otrs] MySQL 4.0 with OTRS v2 on Windows 2003
From:[EMAIL PROTECTED]
Date:Thu, February 9, 2006 7:03 pm
To
The routine that does this encryption is in
/opt/otrs/bin/CryptPassword.pl
Solaris User said:
> What type of hash does OTRS v2 use when storing a password in MySQL? It
> looks like crypt, but I am unable to tell what the salt is.
>
> Essentially, my problem is that I want to interface wit
FranzF,
You have misunderstood the question. This has nothing to do with the MySQL
user, but the user that is stored in MySQL *THROUGH* OTRS. Hence why this
forum is the best shot I have of getting the correct information. Running
the server with --old-password is not relevant. My question
Again this should have been asked in a mySQL List, however:
Why not do the Job with mySQL directly ?
SELECT count(*) FROM system_user WHERE pass=password("yourplaintextpass");
Started your Server with --old-passwords ? No problem, just use
"pass=old_password()" instead.
hth
FranzF
Solaris User
Hi!
Solaris User wrote:
What type of hash does OTRS v2 use when storing a password in MySQL? It
looks like crypt, but I am unable to tell what the salt is.
Try it this way:
$password = crypt($cleartextpassword, $username);
The username is the salt.
Greetings
Marco
__
Hi,
Solaris User schrieb:
What type of hash does OTRS v2 use when storing a password in MySQL? It
looks like crypt, but I am unable to tell what the salt is.
Essentially, my problem is that I want to interface with the 'pw' field
in the system_user table using a PHP page I made. I am curren
What type of hash does OTRS v2 use when storing a password in MySQL? It
looks like crypt, but I am unable to tell what the salt is.
Essentially, my problem is that I want to interface with the 'pw' field in
the system_user table using a PHP page I made. I am currently unable to do
this becau
Hello,
although this is a question which would be better placed in a mySQL
beginners list:
are you familiar with, and have you checked the user rights for your
database ?
Seems to me that the the user you're connecting with is allowed to
connect locally but not from remote.
Some GRANT's will hel
Hello,
I've installed OTRS
local on my pc and on a server (Windows 2003 server). How can I connect to
the MYSQL database on the server with MySqlmanager? Connecting to the locally
MySQL database (on the pc) is no problem, but I cann't connect to the
server...
Hopefully anybody
can help
Or perhaps did you accidentally missed the -h parameter to specify the
proper db-host.
you could have tried to dump the file to your backup-db-host instead of
using the new host.
Mike Lykov schrieb:
В сообщении от Четверг 02 Февраль 2006 20:32 Alina Florea написал(a):
Hi Alina,
I use the co
В сообщении от Четверг 02 Февраль 2006 20:32 Alina Florea написал(a):
Hi Alina,
> I use the command:
> mysql -u root otrs < mysql.sql
> I have the error message: error 1050: Table 'article' already exists.
> I have tried to make a new database and to drop down the dump file but I
> have the same
Hello,
I have an mysql error message when trying to import the dump file
obtained from a backuped database into a new database.
I use the command:
mysql -u root otrs < mysql.sql
I have the error message: error 1050: Table 'article' already exists.
I have tried to make a new database and to
nal Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Varsani,
Rajendrakumar (PSD)
Sent: Friday, December 16, 2005 9:09 AM
To: User questions and discussions about OTRS.org
Subject: [otrs] MySQL Max Packet Size
Apologies for asking a MySQL question, but it's what we us
Apologies for asking a MySQL question, but it's what we use on the back
end of OTRS 1.2.3.
How do we set the MaxPacketSize to be greater than the default 1Mb and
persist after bootup? Otherwise, anything over 1Mb gets stuck in the
Mailbox. We did increase it but on a recent reboot, it's defaulted
Behalf Of Laurent GALAIS
> Sent: 7. desember 2005 21:02
> To: User questions and discussions about OTRS.org; User
> questions and discussions about OTRS.org
> Subject: RE: [otrs] Mysql error when trying to attach file to
> an outgoing email
>
> Thanks for responding Chris,
>
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Laurent GALAIS
Sent: Tuesday, December 06, 2005 6:15 PM
To: otrs@otrs.org
Subject: [otrs] Mysql error when trying to attach file to an outgoing email
Hello,
When I try to attach the following file to an email I'm writing:
dec_runner.tgz -&g
ailto:[EMAIL PROTECTED] On Behalf Of Laurent GALAIS
Sent: Tuesday, December 06, 2005 6:15 PM
To: otrs@otrs.org
Subject: [otrs] Mysql error when trying to attach file to an outgoing email
Hello,
When I try to attach the following file to an email I'm writing:
dec_runner.tgz -> 1.36 Mo
I&
Hello,
When I try to attach the following file to an email I'm writing:
dec_runner.tgz -> 1.36 Mo
I'm getting the following error from OTRS syslog:
Tue Dec 6 16:34:05 2005 error OTRS-CGI-10 MySQL server has gone away, SQL:
'INSERT INTO web_upload_cache (form_id, filename, content_type,
conten
Richard Petty wrote:
I reset the 'otrs' database password:
1. Used bin/CryptPassword.pl with a password of 'otrs'
2. Pasted the result, '09b8d8c8, into the otrs password field in MySQL
3. Setup entry in Config.pm to: $Self->{DatabasePw} = 'otrs';
Not sure what the CryptPassword.pl script i
I got OTRS going just before a long holiday weekend. I'd logged in as
[EMAIL PROTECTED] with a password of "root", just as the docs say.
I edited a copy of my Config.pm file to use LDAP and had no problems with
the new functionality.
When I returned to work this morning, the session had expired a
: [otrs] MySQL 5.x
I'm working on setting up OTRS 2 with MySQL 5.0.9 as a test to see if we
can replace our old system. It appears to be working fine with the
limited testing I have done. I'm working on the rest of the
configuration (mail, etc) and haven't done much testing as of yet.
I'm working on setting up OTRS 2 with MySQL 5.0.9 as a test to see if we
can replace our old system. It appears to be working fine with the
limited testing I have done. I'm working on the rest of the
configuration (mail, etc) and haven't done much testing as of yet.
Claude Watson
On Fri, 2005-11-
Does anyone know of any reason why OTRS 2.x would have issues if I
upgraded the SQL
backend to MySQL 5.x?
Is anyone using MySQL 5.x? I really need the "Views" feature of MySQL
5.x for advanced reporting and charting of the data in OTRS.
Thanks.
-Jeff
_
We have been using otrs with mysql for about 6 months and some of the
tables like article_attachment & article_plain are around 500MB
this means at some point we are going to hit the 2GB file limit
in myISAM that our mysql database is using.
I believe the best fix for this will be to convert to
Christian Schoepplein wrote:
Hi Danie,
On Thu, Aug 04, 2005 at 10:31:01AM +0200, Danie Theron wrote:
Christian Schoepplein wrote:
On Wed, Aug 03, 2005 at 02:32:08PM +0200, Danie Theron wrote:
Ok finally got the Config.pm file setup (correctly I hope:P) , getting
the following error when tr
Hi Danie,
On Thu, Aug 04, 2005 at 10:31:01AM +0200, Danie Theron wrote:
>Christian Schoepplein wrote:
>>On Wed, Aug 03, 2005 at 02:32:08PM +0200, Danie Theron wrote:
>>>Ok finally got the Config.pm file setup (correctly I hope:P) , getting
>>>the following error when trying to connect to the inte
Christian Schoepplein wrote:
Hi Danie,
On Wed, Aug 03, 2005 at 02:32:08PM +0200, Danie Theron wrote:
Ok finally got the Config.pm file setup (correctly I hope:P) , getting
the following error when trying to connect to the interface:
Error: Can't connect to local MySQL server through socket
Hi Danie,
On Wed, Aug 03, 2005 at 02:32:08PM +0200, Danie Theron wrote:
>Ok finally got the Config.pm file setup (correctly I hope:P) , getting
>the following error when trying to connect to the interface:
>
>Error: Can't connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock'
Hi all ,
Ok finally got the Config.pm file setup (correctly I hope:P) , getting
the following error when trying to connect to the interface:
Error: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' ([..]
Traceback: ERROR: OTRS-CGI-10 Perl: 5.8.5 OS: linux Time:
I'm running OTRS 1.3.2 with MySQL 4.1.
No problems
Regards,
Peter
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Peterson
Sent: vrijdag 22 juli 2005 17:12
To: otrs@otrs.org
Subject: [otrs] MySQL upgrade question
Hello,
I am running OTRS
It should be a painless upgrade, but like any upgrade,
if you can, you might want to test it on a development machine
first.
Chris Peterson wrote:
Hello,
I am running OTRS 1.2.3. The version of MySQL included in the install
package was 4.0. I am planning on putting another application on t
Hello,
I am running OTRS 1.2.3. The version of MySQL included in the install
package was 4.0. I am planning on putting another application on this
server that requires MySQL 4.1, however. Does anyone know if this will
cause any problems with my current installation of OTRS?
Thanks,
Christophe
Hello
everyone - which version of the mysql client does OTRS use by default? Are
those libraries built into OTRS, or, does OTRS use some algorithm to determine
which client to use?
Kind Regards,Rick
Cogley
Tokyo
««-««-««-««-««-««-««-««-««-««-Rick Cogley ([EMAIL PROTECTED])Tel: 03-5940-6880
> > The problem I'm having is that whenever I start the service "rcmysql
> > start" it fails to start. the weird thing is that I can access the
> > databases and login to mysql. Any idea on what I can try to correct
> > this problem and get the daemon to run properly?
Are you sure mysql isn't star
On Sunday, May 30, 2004 10:48 AM
Jesse <[EMAIL PROTECTED]> wrote:
> I am currently running mysql on a SuSE 9.0 machine. here is the mysql
> version
>
> Server version 4.0.15
> Protocol version10
> Connection Localhost via UNIX socket
> UNIX socket /var/lib
Hello all,
I am currently running mysql on a SuSE 9.0 machine. here is the mysql
version
Server version 4.0.15
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 23 min 0 sec
The problem I
On Friday, January 09, 2004 9:43 AM
Seth Brundle <[EMAIL PROTECTED]> wrote:
> I would like to run a MySQL query that tells me how many unanswered
> tickets I have in the entire OTRS database and the date of the oldest
> one.
Running queries directly against the database isn't recommended, but
poss
I would like to run a MySQL query that tells me how
many unanswered tickets I have in the entire OTRS database and the date of the
oldest one.
This is so I can insert it into a cgi page I use to
check the overall status of my website. Then I dont have to login to OTRS to see
if I need to c
1 - 100 of 103 matches
Mail list logo