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@hagebuttentee.de 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@hagebuttentee.de 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@hagebuttentee.de 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@hagebuttentee.de 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@hagebuttentee.de 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@hagebuttentee.de 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@hagebuttentee.de 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@hagebuttentee.de 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@hagebuttentee.de 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@hagebuttentee.de 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@hagebuttentee.de plaintext User logged in May 25 14:19:49 db3 pop3[32208]: autocreateinbox: User nils@hagebuttentee.de, INBOX was successfully created in partition default -- Mit freundlichen Grüßen Nils Köpper mailto:nils.koepper@laterne.de -- Um die Liste abzubestellen, schicken Sie eine Mail an: opensuse-de+unsubscribe@opensuse.org Um eine Liste aller verfuegbaren Kommandos zu bekommen, schicken Sie eine Mail an: opensuse-de+help@opensuse.org