Re: [otrs] Backup restore error ERROR 1045: Access denied for user:'otrs@localhost'

2003-09-15 Thread Robert Kehl
Am Mon, 2003-09-15 um 13.17 schrieb [EMAIL PROTECTED]:

> 13) again /scripts/restores.sh ... OK
> 14) I can log in with my username, I see the Queues  and so on
> but the pop service doesnt work . 
> 
> I think I have to recutomize Config.pm and var/cron 
> Do you confirm ? 

No, Config.pm should be the same as you had on the former box, but you
probably have to install cron jobs again. Do a 

  crontab -u otrs -l

to see what's there. Do this as Root.

If the CRON jobs are pretending to be running, have a look at syslog,
which probably is your logging mechanism. Watch for output from OTRS
itself as well as from your MTA (sendmail,postfix,exim and the like).

The last thing: POP3PostMaster.pl is an outgoing process - could be the
firewall mechanism on the new box doesn't allow this? You should see
this in the firewall's logs, usually located in syslog, too.

At last, is the new box capable of actually resolving the POP server's
name? Some new system are correctly set up to see everything in the
internal network, but have no clue of what outside servers are named.
Look in your system configuration and issue a

  host my.popserver.example

to see if the box can resolve it. If not, play with /etc/resolv.conf
anbd your network setup. No, you need not have a DNS server running on
the otrs box, although you may do so.

htht,

Robert Kehl

___
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


Re: [otrs] Backup restore error ERROR 1045: Access denied for user:'otrs@localhost'

2003-09-15 Thread jerome




Thank you Robert for your answer
OK you''re right.
my former explantion was a bit shorten ...

1) I have  an OTRS 1.1.2 working on a little RH8 bos since 2 month,
with the pop fct to get the tickets 
2) i upgraded this installation to otrs 1.1.3 , OK ( rpm -U
otrs.1.1.3.rpm)
3) i want to migrate it to a better server , which is in RH9
4) on the little RH8 box ,i did a .scripts/backup.sh OK
5) tar the backuped data on the old RH8 box 
6) copy the tarred data files to the new RH9 server
7) Install OTRS on the RH9 with your OTRS113 RPM for RH8 .
    - Smile: every perl and mysql package needed for OTRS is present in
the RH9 distrib!.
 so the install process is straight forward, before the Web browser
part.
8) httpd://myhost/otrs/installer.pl : Error 403  , do'not have
permission ... 
-> ~otrs/ was forbidden for apache so 
chgrp -R apache ~otrs , and 
chmod 750 ~otrs/
9) Web part install: i did not remember that if you try to change the
[EMAIL PROTECTED] password
you do nothing since : "Access denied for  user:'[EMAIL PROTECTED]' ". 
So I left it empty for the moment. 
10 ) the creation of the database occured . 
11 ) otrs working on the new server.  The step you asked me. 

Now restore the tarred files to the new  OTRS server
11) detar
12) ./scripts/restores.sh ...
-> the database OTRS already exists !
-> so i dropped it with a shell "mysql -u root -e 'drop ...'
13) again /scripts/restores.sh ... OK
14) I can log in with my username, I see the Queues  and so on
but the pop service doesnt work . 

I think I have to recutomize Config.pm and var/cron 
Do you confirm ? 

Thank a lot for this fine work .

Jerome






Robert Kehl wrote:

  - Original Message - 
From: <[EMAIL PROTECTED]>
Sent: Saturday, September 13, 2003 6:59 PM


  
  
1) OTRS 1.1.3 installed ok on the new server , but i stopped before
otrs/install.pl
the original otrs was 1.1.2 , and  was upgraded ok

  
  
I don't fully understand this. You updgraded a (preinstalled) 1.1.2 by
installing 1.1.3, but stopped before install.pl could run? And 1.1.3 did
work?!?

Now you want to restore from a 1.1.3 backup? Try to complete the whole
installation process including install.pl, and then perform the restore
action. Let us know if you succeed.

hth,

Robert Kehl

___
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


  



___
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

Re: [otrs] Backup restore error ERROR 1045: Access denied for user:'otrs@localhost'

2003-09-14 Thread Robert Kehl
- Original Message - 
From: <[EMAIL PROTECTED]>
Sent: Saturday, September 13, 2003 6:59 PM


> 1) OTRS 1.1.3 installed ok on the new server , but i stopped before
> otrs/install.pl
> the original otrs was 1.1.2 , and  was upgraded ok

I don't fully understand this. You updgraded a (preinstalled) 1.1.2 by
installing 1.1.3, but stopped before install.pl could run? And 1.1.3 did
work?!?

Now you want to restore from a 1.1.3 backup? Try to complete the whole
installation process including install.pl, and then perform the restore
action. Let us know if you succeed.

hth,

Robert Kehl

___
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


[otrs] Backup restore error ERROR 1045: Access denied for user: 'otrs@localhost'

2003-09-13 Thread jerome
Hello everybody

I am trying to move otrs to a new server (new apache,otrs,mysql...)

the old one is a RedHat8
rhe new one is a RedHat9
OTRS is 1.1.3

1) OTRS 1.1.3 installed ok on the new server , but i stopped before 
otrs/install.pl
the original otrs was 1.1.2 , and  was upgraded ok

2) backup Otrs on the old server , and tar the data : ok

3) untar the data ok on the new server

4) i tried to restore the data into the new otrs server
httpd-2.0.40-21
perl-DBD-MySQL-2.1021-3
mysql-3.23.54a-11
mysql-server-3.23.54a-11
./scripts/restore.sh /opt/otrs/bin /opt/otrs/Kernel/ 
/opt/otrs-backup/2003-.
restore.sh - a restore script for OTRS <$Revision: 1.5 $>
Copyright (c) 2002 Martin Edenhofer <[EMAIL PROTECTED]>
create database otrs
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)

what to do ?
of course i am a mysql newbie!
thank for your help ...

Jerome



___
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