E-Mail Server Ubuntu SQL Error
up vote
0
down vote
favorite
I've been trying to set up a server but it doesn't work. I got this error:
23:59:43 mail dovecot: auth-worker(14604): Error: sql(test@mydomain.eu, ip): Password query failed; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' ROM users WHERE userid = 'test@mydomain.eu' and mysql_pass = password('psw' at line 1.
Here my config:
driver = mysql
connect = "host=127.0.0.1 dbname=dbname user=userdb password=psw"
default_pass_scheme = SHA512-CRYPT
password_query = SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
user_query = SELECT username AS user, domain, password FROM accounts WHERE username = '%n$
iterate_query = SELECT username, domain FROM accounts where sendonly = false;
My setup: I have installed mariadb, dovecot, postfix, postfixadmin.
When I create an email account with postfixadmin and use the same database with dovecot, I got the error. What am I doing wrong?
I'm not very experienced. If you need more informations, please ask.
ubuntu email mysql
add a comment |
up vote
0
down vote
favorite
I've been trying to set up a server but it doesn't work. I got this error:
23:59:43 mail dovecot: auth-worker(14604): Error: sql(test@mydomain.eu, ip): Password query failed; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' ROM users WHERE userid = 'test@mydomain.eu' and mysql_pass = password('psw' at line 1.
Here my config:
driver = mysql
connect = "host=127.0.0.1 dbname=dbname user=userdb password=psw"
default_pass_scheme = SHA512-CRYPT
password_query = SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
user_query = SELECT username AS user, domain, password FROM accounts WHERE username = '%n$
iterate_query = SELECT username, domain FROM accounts where sendonly = false;
My setup: I have installed mariadb, dovecot, postfix, postfixadmin.
When I create an email account with postfixadmin and use the same database with dovecot, I got the error. What am I doing wrong?
I'm not very experienced. If you need more informations, please ask.
ubuntu email mysql
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I've been trying to set up a server but it doesn't work. I got this error:
23:59:43 mail dovecot: auth-worker(14604): Error: sql(test@mydomain.eu, ip): Password query failed; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' ROM users WHERE userid = 'test@mydomain.eu' and mysql_pass = password('psw' at line 1.
Here my config:
driver = mysql
connect = "host=127.0.0.1 dbname=dbname user=userdb password=psw"
default_pass_scheme = SHA512-CRYPT
password_query = SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
user_query = SELECT username AS user, domain, password FROM accounts WHERE username = '%n$
iterate_query = SELECT username, domain FROM accounts where sendonly = false;
My setup: I have installed mariadb, dovecot, postfix, postfixadmin.
When I create an email account with postfixadmin and use the same database with dovecot, I got the error. What am I doing wrong?
I'm not very experienced. If you need more informations, please ask.
ubuntu email mysql
I've been trying to set up a server but it doesn't work. I got this error:
23:59:43 mail dovecot: auth-worker(14604): Error: sql(test@mydomain.eu, ip): Password query failed; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' ROM users WHERE userid = 'test@mydomain.eu' and mysql_pass = password('psw' at line 1.
Here my config:
driver = mysql
connect = "host=127.0.0.1 dbname=dbname user=userdb password=psw"
default_pass_scheme = SHA512-CRYPT
password_query = SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
user_query = SELECT username AS user, domain, password FROM accounts WHERE username = '%n$
iterate_query = SELECT username, domain FROM accounts where sendonly = false;
My setup: I have installed mariadb, dovecot, postfix, postfixadmin.
When I create an email account with postfixadmin and use the same database with dovecot, I got the error. What am I doing wrong?
I'm not very experienced. If you need more informations, please ask.
ubuntu email mysql
ubuntu email mysql
edited Nov 16 at 23:29
fixer1234
17.3k144280
17.3k144280
asked Nov 16 at 23:16
Cyberpunk7711
32
32
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
accepted
The error you have is as follows; bold emphasis is mine:
23:59:43 mail dovecot: auth-worker(14604): Error: sql(test@mydomain.eu, ip): Password query failed; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' ROM users WHERE userid = 'test@mydomain.eu' and mysql_pass = password('psw' at line 1.
The query value you have set is as follows; again bold emphasis is mine:
SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
Seems like that is a problem. But also some of the queries oddly have a
$
at the end of them like these:
SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
SELECT username AS user, domain, password FROM accounts WHERE username = '%n$
It looks like you copied and pasted these queries from some command line output that truncated the queries. The solution? Get the actual full queries and place them in the config.
Also, what is this about?
driver = mysql connect = "host=127.0.0.1 dbname=dbname user=userdb password=psw"
Why are those two driver
and connect
values on the same line?
In general, the overall format quirks you are seeing makes the config seem like a mess. No easy way for us to solve it, but basically I would recommend rewriting the config properly with full queries, quotes around values (if the config works that way) and properly setting each value on each line.
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
accepted
The error you have is as follows; bold emphasis is mine:
23:59:43 mail dovecot: auth-worker(14604): Error: sql(test@mydomain.eu, ip): Password query failed; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' ROM users WHERE userid = 'test@mydomain.eu' and mysql_pass = password('psw' at line 1.
The query value you have set is as follows; again bold emphasis is mine:
SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
Seems like that is a problem. But also some of the queries oddly have a
$
at the end of them like these:
SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
SELECT username AS user, domain, password FROM accounts WHERE username = '%n$
It looks like you copied and pasted these queries from some command line output that truncated the queries. The solution? Get the actual full queries and place them in the config.
Also, what is this about?
driver = mysql connect = "host=127.0.0.1 dbname=dbname user=userdb password=psw"
Why are those two driver
and connect
values on the same line?
In general, the overall format quirks you are seeing makes the config seem like a mess. No easy way for us to solve it, but basically I would recommend rewriting the config properly with full queries, quotes around values (if the config works that way) and properly setting each value on each line.
add a comment |
up vote
0
down vote
accepted
The error you have is as follows; bold emphasis is mine:
23:59:43 mail dovecot: auth-worker(14604): Error: sql(test@mydomain.eu, ip): Password query failed; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' ROM users WHERE userid = 'test@mydomain.eu' and mysql_pass = password('psw' at line 1.
The query value you have set is as follows; again bold emphasis is mine:
SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
Seems like that is a problem. But also some of the queries oddly have a
$
at the end of them like these:
SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
SELECT username AS user, domain, password FROM accounts WHERE username = '%n$
It looks like you copied and pasted these queries from some command line output that truncated the queries. The solution? Get the actual full queries and place them in the config.
Also, what is this about?
driver = mysql connect = "host=127.0.0.1 dbname=dbname user=userdb password=psw"
Why are those two driver
and connect
values on the same line?
In general, the overall format quirks you are seeing makes the config seem like a mess. No easy way for us to solve it, but basically I would recommend rewriting the config properly with full queries, quotes around values (if the config works that way) and properly setting each value on each line.
add a comment |
up vote
0
down vote
accepted
up vote
0
down vote
accepted
The error you have is as follows; bold emphasis is mine:
23:59:43 mail dovecot: auth-worker(14604): Error: sql(test@mydomain.eu, ip): Password query failed; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' ROM users WHERE userid = 'test@mydomain.eu' and mysql_pass = password('psw' at line 1.
The query value you have set is as follows; again bold emphasis is mine:
SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
Seems like that is a problem. But also some of the queries oddly have a
$
at the end of them like these:
SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
SELECT username AS user, domain, password FROM accounts WHERE username = '%n$
It looks like you copied and pasted these queries from some command line output that truncated the queries. The solution? Get the actual full queries and place them in the config.
Also, what is this about?
driver = mysql connect = "host=127.0.0.1 dbname=dbname user=userdb password=psw"
Why are those two driver
and connect
values on the same line?
In general, the overall format quirks you are seeing makes the config seem like a mess. No easy way for us to solve it, but basically I would recommend rewriting the config properly with full queries, quotes around values (if the config works that way) and properly setting each value on each line.
The error you have is as follows; bold emphasis is mine:
23:59:43 mail dovecot: auth-worker(14604): Error: sql(test@mydomain.eu, ip): Password query failed; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' ROM users WHERE userid = 'test@mydomain.eu' and mysql_pass = password('psw' at line 1.
The query value you have set is as follows; again bold emphasis is mine:
SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
Seems like that is a problem. But also some of the queries oddly have a
$
at the end of them like these:
SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users $
SELECT username AS user, domain, password FROM accounts WHERE username = '%n$
It looks like you copied and pasted these queries from some command line output that truncated the queries. The solution? Get the actual full queries and place them in the config.
Also, what is this about?
driver = mysql connect = "host=127.0.0.1 dbname=dbname user=userdb password=psw"
Why are those two driver
and connect
values on the same line?
In general, the overall format quirks you are seeing makes the config seem like a mess. No easy way for us to solve it, but basically I would recommend rewriting the config properly with full queries, quotes around values (if the config works that way) and properly setting each value on each line.
answered Nov 16 at 23:40
JakeGould
30.6k1093135
30.6k1093135
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1376123%2fe-mail-server-ubuntu-sql-error%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown