Weder mit XAMPP noch mit MAMP lässt sich MySQL Starten

janosch

Aktives Mitglied
Thread Starter
Dabei seit
24.10.2003
Beiträge
1.387
Reaktionspunkte
9
Hallo zusammen,

ich wollte mir heute eine MySQL und Apache Umgebung installieren. Dazu habe ich auf XAMP und MAMP zurückgegriffen. Leider kann ich den bei den beiden Paketen mitgelieferten MySQL Server nicht starten. MySQL schreibt ins Log immer rein, dass *.sock Datei nicht stimmt bzw. schon ein MySQL Server läuft. Dies kann aber nicht sein, da ich den bei OS X server mitgelieferten MySQL Server nur kurz gestartet habe und danach gleich wieder beendet. Auch habe ich versucht den mitgelieferten Server zu löschen inkl. aller Datei die ich gefunden habe jedoch ohne Erfolg.

P.S. Als OS benutze ich Mac OS X Server 10.6.5. Der Mysql Server läst sich ohne Probleme starten.

Kann mir hier Jemand weiterhelfen?

VG, Jan
 
Zuletzt bearbeitet:
Hm, ich bin mir gerade unsicher, aber afaik teilt sich Skype Ports mit XAMPP, evtl liegts daran. Wenn nicht, versuch mal andere Programme zu beenden, vermutlich liegts an sowas.

Edit:
Oder haeng mal das zu erzeugende File output.txt an:

Code:
(netstat -an | grep -i sql && echo '---'; netstat -l | grep 3306 && echo '---'; lsof -i4 -P | grep -i sql && echo '---'; ps aux | grep -i sql) > output.txt
 
Zuletzt bearbeitet:
Hallo,

hier das output.txt file:

admin 2453 0.0 0.0 2425524 96 s000 R+ 1:14AM 0:00.00 grep -i sql

ich habe auch schon einen Portscan gemacht mit folgenden Ergebnis:
„Portscan“ wurde gestartet …

Port Scanning host: 192.168.201.16

Open TCP Port: 22 ssh
Open TCP Port: 53 domain
Open TCP Port: 88 kerberos
Open TCP Port: 106 3com-tsmux
Open TCP Port: 139 netbios-ssn
Open TCP Port: 311 asip-webadmin
Open TCP Port: 389 ldap
Open TCP Port: 445 microsoft-ds
Open TCP Port: 548 afpovertcp
Open TCP Port: 625 dec_dlm
Open TCP Port: 749 kerberos-adm
Open TCP Port: 2336 appleugcontrol
Open TCP Port: 3031 eppc
Open TCP Port: 3659 apple-sasl
Open TCP Port: 5109
Open TCP Port: 5900 vnc-server
„Portscan“ wurde beendet …

Es benutzt kein Programm den Standard MySQL Port bzw. den, den ich angegeben habe.

GRuß, Jan
 
Hm, derweil finde ich dein Problem ziemlich lustig ^^

In den Logs steht gar nix anderes? Gibt XAMPP selbst keinen Fehler aus? Schonmal versucht MySQL ohne XAMPP zu starten? Haeng zur Sicherheit mal bitte die my.cnf an (Standardmaessig in */XAMPP/etc/my.cnf).
 
Ja, ds ist ein witziges Problem :D

XAMPP: my.cnf
Code:
# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /Applications/xampp/xamppfiles/var/mysql) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password	= your_password
port		= 3306
socket		= /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port		= 3306
socket		= /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
tmpdir = /Applications/XAMPP/xamppfiles/temp/

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
# 
#skip-networking
server-id	= 1

# Uncomment the following if you want to log updates
#log-bin=mysql-bin

# Uncomment the following if you are NOT using BDB tables
#skip-bdb

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /Applications/XAMPP/xamppfiles/var/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /Applications/XAMPP/xamppfiles/var/mysql/
#innodb_log_arch_dir = /Applications/XAMPP/xamppfiles/var/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

XAMPP: error_log
Code:
[Mon Dec 27 01:32:08 2010] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Mon Dec 27 01:32:10 2010] [notice] Digest: generating secret for digest authentication ...
[Mon Dec 27 01:32:10 2010] [notice] Digest: done
[Mon Dec 27 01:32:10 2010] [error] (22)Invalid argument: Couldn't bind unix domain socket /Applications/XAMPP/xamppfiles/logs/cgisock.2772
[Mon Dec 27 01:32:11 2010] [notice] Apache/2.2.14 (Unix) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l PHP/5.3.1 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
[Mon Dec 27 01:32:11 2010] [crit] cgid daemon failed to initialize

