How should I create a db in mysql?

Hi, folks.

My scenario is:
Debian 5.0 lenny x86_64
Request Tracker 3.6
Mysql 5.0

This is my first time here and I need some help:

I don’t know to create a mysql database, since as I observed, there is
no database created.

Wagner Pereira

PoP-SP/RNP - Ponto de Presen�a da RNP em S�o Paulo
CCE/USP - Centro de Computa��o Eletr�nica da Universidade de S�o Paulo
http://www.pop-sp.rnp.br
Fone@RNP 1015-8902

Login to mysql as root (or user with admin access).

create database rt3;
grant all on rt3.* to rt3 identified by ‘password’;
flush privileges;

…should do it IIRC.

You can also use the ‘mysqladmin’ utility that I think the documentation
references.

-jakeOn Mon, 30 Nov 2009, Wagner Pereira wrote:

Hi, folks.

My scenario is:
Debian 5.0 lenny x86_64
Request Tracker 3.6
Mysql 5.0

This is my first time here and I need some help:

I don’t know to create a mysql database, since as I observed, there is
no database created.

Wagner Pereira

PoP-SP/RNP - Ponto de Presença da RNP em São Paulo
CCE/USP - Centro de Computação Eletrônica da Universidade de São Paulo
http://www.pop-sp.rnp.br
Fone@RNP 1015-8902


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Hi, folks.

My scenario is:
Debian 5.0 lenny x86_64
Request Tracker 3.6
Mysql 5.0

This is my first time here and I need some help:

I don’t know to create a mysql database, since as I observed, there is
no database created.

I suspect you want the ‘make initdb’ command

Hi, Kevin.

Could you help me?

RT: Request Tracker
You’re almost there!

You haven’t yet configured your webserver to run RT.

You appear to have installed RT’s web interface correctly, but haven’t
yet configured your web server to “run” the RT server which powers the
web interface.

The next step is to edit your webserver’s configuration file to instruct
it to use RT’s mod_perl , fastcgi or speedycgi handler.

Wagner Pereira

PoP-SP/RNP - Ponto de Presen�a da RNP em S�o Paulo
CCE/USP - Centro de Computa��o Eletr�nica da Universidade de S�o Paulo
http://www.pop-sp.rnp.br
Fone@RNP 1015-8902

Kevin Falcone escreveu:> On Mon, Nov 30, 2009 at 12:26:45PM -0200, Wagner Pereira wrote:

Hi, folks.

My scenario is:
Debian 5.0 lenny x86_64
Request Tracker 3.6
Mysql 5.0

This is my first time here and I need some help:

I don’t know to create a mysql database, since as I observed, there is
no database created.

I suspect you want the ‘make initdb’ command



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Hi, Kevin.

Could you help me?

RT: Request Tracker
You’re almost there!

You haven’t yet configured your webserver to run RT.

You appear to have installed RT’s web interface correctly, but haven’t
yet configured your web server to “run” the RT server which powers the
web interface.

The next step is to edit your webserver’s configuration file to instruct
it to use RT’s mod_perl , fastcgi or speedycgi handler.

This is all covered in the README
You need to configure apache

-kevin

This is all covered in the README
You need to configure apache

-kevin

Kevin,

Is this README file in /opt/rt3/share/doc path?

Wagner Pereira

PoP-SP/RNP - Ponto de Presen�a da RNP em S�o Paulo
CCE/USP - Centro de Computa��o Eletr�nica da Universidade de S�o Paulo
http://www.pop-sp.rnp.br
Fone@RNP 1015-8902

Kevin Falcone escreveu:> On Mon, Nov 30, 2009 at 05:43:20PM -0200, Wagner Pereira wrote:

Hi, Kevin.

Could you help me?

RT: Request Tracker
You’re almost there!

You haven’t yet configured your webserver to run RT.

You appear to have installed RT’s web interface correctly, but haven’t
yet configured your web server to “run” the RT server which powers the
web interface.

The next step is to edit your webserver’s configuration file to instruct
it to use RT’s mod_perl , fastcgi or speedycgi handler.

This is all covered in the README
You need to configure apache

-kevin

Wagner Pereira

PoP-SP/RNP - Ponto de Presen�a da RNP em S�o Paulo
CCE/USP - Centro de Computa��o Eletr�nica da Universidade de S�o Paulo
http://www.pop-sp.rnp.br
Fone@RNP 1015-8902

Kevin Falcone escreveu:

On Mon, Nov 30, 2009 at 12:26:45PM -0200, Wagner Pereira wrote:

Hi, folks.

My scenario is:
Debian 5.0 lenny x86_64
Request Tracker 3.6
Mysql 5.0

This is my first time here and I need some help:

I don’t know to create a mysql database, since as I observed, there is
no database created.

I suspect you want the ‘make initdb’ command



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Take a look at the following 2 URL’s, and make sure you set your
Apache directives (in your httpd.conf file):

http://wiki.bestpractical.com/view/ManualInstallation
http://wiki.bestpractical.com/view/ManualApacheConfig

Also, make sure you have all the appropriate references made to
mod_perl (or FastCGI)

Lastly, there are some references (in the past few months) made to
this issue, and you’d be able to Google them on www.gossamer-threads.com
http://www.gossamer-threads.com/lists/rt/users/90374

-BehzadOn Nov 30, 2009, at 12:06 PM, Wagner Pereira wrote:

This is all covered in the README
You need to configure apache

-kevin

Kevin,

Is this README file in /opt/rt3/share/doc path?

Wagner Pereira

PoP-SP/RNP - Ponto de Presença da RNP em São Paulo
CCE/USP - Centro de Computação Eletrônica da Universidade de São Paulo
http://www.pop-sp.rnp.br
Fone@RNP 1015-8902

Kevin Falcone escreveu:

On Mon, Nov 30, 2009 at 05:43:20PM -0200, Wagner Pereira wrote:

Hi, Kevin.

Could you help me?

RT: Request Tracker
You’re almost there!

You haven’t yet configured your webserver to run RT.

You appear to have installed RT’s web interface correctly, but
haven’t
yet configured your web server to “run” the RT server which powers
the
web interface.

The next step is to edit your webserver’s configuration file to
instruct
it to use RT’s mod_perl , fastcgi or speedycgi handler.

This is all covered in the README
You need to configure apache

-kevin

Wagner Pereira

PoP-SP/RNP - Ponto de Presença da RNP em São Paulo
CCE/USP - Centro de Computação Eletrônica da Universidade de São
Paulo
http://www.pop-sp.rnp.br
Fone@RNP 1015-8902

Kevin Falcone escreveu:

On Mon, Nov 30, 2009 at 12:26:45PM -0200, Wagner Pereira wrote:

Hi, folks.

My scenario is:
Debian 5.0 lenny x86_64
Request Tracker 3.6
Mysql 5.0

This is my first time here and I need some help:

I don’t know to create a mysql database, since as I observed,
there is
no database created.

I suspect you want the ‘make initdb’ command



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly
Media.
Buy a copy at http://rtbook.bestpractical.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com