Login problem

Hi. Someone must have seen this problem before. I can login to the web
interface but as soon as I click on any link I am kicked out to the
login page again. rt is running on Solaris 2.6. My rt user account has
the same permissions as everyone else and Netscape is set to accept all
cookies.

Matthew Herzog Unix Administrator
herzog@sdac.harvard.edu

Are you going through a set of web proxies that might change your request from time to time?

What version of netscape are you using?On Wed, Aug 16, 2000 at 01:43:43PM -0400, Matthew Herzog wrote:

Hi. Someone must have seen this problem before. I can login to the web
interface but as soon as I click on any link I am kicked out to the
login page again. rt is running on Solaris 2.6. My rt user account has
the same permissions as everyone else and Netscape is set to accept all
cookies.


Matthew Herzog Unix Administrator
herzog@sdac.harvard.edu


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent — root@eruditorum.orgjesse@fsck.com
pgp keyprint: 50 41 9C 03 D0 BC BC C8 2C B9 77 26 6F E1 EB 91
’“As the company that brought users the Internet, Netscape is now inviting
the more than 60 million people who have used our client software to
’tune up’ and upgrade to Netscape Communicator,” said Mike Homer,
senior vice president of marketing at Netscape.’ Sometimes I wonder.

I took a brief look at the code of autohandler and
have no clue yet. I still couldn’t login with root,
password combination. It is my first time for
installing RT.

/////////////////////////////////////////////////////////
# If the user isn’t privileged, they can only see
SelfService
if ((! $session{‘CurrentUser’}->Privileged) and
($m->base_comp->path !~ ‘^(/+)SelfService/’) )
{
$m->comp(’/SelfService/index.html’);
$m->abort();
}
else {
$m->call_next(%ARGS);
}
}

If we have no credentials

else {
$m->comp(’/Elements/Login’, %ARGS);
$m->abort();
}
</%INIT>
<& /Elements/Footer, %ARGS &>
<%ARGS>
$user => undef
$pass => undef
$menu => undef
</%ARGS>

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

do me a favor on your host via command line

mysql -u root -p
show databases;
use rt3;
show tables;

exit

send us the output.

thanx

zhou jian wrote:

mysql> SHOW DATABASES
-> ;
| Database |
| information_schema |
| mysql |
| rt3 |
| test |
4 rows in set (0.05 sec)

mysql> DATABASE rt3;
ERROR 1064 (42000): You have an error in your SQL
syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near
’DATABASE rt3’ at line 1
mysql> use rt3
Database changed
mysql> show tables
-> ;
| Tables_in_rt3 |
| ACL |
| Attachments |
| Attributes |
| CachedGroupMembers |
| CustomFieldValues |
| CustomFields |
| GroupMembers |
| Groups |
| Links |
| ObjectCustomFieldValues |
| ObjectCustomFields |
| Principals |
| Queues |
| ScripActions |
| ScripConditions |
| Scrips |
| Templates |
| Tickets |
| Transactions |
| Users |
| sessions |
21 rows in set (0.00 sec)

Here they are!

do me a favor on your host via command line

mysql -u root -p
show databases;
use rt3;
show tables;

exit

send us the output.

thanx

zhou jian wrote:

I took a brief look at the code of autohandler and
have no clue yet. I still couldn’t login with
root,
password combination. It is my first time for
installing RT.

/////////////////////////////////////////////////////////

# If the user isn't privileged, they can only

see

SelfService
if ((! $session{‘CurrentUser’}->Privileged)
and
($m->base_comp->path !~
’^(/+)SelfService/’) )
{
$m->comp(’/SelfService/index.html’);
$m->abort();
}
else {
$m->call_next(%ARGS);
}
}

If we have no credentials

else {
$m->comp(’/Elements/Login’, %ARGS);
$m->abort();
}
</%INIT>
<& /Elements/Footer, %ARGS &>
<%ARGS>
$user => undef
$pass => undef
$menu => undef
</%ARGS>


Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
http://mail.yahoo.com


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

