ispCP - Board - Support
[ERLEDIGT] Mysql root login - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega International Area (/forum-22.html)
+--- Forum: German Corner (/forum-26.html)
+---- Forum: Archiv (/forum-54.html)
+---- Thread: [ERLEDIGT] Mysql root login (/thread-6475.html)

Pages: 1 2


[ERLEDIGT] Mysql root login - mekades - 04-21-2009 09:13 PM

Hi !

habe folgendes Problem, vielleicht kann mir jemand helfen;

habe gestern auf meinem Server "Dabian lenny 32 installiert" und anschließend ispCP 1.0.0 OMEGA, alles schien Problemlos zu funktionieren, heute erstelle ich einen user und dafür ein FTP account, versuche mit dem Client einzuloggen=> 530 login incorrect, ich habe die Daten geprüft und die stimmen, dann habe ich mir gedacht es liegt vielleicht an meinem Datenbank, vielleicht kann er die login daten aus der Datenbank nicht lesen oder die Daten werden nicht korrekt gespeichert, um das mal nachzuprüfen gehe ich zu phpMyAdmin und sehe dass ich mich mit meinem root Login nicht einloggen kann, und jetzt habe ich das root Passwort nochmal per SSH geändert aber pma lässt mich immer noch nicht rein. :S

habe jetzt keine Ahnung was da nicht stimmt, hat vielleicht jemand eine Idee ?


RE: Mysql root login - joximu - 04-21-2009 10:52 PM

Vielleicht ein (config-)Problem in pma?

Ob die MySQL Zugangsdaten stimmen, würde ich auf der Shell prüfen (mysql -u ... -p) - wenn das ok ist, dann nachste Schicht - pma, wenn der nicht richtig konfiguriert ist, dann kann es nicht gehen...

Gruss J


RE: Mysql root login - mekades - 04-21-2009 11:11 PM

ok, mysql hab ich hinbekommen es stimmt jetzt alles, nur bei FTP habe ich immer noch 530 login incorrect, obwohl die logindaten stimmen.


RE: Mysql root login - BeNe - 04-21-2009 11:17 PM

Starte bitte mal deinen Proftpd im Debug Modus.
Hatten wir hier schon einige mal im Forum...

Greez BeNe


RE: Mysql root login - joximu - 04-21-2009 11:34 PM

vorher noch prüfen, ob du nicht zu denen gehörst, die kein proftpd.mysql installiert hatten... (kam auch schon öfters...)

Gruss J


RE: Mysql root login - mekades - 04-22-2009 06:57 PM

also ich hab eigentlich die ganze liste installiert, was im doc/debian/debian-packages-lenny stand
proftpd-mod-mysql is already the newest version.


RE: Mysql root login - ephigenie - 04-22-2009 07:00 PM

und ? was sagt der Debug modus ?


RE: Mysql root login - mekades - 04-22-2009 08:03 PM

Code:
admin:~# proftpd -n -d5
- mod_tls/2.1.2: using OpenSSL 0.9.8g 19 Oct 2007
- DenyFilter: compiling deny regex '\*.*/'
- <IfModule>: using 'mod_dynmasq.c' section at line 54
- <IfModule>: using 'mod_quotatab.c' section at line 91
- <IfModule>: skipping 'mod_ratio.c' section at line 95
- <IfModule>: using 'mod_delay.c' section at line 103
- <IfModule>: using 'mod_ctrls.c' section at line 107
- <IfModule>: using 'mod_ctrls_admin.c' section at line 115
admin.shamata.at -
admin.shamata.at - Config for Debian:
admin.shamata.at - IdentLookups
admin.shamata.at - DeferWelcome
admin.shamata.at - DefaultServer
admin.shamata.at - ShowSymlinks
admin.shamata.at - TimeoutNoTransfer
admin.shamata.at - TimeoutStalled
admin.shamata.at - TimeoutIdle
admin.shamata.at - DisplayLogin
admin.shamata.at - DisplayChdir
admin.shamata.at - ListOptions
admin.shamata.at - DenyFilter
admin.shamata.at - UserID
admin.shamata.at - UserName
admin.shamata.at - GroupID
admin.shamata.at - GroupName
admin.shamata.at - Umask
admin.shamata.at - DirUmask
admin.shamata.at - AllowOverwrite
admin.shamata.at - TransferLog
admin.shamata.at - QuotaEngine
admin.shamata.at - DelayEngine
admin.shamata.at - mod_lang/0.8: binding to text domain 'proftpd' using locale path '/usr/share/locale'
admin.shamata.at - ProFTPD 1.3.1 (stable) (built Fri Feb 27 20:37:52 UTC 2009) standalone mode STARTUP
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - FTP session requested from unknown class
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - connected - local  : ::ffff:78.46.98.226:21
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - connected - remote : ::ffff:93.82.195.34:50035
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - FTP session opened.
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'USER ftp@shamata.at' to mod_rewrite
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'USER ftp@shamata.at' to mod_tls
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'USER ftp@shamata.at' to mod_core
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'USER ftp@shamata.at' to mod_core
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'USER ftp@shamata.at' to mod_delay
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'USER ftp@shamata.at' to mod_auth
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching CMD command 'USER ftp@shamata.at' to mod_auth
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - no supplemental groups found for user 'ftp@shamata.at'
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching POST_CMD command 'USER ftp@shamata.at' to mod_delay
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching LOG_CMD command 'USER ftp@shamata.at' to mod_log
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_tls
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap2
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_ban
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_radius
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_delay
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching CMD command 'PASS (hidden)' to mod_auth
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - no supplemental groups found for user 'ftp@shamata.at'
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - no such user 'ftp@shamata.at'
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - USER ftp@shamata.at: no such user found from ::ffff:93.82.195.34 [::ffff:93.82.195.34] to ::ffff:78.46.98.226:21
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_delay
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth
admin.shamata.at (::ffff:93.82.195.34[::ffff:93.82.195.34]) - FTP session closed.



