Problem with edit email account

Problem with edit email account - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Problem with edit email account (/thread-7799.html)

Pages: 1 2

Problem with edit email account - theprincy - 09-08-2009 06:47 PM

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

RE: Problem with edit email account - theprincy - 09-15-2009 04:25 AM

nobody knows how to help me?

RE: Problem with edit email account - sci2tech - 09-15-2009 04:45 AM

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

RE: Problem with edit email account - kilburn - 09-15-2009 06:03 AM

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...

RE: Problem with edit email account - theprincy - 09-15-2009 02:52 PM

(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

RE: Problem with edit email account - kilburn - 09-15-2009 04:54 PM

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 Wink

RE: Problem with edit email account - joximu - 09-15-2009 05:01 PM

there are two ?:

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

/J

RE: Problem with edit email account - kilburn - 09-15-2009 05:29 PM

well, so put the domain name between quotes Wink

RE: Problem with edit email account - theprincy - 09-15-2009 07:24 PM

(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 Tongue

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

RE: Problem with edit email account - joximu - 09-15-2009 07:54 PM

I wonder why the mail_addr <> mail_acc@domain_name

/J