Webkonfiguration funktioniert nicht
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
Webkonfiguration funktioniert nicht
Hallo,
die Installation via rpm Datei ging soweit ich das sehe recht gut.
Jedoch kann ich die installer.pl oder ein anderes OTRS File nicht aufrufen.
http://mein.server.tls/otrs/installer.pl (>404 Seite nicht gefunden)
Installationslog:
[php]
wget http://ftp.otrs.org/pub/otrs/RPMS/suse/ ... 1.i386.rpm
--00:36:07-- http://ftp.otrs.org/pub/otrs/RPMS/suse/ ... 1.i386.rpm
=> `otrs-2.1.5-01.i386.rpm'
Resolving ftp.otrs.org... 88.198.xx.xx
Connecting to ftp.otrs.org|88.198.xx.xx|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 13,055,326 (12M) [application/x-rpm]
100%[====================================>] 13,055,326 6.01M/s
00:36:23 (5.99 MB/s) - `otrs-2.1.5-01.i386.rpm' saved [13055326/13055326]
rpm -ivh otrs-2.1.5-01.i386.rpm
error: Failed dependencies:
perl-GD is needed by otrs-2.1.5-01
perl-GDGraph is needed by otrs-2.1.5-01
perl-GDTextUtil is needed by otrs-2.1.5-01
perl-Net-DNS is needed by otrs-2.1.5-01
apache2-mod_perl is needed by otrs-2.1.5-01
fetchmail is needed by otrs-2.1.5-01
procmail is needed by otrs-2.1.5-01
# yast -i perl-GD perl-GDGraph perl-GDTextUtil perl-Net-DNS
apache2-mod_perl fetchmail procmail
/sbin/yast: line 139: testutf8: command not found
# rpm -ivh otrs-2.1.5-01.i386.rpm
Preparing... ########################################### [100%]
Check OTRS user (/etc/passwd)... otrs added.
1:otrs ########################################### [100%]
hostname: Unknown host
# SuSEconfig
Starting SuSEconfig, the SuSE Configuration Tool...
Running in full featured mode.
Reading /etc/sysconfig and updating the system...
Executing /sbin/conf.d/SuSEconfig.groff...
Executing /sbin/conf.d/SuSEconfig.libxml2...
Executing /sbin/conf.d/SuSEconfig.news...
Executing /sbin/conf.d/SuSEconfig.perl...
Executing /sbin/conf.d/SuSEconfig.permissions...
Executing /sbin/conf.d/SuSEconfig.postfix...
hostname: Unknown host
Setting up postfix local as MDA...
Setting SPAM protection to "off"...
Executing /sbin/conf.d/SuSEconfig.sortpasswd...
Executing /sbin/conf.d/SuSEconfig.syslog-ng...
# rcapache restart
-bash: rcapache: command not found
# rcmysql start
Starting service MySQL done
[/php]
die Installation via rpm Datei ging soweit ich das sehe recht gut.
Jedoch kann ich die installer.pl oder ein anderes OTRS File nicht aufrufen.
http://mein.server.tls/otrs/installer.pl (>404 Seite nicht gefunden)
Installationslog:
[php]
wget http://ftp.otrs.org/pub/otrs/RPMS/suse/ ... 1.i386.rpm
--00:36:07-- http://ftp.otrs.org/pub/otrs/RPMS/suse/ ... 1.i386.rpm
=> `otrs-2.1.5-01.i386.rpm'
Resolving ftp.otrs.org... 88.198.xx.xx
Connecting to ftp.otrs.org|88.198.xx.xx|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 13,055,326 (12M) [application/x-rpm]
100%[====================================>] 13,055,326 6.01M/s
00:36:23 (5.99 MB/s) - `otrs-2.1.5-01.i386.rpm' saved [13055326/13055326]
rpm -ivh otrs-2.1.5-01.i386.rpm
error: Failed dependencies:
perl-GD is needed by otrs-2.1.5-01
perl-GDGraph is needed by otrs-2.1.5-01
perl-GDTextUtil is needed by otrs-2.1.5-01
perl-Net-DNS is needed by otrs-2.1.5-01
apache2-mod_perl is needed by otrs-2.1.5-01
fetchmail is needed by otrs-2.1.5-01
procmail is needed by otrs-2.1.5-01
# yast -i perl-GD perl-GDGraph perl-GDTextUtil perl-Net-DNS
apache2-mod_perl fetchmail procmail
/sbin/yast: line 139: testutf8: command not found
# rpm -ivh otrs-2.1.5-01.i386.rpm
Preparing... ########################################### [100%]
Check OTRS user (/etc/passwd)... otrs added.
1:otrs ########################################### [100%]
hostname: Unknown host
# SuSEconfig
Starting SuSEconfig, the SuSE Configuration Tool...
Running in full featured mode.
Reading /etc/sysconfig and updating the system...
Executing /sbin/conf.d/SuSEconfig.groff...
Executing /sbin/conf.d/SuSEconfig.libxml2...
Executing /sbin/conf.d/SuSEconfig.news...
Executing /sbin/conf.d/SuSEconfig.perl...
Executing /sbin/conf.d/SuSEconfig.permissions...
Executing /sbin/conf.d/SuSEconfig.postfix...
hostname: Unknown host
Setting up postfix local as MDA...
Setting SPAM protection to "off"...
Executing /sbin/conf.d/SuSEconfig.sortpasswd...
Executing /sbin/conf.d/SuSEconfig.syslog-ng...
# rcapache restart
-bash: rcapache: command not found
# rcmysql start
Starting service MySQL done
[/php]
Last edited by goldfisch2k on 25 Feb 2007, 01:21, edited 1 time in total.
Re: Webconfiguration funktionert nicht
Der Apache wurde nicht neu gestartet. Bitte per Hand nachholen.goldfisch2k wrote: # rcapache restart
-bash: rcapache: command not found
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
Habe hier das Problem zuällig gefunden:
http://www.otrs-forum.de/viewtopic.php?t=550
Leider liegt hier für das openSuse scheinbar noch keine Lösung vor.
Was tun ?
http://www.otrs-forum.de/viewtopic.php?t=550
Leider liegt hier für das openSuse scheinbar noch keine Lösung vor.
Was tun ?
mod_perl von Hand in der Apache Konfiguration hinzufügen....
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
In der loadmodule.conf habe ich nun folgende Zeile hinzugefügt:jojo wrote:mod_perl von Hand in der Apache Konfiguration hinzufügen....
LoadModule perl /usr/lib/apache2/mod_perl.so
Aber leider scheint das nicht auszureichen:
[php] # rsapache2 start
-bash: rsapache2: command not found
# /etc/rc.d/apache start -restart
-bash: /etc/rc.d/apache: No such file or directory
# /etc/rc.d/apache2 start -restart
Warning: found stale pidfile (unclean shutdown?)
Starting httpd2 (prefork) Usage: /usr/sbin/httpd2-prefork [-D name] [-d directory] [-f file]
[-C "directive"] [-c "directive"]
[-k start|restart|graceful|stop]
[-v] [-V] [-h] [-l] [-L] [-t] [-S]
Options:
-D name : define a name for use in <IfDefine name> directives
-d directory : specify an alternate initial ServerRoot
-f file : specify an alternate ServerConfigFile
-C "directive" : process directive before reading config files
-c "directive" : process directive after reading config files
-e level : show startup errors of level (see LogLevel)
-E file : log startup errors to file
-v : show version number
-V : show compile settings
-h : list available command line options (this page)
-l : list compiled in modules
-L : list available configuration directives
-t -D DUMP_VHOSTS : show parsed settings (currently only vhost settings)
-S : a synonym for -t -D DUMP_VHOSTS
-t : run syntax check for config files
The command line was:
/usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -restart
[glow=red]failed[/glow]
[/php]
geht ein restart direkt über apache2ctl?
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
Nein, leider nicht.jojo wrote:geht ein restart direkt über apache2ctl?
Mitlerweile ist er mir komplett abgestürzt.
Kann ihn auch nicht mehr starten.
Muss ich evt. an einer anderen stelle das modul eintragen ?
[php]
# /etc/init.d/apache2ctl restart
-bash: /etc/init.d/apache2ctl: No such file or directory
# apache2ctl restart
which: no w3m in (/sbin:/usr/sbin:/usr/local/sbin:/opt/gnome/sbin:/root/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin)
which: no lynx in (/sbin:/usr/sbin:/usr/local/sbin:/opt/gnome/sbin:/root/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin)
Syntax error on line 10 of /etc/apache2/conf.d/otrs.conf:
Invalid command 'Perlrequire', perhaps mis-spelled or defined by a module not included in the server configuration
# /etc/init.d/apache2 start
Warning: found stale pidfile (unclean shutdown?)
Starting httpd2 (prefork) Syntax error on line 10 of /etc/apache2/conf.d/otrs.conf:
Invalid command 'Perlrequire', perhaps mis-spelled or defined by a module not included in the server configuration
The command line was:
/usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf
failed
[/php]
hab jetzt leider kein SuSe hier um nachzuschauen.
Normalerweise muss das Modul in /etc/sysconfig/apache2 eingetragen werden und anschliessend SuSeConfig ausgeführt werden.
Normalerweise muss das Modul in /etc/sysconfig/apache2 eingetragen werden und anschliessend SuSeConfig ausgeführt werden.
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
Nochmal guten Abend zur späten Stunde
Auf welcher höhe was genau ?
Danke
Bin jetzt leider nicht so der Linux-Crackjojo wrote:Normalerweise muss das Modul in /etc/sysconfig/apache2 eingetragen
Auf welcher höhe was genau ?
Danke
Code: Select all
# joe /etc/sysconfig/apache2
Processing '/etc/joe/joerc'... done.
IW /etc/sysconfig/apache2 Row 1 Col 1 3:11 Ctrl-K H for help
## Path: Network/WWW/Apache2
## Description: Configuration for Apache 2
## Type: string
## Default: ""
## ServiceRestart: apache2
#
# Here you can name files, separated by spaces, that should be Include'd from
# httpd.conf.
#
# This allows you to add e.g. VirtualHost statements without touching
# /etc/httpd/httpd.conf itself, which makes upgrading easier.
#
APACHE_CONF_INCLUDE_FILES=""
## Type: string
## Default: ""
## ServiceRestart: apache2
#
# Here you can name directories, separated by spaces, that should be Include'd
# from httpd.conf.
#
# All files contained in these directories will be recursively included by apac
** Joe's Own Editor v3.3 ** (iso-8859-15) ** Copyright (C) 2005 **
IW /etc/sysconfig/apache2 Row 1 Col 1 3:11 Ctrl-K H for help
## Path: Network/WWW/Apache2
## Description: Configuration for Apache 2
## Type: string
## Default: ""
## ServiceRestart: apache2
#
# Here you can name files, separated by spaces, that should be Include'd from
# httpd.conf.
#
# This allows you to add e.g. VirtualHost statements without touching
# /etc/httpd/httpd.conf itself, which makes upgrading easier.
#
APACHE_CONF_INCLUDE_FILES=""
## Type: string
## Default: ""
## ServiceRestart: apache2
#
# Here you can name directories, separated by spaces, that should be Include'd
# from httpd.conf.
#
# All files contained in these directories will be recursively included by apache.
# If a pattern like *.conf is appended, apache will use it.
#
# Examples: "/etc/apache2/my_conf/"
# "/etc/apache2/virtual_hosts/*.conf"
# "local/*.conf /srv/www/virtual/"
#
APACHE_CONF_INCLUDE_DIRS=""
## Type: string
## Default: "access actions alias auth auth_dbm autoindex cgi dir env expires include log_config mime negotiation setenvif ssl suexec userdir php4"
## ServiceRestart: apache2
#
# [It might look silly to not simply edit httpd.conf for the LoadModule statements.
# However, since the LoadModule statements might need an absolute path to the modules,
# switching between MPMs can be quite a hassle. It's easier to just give the names here.]
#
# * list of all modules shipped with the base distribution:
#
# access actions alias asis auth auth_anon auth_dbm auth_digest auth_ldap
# autoindex cache case_filter case_filter_in cern_meta cgi charset_lite
# dav dav_fs deflate dir disk_cache dumpio echo env expires ext_filter
# file_cache headers imap include info ldap log_config log_forensic logio
# mem_cache mime mime_magic negotiation proxy proxy_connect proxy_ftp
# proxy_http rewrite setenvif speling ssl status suexec unique_id userdir
# usertrack vhost_alias
#
# see http://httpd.apache.org/docs-2.0/mod/ !
#
# * It pays to use IfDefine statements... like
# <IfModule mod_xyz.c>
# ....
# </IfModule>
#
# * In the APACHE_MODULES variable, you can use mod_xyz or just xyz syntax.
# You may also name an absolute path if you like.
#
# * NOTE ON MOD_SSL: before you can enable this module, you need a server certificate.
-
- Znuny guru
- Posts: 2189
- Joined: 08 Dec 2005, 17:01
- Znuny Version: 5.0.x
- Real Name: André Bauer
- Company: Magix Software GmbH
- Location: Dresden
- Contact:
OTRS funktioniert definitiv unter Open Suse 10.2.
Hatte ich selbst schon laufen...
Check mal deien Apache config:
http://httpd.apache.org/docs/2.0/
Hatte ich selbst schon laufen...
Check mal deien Apache config:
http://httpd.apache.org/docs/2.0/
Prod: Ubuntu Server 16.04 / Zammad 1.2
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
Apache sieht alles okay aus.monotek wrote:OTRS funktioniert definitiv unter Open Suse 10.2.
Hatte ich selbst schon laufen...
Wenn es wirklich an der mod perl liegt, müsste ich nur wissen, wo ich das in der geposten datei zwei beiträge weiter oben eintragen soll.
Die automatische installationsrotine funktioniert hier jedenfalls nicht (Apache stüzt komplett ab)
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
-
- Znuny guru
- Posts: 2189
- Joined: 08 Dec 2005, 17:01
- Znuny Version: 5.0.x
- Real Name: André Bauer
- Company: Magix Software GmbH
- Location: Dresden
- Contact:
Ich hatte doch schon geschrieben, dass es sogar problemlos funktioniert.
Ich habe für die Installation mittels RPM damals gerade mal 5 Minuten gebraucht.
Es sind keinerlei Problem aufgetreten.
Ich habe für die Installation mittels RPM damals gerade mal 5 Minuten gebraucht.
Es sind keinerlei Problem aufgetreten.
Prod: Ubuntu Server 16.04 / Zammad 1.2
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
Hallo monotek,monotek wrote:Ich hatte doch schon geschrieben, dass es sogar problemlos funktioniert.
Ich habe für die Installation mittels RPM damals gerade mal 5 Minuten gebraucht.
Es sind keinerlei Problem aufgetreten.
es freut mich, dass es bei dir ohne Probleme funktioniert hat.
Auch ich habe es mittels RPM installiert, jedoch klappt es bei mir in keinster weise Problemlos.
Vieleicht hast du ja einen Tipp für mich was ich falsch gemacht habe.
Die kompletten installationslogs und Fehlermeldungen findest du in diesem Thema.
Danke für deine und Eure Mithilfe !
-
- Znuny guru
- Posts: 2189
- Joined: 08 Dec 2005, 17:01
- Znuny Version: 5.0.x
- Real Name: André Bauer
- Company: Magix Software GmbH
- Location: Dresden
- Contact:
Imho ist MOD_PERL nicht installiert.
Außerdem scheint noch "lynx" und w3m" (beides HTML Browser auf der Konsole) zu fehlen, obwohl mir unklar ist woher die Meldung kommt und warum die benötigt werden sollten.
Außerdem scheint noch "lynx" und w3m" (beides HTML Browser auf der Konsole) zu fehlen, obwohl mir unklar ist woher die Meldung kommt und warum die benötigt werden sollten.
Prod: Ubuntu Server 16.04 / Zammad 1.2
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
Die magische Zeile in der /etc/sysconfig/apache2 am Ende perl eintragen
APACHE_MODULES="access actions alias auth auth_dbm autoindex cgi dir env expires include log_config mime negotiation setenvif ssl suexec userdir php4 php5 rewrite perl"
Danach rcapache2 restart und nicht rcapache
jupiter:/etc/sysconfig # rcapache2 restart
Syntax OK
Starting httpd2 (prefork) done
jupiter:/etc/sysconfig #
APACHE_MODULES="access actions alias auth auth_dbm autoindex cgi dir env expires include log_config mime negotiation setenvif ssl suexec userdir php4 php5 rewrite perl"
Danach rcapache2 restart und nicht rcapache
jupiter:/etc/sysconfig # rcapache2 restart
Syntax OK
Starting httpd2 (prefork) done
jupiter:/etc/sysconfig #
FIRMA:SLES10, OTRS 4.0.14, Oracle 11.2.0.3.0, LDAP Auth,
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
-
- Znuny guru
- Posts: 2189
- Joined: 08 Dec 2005, 17:01
- Znuny Version: 5.0.x
- Real Name: André Bauer
- Company: Magix Software GmbH
- Location: Dresden
- Contact:
Läuft der MysQL Server auch?
Ich schätze mal nein.
Das Passwort wird in der in der Datenbank selbst gespeichert und kann aus einer Datei nicht ausgelesen werden. Die Speicherung sollte außerdem auch noch verschlüsselt erfolgen, so das Du mit dem Inhalt eh nichts anfangen kannst.
Ich schätze mal nein.
Das Passwort wird in der in der Datenbank selbst gespeichert und kann aus einer Datei nicht ausgelesen werden. Die Speicherung sollte außerdem auch noch verschlüsselt erfolgen, so das Du mit dem Inhalt eh nichts anfangen kannst.
Prod: Ubuntu Server 16.04 / Zammad 1.2
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
-
- Znuny guru
- Posts: 2189
- Joined: 08 Dec 2005, 17:01
- Znuny Version: 5.0.x
- Real Name: André Bauer
- Company: Magix Software GmbH
- Location: Dresden
- Contact:
Woher soll ich das wissen? Das hast Du doch gesetzt?
Oder verwendest Du etwa noch das Standardpasswort "hot"?
Oder verwendest Du etwa noch das Standardpasswort "hot"?
Prod: Ubuntu Server 16.04 / Zammad 1.2
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
-
- Znuny guru
- Posts: 2189
- Joined: 08 Dec 2005, 17:01
- Znuny Version: 5.0.x
- Real Name: André Bauer
- Company: Magix Software GmbH
- Location: Dresden
- Contact:
Config.pm
Prod: Ubuntu Server 16.04 / Zammad 1.2
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
Perfekt - Danke !monotek wrote:Config.pm
Habe noch ein Problem mit meinem SQL Server.
Ich bekomme ihn nicht zum laufen:
Fehler:
Code: Select all
:~ # mysqladmin version -u root -p
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Leider helfen mir die Tipps auch nicht wirklich weiter...
Hat hier jmd eine Idee ?
Eingesetzte Software: Open SuSe 10
-
- Znuny guru
- Posts: 2189
- Joined: 08 Dec 2005, 17:01
- Znuny Version: 5.0.x
- Real Name: André Bauer
- Company: Magix Software GmbH
- Location: Dresden
- Contact:
Mach doch erstmal, was in der Fehlermeldung steht:
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Prod: Ubuntu Server 16.04 / Zammad 1.2
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
MySQL läuft nicht.monotek wrote:Mach doch erstmal, was in der Fehlermeldung steht
Code: Select all
~ # cd /var/lib/mysql/
:/var/lib/mysql # dir
total 20544
drwxr-xr-x 4 mysql mysql 4096 Mar 13 20:16 .
drwxr-xr-x 19 root root 4096 Jun 14 2006 ..
-rw-rw---- 1 mysql mysql 5242880 Feb 25 02:18 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Jun 14 2006 ib_logfile1
-rw-rw---- 1 mysql mysql 10485760 Jun 14 2006 ibdata1
drwx------ 2 mysql mysql 4096 Jun 14 2006 mysql
-rw-rw---- 1 mysql mysql 1600 Feb 25 02:18 mysqld.log
-rw-rw---- 1 mysql mysql 6 Feb 25 02:14 mysqld.pid
drwx------ 2 mysql mysql 4096 Jun 14 2006 test
-rw-r--r-- 1 mysql mysql 0 Jun 14 2006 update-stamp-4.1
-
- Znuny guru
- Posts: 2189
- Joined: 08 Dec 2005, 17:01
- Znuny Version: 5.0.x
- Real Name: André Bauer
- Company: Magix Software GmbH
- Location: Dresden
- Contact:
Und was passiert wenn Du MySQL startest?
Code: Select all
/etc/init.d/mysql start
Prod: Ubuntu Server 16.04 / Zammad 1.2
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
Das Funktioniert, aber er baut dennoch keinen Connect aufmonotek wrote:Und was passiert wenn Du MySQL startest?
Code: Select all
~ # /etc/init.d/mysql start
Starting service MySQL done
~ #
~ # mysql -uroot
ERROR 2002 %u28HY000%u29%u3a Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' %u28111%u29
~ # mysql -u root -p
Enter password%u3a *******************
ERROR 2002 %u28HY000%u29%u3a Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' %u28111%u29
~ #
Last edited by goldfisch2k on 15 Mar 2007, 14:54, edited 2 times in total.
-
- Znuny guru
- Posts: 2189
- Joined: 08 Dec 2005, 17:01
- Znuny Version: 5.0.x
- Real Name: André Bauer
- Company: Magix Software GmbH
- Location: Dresden
- Contact:
Was bringt folgender Befehl als Ausgabe?
Code: Select all
ps aux | grep -i mysql
Prod: Ubuntu Server 16.04 / Zammad 1.2
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
Das:monotek wrote:Was bringt folgender Befehl als Ausgabe?
Code: Select all
~ # ps aux | grep -i mysql
root 18381 0.0 0.0 1720 536 pts/0 S+ 15:52 0:00 grep -i mysql
-
- Znuny guru
- Posts: 2189
- Joined: 08 Dec 2005, 17:01
- Znuny Version: 5.0.x
- Real Name: André Bauer
- Company: Magix Software GmbH
- Location: Dresden
- Contact:
Dein Mysql läuft also auch nach dem Start nicht.
Was steht im mysql.log bzw syslog?
Was steht im mysql.log bzw syslog?
Prod: Ubuntu Server 16.04 / Zammad 1.2
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
Sieht irgendwie nach einem Problem mit der Rechtevergabe aus, oder?MySQL.log wrote: I mysqld.log Row 1 Col 1 4:02 Ctrl-K H for help
060614 16:57:33 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
060614 16:57:33 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060614 16:57:33 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
060614 16:57:33 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
060614 16:57:34 InnoDB: Started; log sequence number 0 0
/usr/sbin/mysqld: ready for connections.
Version: '4.1.13' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM
060614 17:00:35 [Note] /usr/sbin/mysqld: Normal shutdown
060614 17:00:35 InnoDB: Starting shutdown...
060614 17:00:36 InnoDB: Shutdown completed; log sequence number 0 43634
060614 17:00:36 [Note] /usr/sbin/mysqld: Shutdown complete
060614 17:00:36 mysqld ended
070225 02:14:45 mysqld started
070225 2:14:46 InnoDB: Started; log sequence number 0 43634
/usr/sbin/mysqld: ready for connections.
Version: '4.1.13' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM
070225 2:18:04 [Note] /usr/sbin/mysqld: Normal shutdown
070225 2:18:04 InnoDB: Starting shutdown...
070315 15:34:17 mysqld started
G/usr/sbin/mysqld: Can't read dir of '/var/lib/mysql/tmp/' (Errcode: 2)
G/usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/tmp/ibjYVQfI' (Errcode: 2)
070315 15:34:19 InnoDB: Error: unable to create temporary file; errno: 2
070315 15:34:19 [ERROR] Can't init databases
070315 15:34:19 [ERROR] Aborting
070315 15:34:19 [Note] /usr/sbin/mysqld: Shutdown complete
070315 15:34:19 mysqld ended
-
- Znuny guru
- Posts: 2189
- Joined: 08 Dec 2005, 17:01
- Znuny Version: 5.0.x
- Real Name: André Bauer
- Company: Magix Software GmbH
- Location: Dresden
- Contact:
Mach mal:
ls -al /var/lib/mysql
Prod: Ubuntu Server 16.04 / Zammad 1.2
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
Gerne:
Code: Select all
/var/lib/mysql # ls -al /var/lib/mysql
total 20540
drwxr-xr-x 4 mysql mysql 4096 Mar 15 15:34 .
drwxr-xr-x 19 root root 4096 Jun 14 2006 ..
-rw-rw---- 1 mysql mysql 5242880 Feb 25 02:18 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Jun 14 2006 ib_logfile1
-rw-rw---- 1 mysql mysql 10485760 Jun 14 2006 ibdata1
drwx------ 2 mysql mysql 4096 Jun 14 2006 mysql
srwxrwxrwx 1 mysql mysql 0 Mar 15 15:34 mysql.sock
-rw-rw---- 1 mysql mysql 2037 Mar 15 15:34 mysqld.log
drwx------ 2 mysql mysql 4096 Jun 14 2006 test
-rw-r--r-- 1 mysql mysql 0 Jun 14 2006 update-stamp-4.1
-
- Znuny guru
- Posts: 2189
- Joined: 08 Dec 2005, 17:01
- Znuny Version: 5.0.x
- Real Name: André Bauer
- Company: Magix Software GmbH
- Location: Dresden
- Contact:
Und nun noch mal folgendes:
Code: Select all
ls -al /var/lib/mysql/mysql
Prod: Ubuntu Server 16.04 / Zammad 1.2
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
Okay:
Code: Select all
# ls -al /var/lib/mysql/mysql
total 496
drwx------ 2 mysql mysql 4096 Jun 14 2006 .
drwxr-xr-x 4 mysql mysql 4096 Mar 15 15:34 ..
-rw-rw---- 1 mysql mysql 0 Jun 14 2006 columns_priv.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 14 2006 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8820 Jun 14 2006 columns_priv.frm
-rw-rw---- 1 mysql mysql 866 Jun 14 2006 db.MYD
-rw-rw---- 1 mysql mysql 4096 Jun 14 2006 db.MYI
-rw-rw---- 1 mysql mysql 9178 Jun 14 2006 db.frm
-rw-rw---- 1 mysql mysql 0 Jun 14 2006 func.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 14 2006 func.MYI
-rw-rw---- 1 mysql mysql 8665 Jun 14 2006 func.frm
-rw-rw---- 1 mysql mysql 864 Jun 14 2006 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 Jun 14 2006 help_category.MYI
-rw-rw---- 1 mysql mysql 8700 Jun 14 2006 help_category.frm
-rw-rw---- 1 mysql mysql 6780 Jun 14 2006 help_keyword.MYD
-rw-rw---- 1 mysql mysql 11264 Jun 14 2006 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8612 Jun 14 2006 help_keyword.frm
-rw-rw---- 1 mysql mysql 4932 Jun 14 2006 help_relation.MYD
-rw-rw---- 1 mysql mysql 9216 Jun 14 2006 help_relation.MYI
-rw-rw---- 1 mysql mysql 8630 Jun 14 2006 help_relation.frm
-rw-rw---- 1 mysql mysql 188944 Jun 14 2006 help_topic.MYD
-rw-rw---- 1 mysql mysql 15360 Jun 14 2006 help_topic.MYI
-rw-rw---- 1 mysql mysql 8770 Jun 14 2006 help_topic.frm
-rw-rw---- 1 mysql mysql 0 Jun 14 2006 host.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 14 2006 host.MYI
-rw-rw---- 1 mysql mysql 9148 Jun 14 2006 host.frm
-rw-rw---- 1 mysql mysql 0 Jun 14 2006 tables_priv.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 14 2006 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8925 Jun 14 2006 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 Jun 14 2006 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 14 2006 time_zone.MYI
-rw-rw---- 1 mysql mysql 8636 Jun 14 2006 time_zone.frm
-rw-rw---- 1 mysql mysql 0 Jun 14 2006 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 14 2006 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 8624 Jun 14 2006 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 Jun 14 2006 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 14 2006 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8606 Jun 14 2006 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 Jun 14 2006 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 14 2006 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8686 Jun 14 2006 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 Jun 14 2006 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 14 2006 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 8748 Jun 14 2006 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 84 Jun 14 2006 user.MYD
-rw-rw---- 1 mysql mysql 2048 Jun 14 2006 user.MYI
-rw-rw---- 1 mysql mysql 9992 Jun 14 2006 user.frm
-
- Znuny newbie
- Posts: 40
- Joined: 24 Feb 2007, 23:49
Normalerweise wird das Startscript in das entsprechende Verzeichnis verlinkt, mit Suse geht es auch "einfacher": http://susefaq.sourceforge.net/faq/services.html
Ein Cronjob ist sicherlich nicht dafür geeignet, MySQL sollte an sich stabil laufen...
Ein Cronjob ist sicherlich nicht dafür geeignet, MySQL sollte an sich stabil laufen...
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com