Be sure to check out the RT Wiki at
http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials
from O’Reilly Media at
http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in
Amsterdam, Boston and
San Francisco - Find out more at
http://bestpractical.com/services/training.html

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

ok so you populated the database with info thats good
now can you please post your Siteconfig.pm

zhou jian wrote:

I am away from my machine. However, I only made one
change to my siteconfig.pm. Just added the ipaddress
to the Set($WebBaseURL,“myipaddress”); I didn’t even
configure the email right now.

ok so you populated the database with info thats
good
now can you please post your Siteconfig.pm

zhou jian wrote:

mysql> SHOW DATABASES
-> ;
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| rt3 |
| test |
±-------------------+
4 rows in set (0.05 sec)

mysql> DATABASE rt3;
ERROR 1064 (42000): You have an error in your SQL
syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use
near
’DATABASE rt3’ at line 1
mysql> use rt3
Database changed
mysql> show tables
-> ;
±------------------------+
| Tables_in_rt3 |
±------------------------+
| ACL |
| Attachments |
| Attributes |
| CachedGroupMembers |
| CustomFieldValues |
| CustomFields |
| GroupMembers |
| Groups |
| Links |
| ObjectCustomFieldValues |
| ObjectCustomFields |
| Principals |
| Queues |
| ScripActions |
| ScripConditions |
| Scrips |
| Templates |
| Tickets |
| Transactions |
| Users |
| sessions |
±------------------------+
21 rows in set (0.00 sec)

Here they are!

do me a favor on your host via command line

mysql -u root -p
show databases;
use rt3;
show tables;

exit

send us the output.

thanx

zhou jian wrote:

I took a brief look at the code of autohandler
and

have no clue yet. I still couldn’t login with
root,
password combination. It is my first time for
installing RT.

/////////////////////////////////////////////////////////

# If the user isn't privileged, they can

only

see

SelfService
if ((! $session{‘CurrentUser’}->Privileged)
and
($m->base_comp->path !~
’^(/+)SelfService/’) )
{
$m->comp(’/SelfService/index.html’);
$m->abort();
}
else {
$m->call_next(%ARGS);
}
}

If we have no credentials

else {
$m->comp(’/Elements/Login’, %ARGS);
$m->abort();
}
</%INIT>
<& /Elements/Footer, %ARGS &>
<%ARGS>
$user => undef
$pass => undef
$menu => undef
</%ARGS>


Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
http://mail.yahoo.com


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

Be sure to check out the RT Wiki at
http://wiki.bestpractical.com
Download a free sample chapter of RT Essentials
from O’Reilly Media at
http://rtbook.bestpractical.com
WE’RE COMING TO YOUR TOWN SOON - RT Training in
Amsterdam, Boston and
San Francisco - Find out more at
http://bestpractical.com/services/training.html


Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
http://mail.yahoo.com

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

I am away from my machine. However, I only made one
change to my siteconfig.pm. Just added the ipaddress
to the Set($WebBaseURL,“myipaddress”); I didn’t even
configure the email right now.

ok so you populated the database with info thats
good
now can you please post your Siteconfig.pm

zhou jian wrote:

mysql> SHOW DATABASES
-> ;
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| rt3 |
| test |
±-------------------+
4 rows in set (0.05 sec)

mysql> DATABASE rt3;
ERROR 1064 (42000): You have an error in your SQL
syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use
near
’DATABASE rt3’ at line 1
mysql> use rt3
Database changed
mysql> show tables
-> ;
±------------------------+
| Tables_in_rt3 |
±------------------------+
| ACL |
| Attachments |
| Attributes |
| CachedGroupMembers |
| CustomFieldValues |
| CustomFields |
| GroupMembers |
| Groups |
| Links |
| ObjectCustomFieldValues |
| ObjectCustomFields |
| Principals |
| Queues |
| ScripActions |
| ScripConditions |
| Scrips |
| Templates |
| Tickets |
| Transactions |
| Users |
| sessions |
±------------------------+
21 rows in set (0.00 sec)

