Problem with edit email account

[theprincy]

I'm trying to change the password to two email accounts but I get as error

User does not exist or you do not have permission to access this interface!

emails are in the database and they have no kind of error, error check better what you need?

ispcp trunk 6/09/2009
debian lenny

[theprincy]

nobody knows how to help me?

[sci2tech]

Try issue this query:

Code:

SELECT
            t1.*, t2.`domain_id`, t2.`domain_name`
        FROM
            `mail_users` AS t1,
            `domain` AS t2
        WHERE
            t1.`mail_id` = ?
        AND
            t2.`domain_id` = t1.`domain_id`
        AND
            t2.`domain_name` = ?

Replace ? with id of domain who own that email. I can not reproduce it

[kilburn]

Quote:User does not exist or you do not have permission to access this interface!

As you have this problem on multiple places, I think that the error is referring to your login user. Please try to add another domain, create a mail account on it and then change the password...

[theprincy]

(09-15-2009 04:45 AM)sci2tech Wrote:  Try issue this query:

Code:

SELECT
            t1.*, t2.`domain_id`, t2.`domain_name`
        FROM
            `mail_users` AS t1,
            `domain` AS t2
        WHERE
            t1.`mail_id` = ?
        AND
            t2.`domain_id` = t1.`domain_id`
        AND
            t2.`domain_name` = ?

Replace ? with id of domain who own that email. I can not reproduce it

name domain is j-rent.net

#1054 - Unknown column 'j' in 'where clause'

---

(09-15-2009 06:03 AM)kilburn Wrote:  

Quote:User does not exist or you do not have permission to access this interface!

As you have this problem on multiple places, I think that the error is referring to your login user. Please try to add another domain, create a mail account on it and then change the password...

the problem occurs with different domains on different servers, but I have the same problem with SQL account

[kilburn]

Quote:#1054 - Unknown column 'j' in 'where clause'

You have to replace the "?" with the id of the domain that owns this mail, not his name

[joximu]

there are two ?:

the first ? is the mail_id (a number) and the second ? the domain name!

/J

[kilburn]

well, so put the domain name between quotes

[theprincy]

(09-15-2009 05:01 PM)joximu Wrote:  there are two ?:

the first ? is the mail_id (a number) and the second ? the domain name!

/J

as he said kilburn
I had missed a mistake 'in the query, the result leaves the line of email

Code:

mail_id     mail_acc     mail_pass     mail_forward     domain_id     mail_type     sub_id     status     mail_auto_respond     mail_auto_respond_text     quota     mail_addr     domain_id     domain_name
94     admin     password     _no_     22     normal_mail     0     ok     0           10485760     admin@j-rentnet.net     22     j-rent.net

[joximu]

I wonder why the mail_addr <> mail_acc@domain_name

/J