is it mandatory for OTRS and mysql to be there in the same box.

Katta, Lokesh Katta Subramanyam

5 Jun 2009 5 Jun '09

10:06 a.m.

Hi All, While creating the database using the installer, I am getting errors if I mention the database location to be a different system other than the localhost. Unable to get what could be wrong. Has anyone tried it? Best Regards, Lokesh K S

Attachments:

attachment.html (text/html — 2.2 KB)

Show replies by date

Marco Vannini

5 Jun 5 Jun

10:38 a.m.

New subject: is it mandatory for OTRS and mysql to be there in the same box.

does the remote mysql has an access available from any place for the user that you are trying to use ? On Fri, Jun 5, 2009 at 12:06 PM, Katta, Lokesh Katta Subramanyam < lokesh.ks@cgi.com> wrote:

...

Hi All,

While creating the database using the installer, I am getting errors if I mention the database location to be a different system other than the localhost. Unable to get what could be wrong. Has anyone tried it?

Best Regards,

Lokesh K S

--------------------------------------------------------------------- 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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

Katta, Lokesh Katta Subramanyam

11:55 a.m.

New subject: is it mandatory for OTRS and mysql to be there in thesame box.

Yes. I created an user with privileges to access from anywhere. But the error I get is that the <systemname> is not allowed to connect to mysql. Best Regards, Lokesh K S ________________________________ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Marco Vannini Sent: Friday, June 05, 2009 4:09 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] is it mandatory for OTRS and mysql to be there in thesame box. does the remote mysql has an access available from any place for the user that you are trying to use ? On Fri, Jun 5, 2009 at 12:06 PM, Katta, Lokesh Katta Subramanyam wrote: Hi All, While creating the database using the installer, I am getting errors if I mention the database location to be a different system other than the localhost. Unable to get what could be wrong. Has anyone tried it? Best Regards, Lokesh K S --------------------------------------------------------------------- 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

Marco Vannini

12:36 p.m.

New subject: is it mandatory for OTRS and mysql to be there in thesame box.

has the remote machine port 3306 open ? On Fri, Jun 5, 2009 at 1:55 PM, Katta, Lokesh Katta Subramanyam < lokesh.ks@cgi.com> wrote:

...

Yes. I created an user with privileges to access from anywhere. But the error I get is that the <systemname> is not allowed to connect to mysql.

Best Regards,

Lokesh K S ------------------------------

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Marco Vannini *Sent:* Friday, June 05, 2009 4:09 PM *To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] is it mandatory for OTRS and mysql to be there in thesame box.

does the remote mysql has an access available from any place for the user that you are trying to use ?

On Fri, Jun 5, 2009 at 12:06 PM, Katta, Lokesh Katta Subramanyam < lokesh.ks@cgi.com> wrote:

Hi All,

While creating the database using the installer, I am getting errors if I mention the database location to be a different system other than the localhost. Unable to get what could be wrong. Has anyone tried it?

Best Regards,

Lokesh K S

--------------------------------------------------------------------- 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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

--------------------------------------------------------------------- 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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

Reto Mueller

7 Jun 7 Jun

11:46 a.m.

New subject: is it mandatory for OTRS and mysql to be there in thesame box.

Marco Vannini wrote:

...

has the remote machine port 3306 open ?

On Fri, Jun 5, 2009 at 1:55 PM, Katta, Lokesh Katta Subramanyam mailto:lokesh.ks@cgi.com> wrote:

Yes. I created an user with privileges to access from anywhere. But the error I get is that the <systemname> is not allowed to connect to mysql.

Best Regards,

Lokesh K S

------------------------------------------------------------------------

*From:* otrs-bounces@otrs.org mailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org mailto:otrs-bounces@otrs.org] *On Behalf Of *Marco Vannini *Sent:* Friday, June 05, 2009 4:09 PM *To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] is it mandatory for OTRS and mysql to be there in thesame box.

does the remote mysql has an access available from any place for the user that you are trying to use ?

On Fri, Jun 5, 2009 at 12:06 PM, Katta, Lokesh Katta Subramanyam mailto:lokesh.ks@cgi.com> wrote:

Hi All,

While creating the database using the installer, I am getting errors if I mention the database location to be a different system other than the localhost. Unable to get what could be wrong. Has anyone tried it?

Best Regards,

Lokesh K S

--------------------------------------------------------------------- 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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

--------------------------------------------------------------------- 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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

------------------------------------------------------------------------

--------------------------------------------------------------------- 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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ In some distros the parameter bind-address is set to localhost in the the my.cnf. Comment it and restart mysql.

regards, Reto

Katta, Lokesh Katta Subramanyam

8 Jun 8 Jun

10:40 a.m.

New subject: is it mandatory for OTRS and mysql to be there in thesame box.

Yes, the remote port is open. I am also able to connect to the database using the terminal. The problem is only when I configure it with OTRS. Thanks and Regards, Lokesh K S -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Reto Mueller Sent: Sunday, June 07, 2009 5:17 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] is it mandatory for OTRS and mysql to be there in thesame box. Marco Vannini wrote:

...

has the remote machine port 3306 open ?

On Fri, Jun 5, 2009 at 1:55 PM, Katta, Lokesh Katta Subramanyam mailto:lokesh.ks@cgi.com> wrote:

Yes. I created an user with privileges to access from anywhere. But the error I get is that the <systemname> is not allowed to connect to mysql.

Best Regards,

Lokesh K S

------------------------------------------------------------------------

...

*From:* otrs-bounces@otrs.org mailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org mailto:otrs-bounces@otrs.org] *On Behalf Of *Marco Vannini *Sent:* Friday, June 05, 2009 4:09 PM *To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] is it mandatory for OTRS and mysql to be there in thesame box.

does the remote mysql has an access available from any place for the user that you are trying to use ?

On Fri, Jun 5, 2009 at 12:06 PM, Katta, Lokesh Katta Subramanyam mailto:lokesh.ks@cgi.com> wrote:

Hi All,

While creating the database using the installer, I am getting errors if I mention the database location to be a different system other than the localhost. Unable to get what could be wrong. Has anyone tried it?

Best Regards,

Lokesh K S

---------------------------------------------------------------------

...

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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

---------------------------------------------------------------------

...

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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

------------------------------------------------------------------------

...

--------------------------------------------------------------------- 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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

In some distros the parameter bind-address is set to localhost in the the my.cnf. Comment it and restart mysql. regards, Reto --------------------------------------------------------------------- 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

LQ Marshall

9 Jun 9 Jun

1:02 a.m.

New subject: is it mandatory for OTRS and mysql to be therein thesame box.

During testing we did have the mysql database on a different box. Don't recall there being any significant issue, but that was a while ago. We may have installed on a local system and migrated to a remote at a point during testing. (?) I'd suggest verifying the hostname and resolution. I can't really see a reason why the code would care local vs. remote in this case. Corin

5884

Age (days ago)

5888

Last active (days ago)

List overview

Download

6 comments

4 participants

participants (4)

Katta, Lokesh Katta Subramanyam
LQ Marshall
Marco Vannini
Reto Mueller