[rt-users] login problem

Chaim Rieger chaim.rieger at gmail.com
Mon Feb 27 20:14:04 EST 2006


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.
> 
> --- Chaim Rieger <chaim.rieger at gmail.com> wrote:
> 
>> 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!
>>> --- Chaim Rieger <chaim.rieger at gmail.com> wrote:
>>>
>>>> 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 
> 




More information about the rt-users mailing list