Here they are!

do me a favor on your host via command line

mysql -u root -p
show databases;
use rt3;
show tables;

exit

send us the output.

thanx

zhou jian wrote:

I took a brief look at the code of autohandler
and

have no clue yet. I still couldn’t login with
root,
password combination. It is my first time for
installing RT.

/////////////////////////////////////////////////////////

# If the user isn't privileged, they can

only

see

SelfService
if ((! $session{‘CurrentUser’}->Privileged)
and
($m->base_comp->path !~
’^(/+)SelfService/’) )
{
$m->comp(’/SelfService/index.html’);
$m->abort();
}
else {
$m->call_next(%ARGS);
}
}

If we have no credentials

else {
$m->comp(’/Elements/Login’, %ARGS);
$m->abort();
}
</%INIT>
<& /Elements/Footer, %ARGS &>
<%ARGS>
$user => undef
$pass => undef
$menu => undef
</%ARGS>


Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
http://mail.yahoo.com


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

Be sure to check out the RT Wiki at
http://wiki.bestpractical.com
Download a free sample chapter of RT Essentials
from O’Reilly Media at
http://rtbook.bestpractical.com
WE’RE COMING TO YOUR TOWN SOON - RT Training in
Amsterdam, Boston and
San Francisco - Find out more at
http://bestpractical.com/services/training.html


Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
http://mail.yahoo.com

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

change it to the dns name that you have defined in apache as ServerName

zhou jian wrote:

http://osg-tg2.its.uiowa.edu/rt/

I used this one, but it still the same!

change it to the dns name that you have defined in
apache as ServerName

zhou jian wrote:

I am away from my machine. However, I only made
one
change to my siteconfig.pm. Just added the
ipaddress
to the Set($WebBaseURL,“myipaddress”); I didn’t
even
configure the email right now.

ok so you populated the database with info thats
good
now can you please post your Siteconfig.pm

zhou jian wrote:

mysql> SHOW DATABASES
-> ;
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| rt3 |
| test |
±-------------------+
4 rows in set (0.05 sec)

mysql> DATABASE rt3;
ERROR 1064 (42000): You have an error in your
SQL

syntax; check the manual that corresponds to
your

MySQL server version for the right syntax to use
near
’DATABASE rt3’ at line 1
mysql> use rt3
Database changed
mysql> show tables
-> ;
±------------------------+
| Tables_in_rt3 |
±------------------------+
| ACL |
| Attachments |
| Attributes |
| CachedGroupMembers |
| CustomFieldValues |
| CustomFields |
| GroupMembers |
| Groups |
| Links |
| ObjectCustomFieldValues |
| ObjectCustomFields |
| Principals |
| Queues |
| ScripActions |
| ScripConditions |
| Scrips |
| Templates |
| Tickets |
| Transactions |
| Users |
| sessions |
±------------------------+
21 rows in set (0.00 sec)

Here they are!

do me a favor on your host via command line

mysql -u root -p
show databases;
use rt3;
show tables;

exit

send us the output.

thanx

zhou jian wrote:

I took a brief look at the code of autohandler
and

have no clue yet. I still couldn’t login with
root,
password combination. It is my first time for
installing RT.

/////////////////////////////////////////////////////////

# If the user isn't privileged, they can

only

see

SelfService
if ((!
$session{‘CurrentUser’}->Privileged)

and

    ($m->base_comp->path !~

‘^(/+)SelfService/’) )

{
$m->comp(’/SelfService/index.html’);
$m->abort();
}
else {
$m->call_next(%ARGS);
}
}

If we have no credentials