MAMP: mysql_error_log.err
Code:
101227  1:40:00 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
101227  1:40:00 [Warning] Setting lower_case_table_names=2 because file system for /Library/Application Support/appsolute/MAMP PRO/db/mysql/ is case insensitive
101227  1:40:00 [Note] Plugin 'FEDERATED' is disabled.
101227  1:40:00 [Note] Plugin 'ndbcluster' is disabled.
101227  1:40:00  InnoDB: Started; log sequence number 0 44233
101227  1:40:00 [ERROR] Can't start server : Bind on unix socket: Invalid argument
101227  1:40:00 [ERROR] Do you already have another mysqld server running on socket: /Applications/MAMP/tmp/mysql/mysql.sock ?
101227  1:40:00 [ERROR] Aborting

101227  1:40:00  InnoDB: Starting shutdown...
101227  1:40:05  InnoDB: Shutdown completed; log sequence number 0 44233
101227  1:40:05 [Note] /Applications/MAMP/Library/libexec/mysqld: Shutdown complete

101227 01:40:06 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
 
Zuletzt bearbeitet:
MySQL macht Probleme? Laut deinem Log macht naemlich Apache Probleme.

Rechteproblem? ls -ald /Applications/XAMPP/xamppfiles/logs

Zeig mal deine httpd.conf
 
XAMPP: httpd.conf

Code:
ServerRoot "/Applications/XAMPP/xamppfiles"

Listen 80

LoadModule authn_file_module modules/mod_authn_file.so
LoadModule authn_dbm_module modules/mod_authn_dbm.so
LoadModule authn_anon_module modules/mod_authn_anon.so
LoadModule authn_dbd_module modules/mod_authn_dbd.so
LoadModule authn_default_module modules/mod_authn_default.so
LoadModule authz_host_module modules/mod_authz_host.so
LoadModule authz_groupfile_module modules/mod_authz_groupfile.so
LoadModule authz_user_module modules/mod_authz_user.so
LoadModule authz_dbm_module modules/mod_authz_dbm.so
LoadModule authz_owner_module modules/mod_authz_owner.so
LoadModule authnz_ldap_module modules/mod_authnz_ldap.so
LoadModule authz_default_module modules/mod_authz_default.so
LoadModule auth_basic_module modules/mod_auth_basic.so
LoadModule auth_digest_module modules/mod_auth_digest.so
LoadModule file_cache_module modules/mod_file_cache.so
LoadModule cache_module modules/mod_cache.so
LoadModule disk_cache_module modules/mod_disk_cache.so
LoadModule mem_cache_module modules/mod_mem_cache.so
LoadModule dbd_module modules/mod_dbd.so
LoadModule bucketeer_module modules/mod_bucketeer.so
LoadModule dumpio_module modules/mod_dumpio.so
LoadModule echo_module modules/mod_echo.so
LoadModule case_filter_module modules/mod_case_filter.so
LoadModule case_filter_in_module modules/mod_case_filter_in.so
LoadModule ext_filter_module modules/mod_ext_filter.so
LoadModule include_module modules/mod_include.so
LoadModule filter_module modules/mod_filter.so
LoadModule charset_lite_module modules/mod_charset_lite.so
LoadModule deflate_module modules/mod_deflate.so
LoadModule ldap_module modules/mod_ldap.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule logio_module modules/mod_logio.so
LoadModule env_module modules/mod_env.so
LoadModule mime_magic_module modules/mod_mime_magic.so
LoadModule cern_meta_module modules/mod_cern_meta.so
LoadModule expires_module modules/mod_expires.so
LoadModule headers_module modules/mod_headers.so
LoadModule ident_module modules/mod_ident.so
LoadModule usertrack_module modules/mod_usertrack.so
LoadModule unique_id_module modules/mod_unique_id.so
LoadModule setenvif_module modules/mod_setenvif.so
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_connect_module modules/mod_proxy_connect.so
LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
LoadModule proxy_http_module modules/mod_proxy_http.so
LoadModule proxy_ajp_module modules/mod_proxy_ajp.so
LoadModule proxy_balancer_module modules/mod_proxy_balancer.so
LoadModule mime_module modules/mod_mime.so
LoadModule dav_module modules/mod_dav.so
LoadModule status_module modules/mod_status.so
LoadModule autoindex_module modules/mod_autoindex.so
LoadModule asis_module modules/mod_asis.so
LoadModule info_module modules/mod_info.so
LoadModule suexec_module modules/mod_suexec.so
LoadModule cgi_module modules/mod_cgi.so
LoadModule cgid_module modules/mod_cgid.so
LoadModule dav_fs_module modules/mod_dav_fs.so
LoadModule vhost_alias_module modules/mod_vhost_alias.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule dir_module modules/mod_dir.so
LoadModule imagemap_module modules/mod_imagemap.so
LoadModule actions_module modules/mod_actions.so
LoadModule speling_module modules/mod_speling.so
LoadModule userdir_module modules/mod_userdir.so
LoadModule alias_module modules/mod_alias.so
LoadModule rewrite_module modules/mod_rewrite.so