RE: Mysql root login - BeNe - 04-22-2009 09:12 PM

Ja, ich sehe da kein mod_sql bzw. mod_sql_mysql. Rolleyes
Poste bitte mal deine proftpd Config:
Code:
/etc/proftpd/proftpd.conf
Mal checken ob die auch von uns ist.

Greez BeNe


RE: Mysql root login - mekades - 04-22-2009 09:43 PM

Code:
#
# /etc/proftpd/proftpd.conf -- This is a basic ProFTPD configuration file.
# To really apply changes reload proftpd after modifications.
#

# Includes DSO modules
Include /etc/proftpd/modules.conf

# Set off to disable IPv6 support which is annoying on IPv4 only boxes.
UseIPv6                on
# If set on you can experience a longer connection delay in many cases.
IdentLookups            off

ServerName            "Debian"
ServerType            standalone
DeferWelcome            off

MultilineRFC2228        on
DefaultServer            on
ShowSymlinks            on

TimeoutNoTransfer        600
TimeoutStalled            600
TimeoutIdle            1200

DisplayLogin                    welcome.msg
DisplayChdir                   .message true
ListOptions                    "-l"

DenyFilter            \*.*/

# Use this to jail all users in their homes
# DefaultRoot            ~

# Users require a valid shell listed in /etc/shells to login.
# Use this directive to release that constrain.
# RequireValidShell        off

# Port 21 is the standard FTP port.
Port                21

# In some cases you have to specify passive ports range to by-pass
# firewall limitations. Ephemeral ports can be used for that, but
# feel free to use a more narrow range.
# PassivePorts                  49152 65534

# If your host was NATted, this option is useful in order to
# allow passive tranfers to work. You have to use your public
# address and opening the passive ports used on your firewall as well.
# MasqueradeAddress        1.2.3.4

# This is useful for masquerading address with dynamic IPs:
# refresh any configured MasqueradeAddress directives every 8 hours
<IfModule mod_dynmasq.c>
# DynMasqRefresh 28800
</IfModule>

# To prevent DoS attacks, set the maximum number of child processes
# to 30.  If you need to allow more than 30 concurrent connections
# at once, simply increase this value.  Note that this ONLY works
# in standalone mode, in inetd mode you should use an inetd server
# that allows you to limit maximum number of processes per service
# (such as xinetd)
MaxInstances            30

# Set the user and group that the server normally runs at.
User                proftpd
Group                nogroup

# Umask 022 is a good standard umask to prevent new files and dirs
# (second parm) from being group and world writable.
Umask                022  022
# Normally, we want files to be overwriteable.
AllowOverwrite            on

# Uncomment this if you are using NIS or LDAP via NSS to retrieve passwords:
# PersistentPasswd        off

# This is required to use both PAM-based authentication and local passwords
# AuthOrder            mod_auth_pam.c* mod_auth_unix.c

# Be warned: use of this directive impacts CPU average load!
# Uncomment this if you like to see progress and transfer rate with ftpwho
# in downloads. That is not needed for uploads rates.
#
# UseSendFile            off

TransferLog /var/log/proftpd/xferlog
SystemLog   /var/log/proftpd/proftpd.log

<IfModule mod_quotatab.c>
QuotaEngine off
</IfModule>

<IfModule mod_ratio.c>
Ratios off
</IfModule>


# Delay engine reduces impact of the so-called Timing Attack described in
# http://security.lss.hr/index.php?page=details&ID=LSS-2004-10-02
# It is on by default.
<IfModule mod_delay.c>
DelayEngine on
</IfModule>

<IfModule mod_ctrls.c>
ControlsEngine        off
ControlsMaxClients    2
ControlsLog           /var/log/proftpd/controls.log
ControlsInterval      5
ControlsSocket        /var/run/proftpd/proftpd.sock
</IfModule>

<IfModule mod_ctrls_admin.c>
AdminControlsEngine off
</IfModule>

#
# Alternative authentication frameworks
#
#Include /etc/proftpd/ldap.conf
#Include /etc/proftpd/sql.conf

#
# This is used for FTPS connections
#
#Include /etc/proftpd/tls.conf

# A basic anonymous configuration, no upload directories.

# <Anonymous ~ftp>
#   User                ftp
#   Group                nogroup
#   # We want clients to be able to login with "anonymous" as well as "ftp"
#   UserAlias            anonymous ftp
#   # Cosmetic changes, all files belongs to ftp user
#   DirFakeUser    on ftp
#   DirFakeGroup on ftp
#
#   RequireValidShell        off
#
#   # Limit the maximum number of anonymous logins
#   MaxClients            10
#
#   # We want 'welcome.msg' displayed at login, and '.message' displayed
#   # in each newly chdired directory.
#   DisplayLogin            welcome.msg
#   DisplayChdir        .message
#
#   # Limit WRITE everywhere in the anonymous chroot
#   <Directory *>
#     <Limit WRITE>
#       DenyAll
#     </Limit>
#   </Directory>
#
#   # Uncomment this if you're brave.
#   # <Directory incoming>
#   #   # Umask 022 is a good standard umask to prevent new files and dirs
#   #   # (second parm) from being group and world writable.
#   #   Umask                022  022
#   #            <Limit READ WRITE>
#   #            DenyAll
#   #            </Limit>
#   #            <Limit STOR>
#   #            AllowAll
#   #            </Limit>
#   # </Directory>
#
# </Anonymous>