OK, I'm getting closer to a resolution of the problem
I've had with mysql and postfix. I've got it narrowed
down to an access problem on the database. As a
relative novice to mysql, I thought I had things set
right for the database access by the 'postfix' user
account. Following are the user and db tables from
the mysql database:
mysql> select * from user;
+---------------------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password |
Select_priv | Insert_priv | Update_priv | Delete_priv
| Create_priv | Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv
| References_priv | Index_priv | Alter_priv |
+---------------------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root | | Y
| Y | Y | Y |
Y | Y | Y | Y
| Y | Y | Y | Y
| Y | Y |
| localhost | postfix | | Y
| N | N | N |
N | N | N | N
| N | N | N | N
| N | N |
| localhost | | | N
| N | N | N |
N | N | N | N
| N | N | N | N
| N | N |
| mail1.itcserver.com | root | | Y
| Y | Y | Y |
Y | Y | Y | Y
| Y | Y | Y | Y
| Y | Y |
| % | root | | N
| N | N | N |
N | N | N | N
| N | N | N | N
| N | N |
| mail1.itcserver.com | | | N
| N | N | N |
N | N | N | N
| N | N | N | N
| N | N |
+---------------------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
6 rows in set (0.00 sec)
mysql> select * from db;
+-----------+---------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| Host | Db | User | Select_priv |
Insert_priv | Update_priv | Delete_priv | Create_priv
| Drop_priv | Grant_priv | References_priv |
Index_priv | Alter_priv |
+-----------+---------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| % | test | | Y | Y
| Y | Y | Y | Y
| N | Y | Y | Y
|
| % | test\_% | | Y | Y
| Y | Y | Y | Y
| N | Y | Y | Y
|
| % | mysql | root | Y | Y
| Y | Y | Y | Y
| N | Y | Y | Y
|
| localhost | maildb | root | Y | N
| N | N | N | N
| N | N | N | N
|
| localhost | maildb | postfix | Y | N
| N | N | N | N
| N | N | N | N
|
| 127.0.0.1 | maildb | postfix | Y | N
| N | N | N | N
| N | N | N | N
|
| 127.0.0.1 | maildb | root | Y | N
| N | N | N | N
| N | N | N | N
|
| % | maildb | root | Y | N
| N | N | N | N
| N | N | N | N
|
| % | maildb | postfix | Y | N
| N | N | N | N
| N | N | N | N
|
+-----------+---------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
9 rows in set (0.00 sec)
As you can see, I've attempted to cover all the bases
for how the 'postfix' user would look to the incoming
database: 127.0.0.1, localhost, and %. However, when
I try to access the databse using the user 'postfix',
I get the following:
# mysql -u postfix maildb
ERROR 1045: Access denied for user:
'[EMAIL PROTECTED]' (Using password: NO)
I get the same error whether I include the -p=xxxxxxxx
or not (althought it changes to '(Using password:
YES)'.
I've been stymied by this for 4 hours now, trying all
sorts of combinations. The documentation I've read
indicates that I should just have to have the entry
for the maildb database for 'postfix' on 'localhost'.
What am I doing wrong? Any help would be
appreciated...
Aj
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