LoadModule ssl_module modules/mod_ssl.so

<IfDefine JUSTTOMAKEAPXSHAPPY>
LoadModule php4_module        modules/libphp4.so
LoadModule php5_module        modules/libphp5.so
</IfDefine>

<IfModule !mpm_winnt_module>
<IfModule !mpm_netware_module>

User nobody
Group nogroup
</IfModule>
</IfModule>

ServerAdmin you@example.com

ServerName localhost

DocumentRoot "/Applications/XAMPP/xamppfiles/htdocs"


<Directory />
    Options FollowSymLinks
    AllowOverride None
    #XAMPP
    #Order deny,allow
    #Deny from all
</Directory>


<Directory "/Applications/XAMPP/xamppfiles/htdocs">

    #   Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews

    Options Indexes FollowSymLinks ExecCGI Includes


    AllowOverride All

    Order allow,deny
    Allow from all

</Directory>


<IfModule dir_module>
    DirectoryIndex index.html index.php index.htmls index.htm
</IfModule>


<FilesMatch "^\.ht">
    Order allow,deny
    Deny from all
</FilesMatch>


ErrorLog logs/error_log


LogLevel warn

<IfModule log_config_module>

    LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
    LogFormat "%h %l %u %t \"%r\" %>s %b" common

    <IfModule logio_module>
      # You need to enable mod_logio.c to use %I and %O
      LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio
    </IfModule>


    CustomLog logs/access_log common


</IfModule>

<IfModule alias_module>
    #
    # Redirect: Allows you to tell clients about documents that used to 
    # exist in your server's namespace, but do not anymore. The client 
    # will make a new request for the document at its new location.
    # Example:
    # Redirect permanent /foo http://www.example.com/bar

    #
    # Alias: Maps web paths into filesystem paths and is used to
    # access content that does not live under the DocumentRoot.
    # Example:

    # directives as to Alias.
    #
    ScriptAlias /cgi-bin/ "/Applications/XAMPP/xamppfiles/cgi-bin/"

</IfModule>

<IfModule cgid_module>
    #
    # ScriptSock: On threaded servers, designate the path to the UNIX
    # socket used to communicate with the CGI daemon of mod_cgid.
    #
    #Scriptsock logs/cgisock
</IfModule>

#
# "/Applications/xampp/xamppfiles/cgi-bin" should be changed to whatever your ScriptAliased
# CGI directory exists, if you have that configured.
#
<Directory "/Applications/XAMPP/xamppfiles/phpmyadmin">
    AllowOverride None
    Options None 
    Order allow,deny
    Allow from all
</Directory>

#

# keep browsers from trying to display binary files as though they are
# text.
#
DefaultType text/plain