else {
$m->comp(’/Elements/Login’, %ARGS);
$m->abort();
}
</%INIT>
<& /Elements/Footer, %ARGS &>
<%ARGS>
$user => undef
$pass => undef
$menu => undef
</%ARGS>


Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
http://mail.yahoo.com


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

Be sure to check out the RT Wiki at
http://wiki.bestpractical.com
Download a free sample chapter of RT
Essentials

from O’Reilly Media at
http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training
in

Amsterdam, Boston and

San Francisco - Find out more at
http://bestpractical.com/services/training.html


Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
http://mail.yahoo.com


Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
http://mail.yahoo.com

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Hello,

I installed rt 3.8.2 from source on Debian Lenny, using mysql (Ver 14.12
Distrib 5.0.51a, for debian-linux-gnu (x86_64) using readline 5.2) and
an import from an rt 3.4.1 database of an rt install on Debian Etch. I
followed the proper guidelines and successfully installed it and it is
working fine. Except that it’s asking for a login and password repeatedly.

For example, you log in as usual which works, then you click on a quick
search item, no problems, then you click on a ticket in and it will
prompt you for your credentials again before opening the ticket. If you
repeat this the same thing will happen.

Perhaps this is an issue with the apache2 configuration? I have pasted
my config below, I am using fast-cgi. Thanks in advance for any help.

ServerSignature Off ServerName rt3.example.com ServerAdmin admin@example.com Redirect permanent / https://rt3.example.com

FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 120
-processes 10

ServerSignature Off
SSLEngine on
SSLCertificateFile /etc/apache2/ssl/rt3.crt
SSLCertificateKeyFile /etc/apache2/ssl/rt3.key

     ServerName rt3.example.com
     ServerAdmin unix@example.com

     DocumentRoot /opt/rt3/share/html
     # Pass through requests to display images
     Alias /NoAuth/images/ /opt/rt3/share/html/NoAuth/images/

     ScriptAlias / /opt/rt3/bin/mason_handler.fcgi/

Go to where you unzipped the source and read UPGRADING.mysql
I’ve got the same issue and this is what seems to be the problem.
CROn Feb 6, 2009, at 3:20 PM, Jeroen van Aart wrote:

Hello,

I installed rt 3.8.2 from source on Debian Lenny, using mysql (Ver
14.12
Distrib 5.0.51a, for debian-linux-gnu (x86_64) using readline 5.2) and
an import from an rt 3.4.1 database of an rt install on Debian Etch. I
followed the proper guidelines and successfully installed it and it is
working fine. Except that it’s asking for a login and password
repeatedly.

For example, you log in as usual which works, then you click on a
quick
search item, no problems, then you click on a ticket in and it will
prompt you for your credentials again before opening the ticket. If
you
repeat this the same thing will happen.

Perhaps this is an issue with the apache2 configuration? I have pasted
my config below, I am using fast-cgi. Thanks in advance for any help.

ServerSignature Off ServerName rt3.example.com ServerAdmin admin@example.com Redirect permanent / https://rt3.example.com

FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 120
-processes 10

ServerSignature Off
SSLEngine on
SSLCertificateFile /etc/apache2/ssl/rt3.crt
SSLCertificateKeyFile /etc/apache2/ssl/rt3.key

    ServerName rt3.example.com
    ServerAdmin unix@example.com

    DocumentRoot /opt/rt3/share/html
    # Pass through requests to display images
    Alias /NoAuth/images/ /opt/rt3/share/html/NoAuth/images/

    ScriptAlias / /opt/rt3/bin/mason_handler.fcgi/
_______________________________________________ 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

Macnlos wrote:

Go to where you unzipped the source and read UPGRADING.mysql
I’ve got the same issue and this is what seems to be the problem.

Thanks for the suggestion. I did more or less follow that guide, I
believe I didn’t do the “make initialize-database” but created a
database, imported the rt 3.4.1 dumpfile and applied the changes.

I’ll try to do the “make initialize-database”.

Best regards,
Jeroen