Mailinglist Archive: opensuse-de (1579 mails)

[Nils Köpper <nils.koepper@xxxxxxxxxx>]

Hi Sandy Drobic,

am Freitag, 25. Mai 2007 um 11:54 schrieb Sandy Drobic:

SD> Dann solltest du deine Query auch darauf anpassen. (^-^)
SD> Also nicht %u@%r verwenden, sondern %u.%r, was passiert dann?

Dann findet er keinen passenden Eintrag in der virtual.alias Spalte da es dort
kein %u.%r gibt.

Such ich nun ebenfalls in der user `accountuser`.`username` Spalte so
wird ein Passwort gefunden jedoch wird wieder ein neues Konto unter
dem Benutzernamen nils@xxxxxxxxxxxxxxxx angelegt.

Offensichtlich wird nur überprüft ob es eine Passwortübereinstimmung
gibt und dann wird auf das Konto zugegriffen welches dem angegebenen
Benutzernamen entspricht. Daraus würde ich mal schlußfolgern das es
keine Möglichkeit gibt den von mir gewünschten Benutzernamen und die
Emailadresse als gültigen Anmeldebenutzernamen zu verwenden.


May 25 14:12:34 db3 pop3[32141]: executed
May 25 14:12:34 db3 pop3[32141]: sql auxprop plugin using mysql engine
May 25 14:12:34 db3 pop3[32141]: accepted connection
May 25 14:12:34 db3 pop3[32141]: sql plugin Parse the username 
nils@xxxxxxxxxxxxxxxx
May 25 14:12:34 db3 pop3[32141]: sql plugin try and connect to a host
May 25 14:12:34 db3 pop3[32141]: sql plugin trying to open db 'mail' on host ''
May 25 14:12:34 db3 pop3[32141]: sql plugin Parse the username 
nils@xxxxxxxxxxxxxxxx
May 25 14:12:34 db3 pop3[32141]: sql plugin try and connect to a host
May 25 14:12:34 db3 pop3[32141]: sql plugin trying to open db 'mail' on host ''
May 25 14:12:34 db3 pop3[32141]: sql plugin Parse the username 
nils@xxxxxxxxxxxxxxxx
May 25 14:12:34 db3 pop3[32141]: sql plugin try and connect to a host
May 25 14:12:34 db3 pop3[32141]: sql plugin trying to open db 'mail' on host ''
May 25 14:12:34 db3 pop3[32141]: begin transaction
May 25 14:12:34 db3 pop3[32141]: sql plugin create statement from userPassword 
nils hagebuttentee.de
May 25 14:12:34 db3 pop3[32141]: sql plugin doing query SELECT
`accountuser`.`password` FROM `accountuser`, `virtual` WHERE 
`accountuser`.`username` = `virtual`.`username` AND (`virtual`.`alias` = 
'nils.hagebuttentee.de' OR `accountuser`.`username` = 'nils');
May 25 14:12:34 db3 pop3[32141]: sql plugin: no result found
May 25 14:12:34 db3 pop3[32141]: sql plugin create statement from 
cmusaslsecretPLAIN nils hagebuttentee.de
May 25 14:12:34 db3 pop3[32141]: sql plugin doing query SELECT
`accountuser`.`password` FROM `accountuser`, `virtual` WHERE 
`accountuser`.`username` = `virtual`.`username` AND (`virtual`.`alias` = 
'nils.hagebuttentee.de' OR `accountuser`.`username` = 'nils');
May 25 14:12:34 db3 pop3[32141]: sql plugin: no result found
May 25 14:12:34 db3 pop3[32141]: commit transaction
May 25 14:12:34 db3 pop3[32141]: sql plugin Parse the username 
nils@xxxxxxxxxxxxxxxx
May 25 14:12:34 db3 pop3[32141]: sql plugin try and connect to a host
May 25 14:12:34 db3 pop3[32141]: sql plugin trying to open db 'mail' on host ''
May 25 14:12:34 db3 pop3[32141]: badlogin: u3-40.dsl.vianetworks.de 
[194.231.193.40] plaintext nils@xxxxxxxxxxxxxxxx SASL(-13): user not found: 
checkpass failed


May 25 14:19:49 db3 pop3[32208]: executed
May 25 14:19:49 db3 pop3[32208]: sql auxprop plugin using mysql engine
May 25 14:19:49 db3 pop3[32208]: accepted connection
May 25 14:19:49 db3 pop3[32208]: sql plugin Parse the username 
nils@xxxxxxxxxxxxxxxx
May 25 14:19:49 db3 pop3[32208]: sql plugin try and connect to a host
May 25 14:19:49 db3 pop3[32208]: sql plugin trying to open db 'mail' on host ''
May 25 14:19:49 db3 pop3[32208]: sql plugin Parse the username 
nils@xxxxxxxxxxxxxxxx
May 25 14:19:49 db3 pop3[32208]: sql plugin try and connect to a host
May 25 14:19:49 db3 pop3[32208]: sql plugin trying to open db 'mail' on host ''
May 25 14:19:49 db3 pop3[32208]: sql plugin Parse the username 
nils@xxxxxxxxxxxxxxxx
May 25 14:19:49 db3 pop3[32208]: sql plugin try and connect to a host
May 25 14:19:49 db3 pop3[32208]: sql plugin trying to open db 'mail' on host ''
May 25 14:19:49 db3 pop3[32208]: begin transaction
May 25 14:19:49 db3 pop3[32208]: sql plugin create statement from userPassword 
nils hagebuttentee.de
May 25 14:19:49 db3 pop3[32208]: sql plugin doing query SELECT
`accountuser`.`password` FROM `accountuser`, `virtual` WHERE 
`accountuser`.`username` = `virtual`.`username` AND (`accountuser`.`username` = 
'nils.hagebuttentee.de' OR `accountuser`.`username` = 'nils');
May 25 14:19:49 db3 pop3[32208]: sql plugin create statement from 
cmusaslsecretPLAIN nils hagebuttentee.de
May 25 14:19:49 db3 pop3[32208]: sql plugin doing query SELECT
`accountuser`.`password` FROM `accountuser`, `virtual` WHERE 
`accountuser`.`username` = `virtual`.`username` AND (`accountuser`.`username` = 
'nils.hagebuttentee.de' OR `accountuser`.`username` = 'nils');
May 25 14:19:49 db3 pop3[32208]: commit transaction
May 25 14:19:49 db3 pop3[32208]: sql plugin Parse the username 
nils@xxxxxxxxxxxxxxxx
May 25 14:19:49 db3 pop3[32208]: sql plugin try and connect to a host
May 25 14:19:49 db3 pop3[32208]: sql plugin trying to open db 'mail' on host ''
May 25 14:19:49 db3 pop3[32208]: login: u3-40.dsl.vianetworks.de 
[194.231.193.40] nils@xxxxxxxxxxxxxxxx plaintext User logged in
May 25 14:19:49 db3 pop3[32208]: autocreateinbox: User nils@xxxxxxxxxxxxxxxx, 
INBOX was successfully created in partition default








-- 
Mit freundlichen Grüßen
Nils Köpper
mailto:nils.koepper@xxxxxxxxxx


-- 
Um die Liste abzubestellen, schicken Sie eine Mail an:
    opensuse-de+unsubscribe@xxxxxxxxxxxx
Um eine Liste aller verfuegbaren Kommandos zu bekommen, schicken
Sie eine Mail an: opensuse-de+help@xxxxxxxxxxxx