<IfModule mime_module>
    #
    # TypesConfig points to the file containing the list of mappings from
    # filename extension to MIME-type.
    #
    TypesConfig etc/mime.types

    #
    # AddType allows you to add to or override the MIME configuration
    # file specified in TypesConfig for specific file types.
    #
    #AddType application/x-gzip .tgz
    #
    # AddEncoding allows you to have certain browsers uncompress
    # information on the fly. Note: Not all browsers support this.
    #
    #AddEncoding x-compress .Z
    #AddEncoding x-gzip .gz .tgz
    #
    # If the AddEncoding directives above are commented-out, then you
    # probably should define those extensions to indicate media types:
    #
    AddType application/x-compress .Z
    AddType application/x-gzip .gz .tgz

    #
 
    # (You will also need to add "ExecCGI" to the "Options" directive.)
    #
    #AddHandler cgi-script .cgi
    AddHandler cgi-script .cgi .pl

    # For files that include their own HTTP headers:
    #AddHandler send-as-is asis

    # For server-parsed imagemap files:
    #AddHandler imap-file map

    # For type maps (negotiated resources):
    #AddHandler type-map var

    #
    # Filters allow you to process content before it is sent to the client.
    #
    # To parse .shtml files for server-side includes (SSI):
    # (You will also need to add "Includes" to the "Options" directive.)
    #
    AddType text/html .shtml
    AddOutputFilter INCLUDES .shtml
</IfModule>

#

#
#MIMEMagicFile etc/magic

#
# Customizable error responses come in three flavors:
# 1) plain text 2) local redirects 3) external redirects
#
# Some examples:
#ErrorDocument 500 "The server made a boo boo."
#ErrorDocument 404 /missing.html
#ErrorDocument 404 "/cgi-bin/missing_handler.pl"
#ErrorDocument 402 http://www.example.com/subscription_info.html
#

#

#
EnableMMAP off
EnableSendfile off



# Server-pool management (MPM specific)
#Include /Applications/XAMPP/etc/extra/httpd-mpm.conf

# Multi-language error messages
Include /Applications/XAMPP/etc/extra/httpd-multilang-errordoc.conf

# Fancy directory listings
#Include /Applications/XAMPP/etc/extra/httpd-autoindex.conf

# Language settings
#Include /Applications/XAMPP/etc/extra/httpd-languages.conf

# User home directories
Include /Applications/XAMPP/etc/extra/httpd-userdir.conf

# Real-time info on requests and configuration
#Include /Applications/XAMPP/etc/extra/httpd-info.conf

# Virtual hosts
#Include /Applications/XAMPP/etc/extra/httpd-vhosts.conf

# Local access to the Apache HTTP Server Manual
#Include /Applications/XAMPP/etc/extra/httpd-manual.conf

# Distributed authoring and versioning (WebDAV)
#Include /Applications/XAMPP/etc/extra/httpd-dav.conf

# Various default settings
#Include /Applications/XAMPP/etc/extra/httpd-default.conf

# Secure (SSL/TLS) connections
#Include /Applications/XAMPP/etc/extra/httpd-ssl.conf

<IfModule ssl_module>
    <IfDefine SSL>
        Include etc/extra/httpd-ssl.conf
    </IfDefine>
</IfModule>


#
# Note: The following must must be present to support
#       starting without SSL on platforms with no /dev/random equivalent
#       but a statically compiled-in mod_ssl.
#
<IfModule ssl_module>
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
</IfModule>

#XAMPP
Include etc/extra/httpd-xampp.conf

Beim starten von MySQL bekomme ich folgenden Fehler angezeigt (siehe Bild im Anhang)

screenshot.jpg

Apache startet ohne Probleme.

P.S. Habe einpaar Kommentare gelöscht, sonst hätte es hier nicht reingepasst
 
Zuletzt bearbeitet:
Hm, entweder ich bin verbloedet, oder da stimmt was net. Denn in der apache config ist cgid deaktiviert, der Fehler aus dem error-Log schreit aber deswegen.

Nevertheless ... was sagen ls -ald /Applications/XAMPP/xamppfiles/var/ und ls -ald /Applications/XAMPP/xamppfiles/logs?
 
Ausgabe von: ls -ald /Applications/XAMPP/xamppfiles/var/

Code:
drwxrwxrwx@ 5 root  admin  170 Dec 27 02:55 /Applications/XAMPP/xamppfiles/var/

Ausgabe von: ls -ald /Applications/XAMPP/xamppfiles/logs

Code:
drwxrwxrwx@ 7 root  admin  238 Dec 27 02:50 /Applications/XAMPP/xamppfiles/logs

Also nix besonderes :D
 
Ich verstehs nich. Wuerd mir gern das Problem genauer per TeamViewer oder SSH ansehen. Kontakt-Daten findest in meinem Profil.
 
Zurück
Oben Unten