Problem on editing data on MySQL table

Hi folks,


I have a table tblPerdition created on dbPerdition

Code:

mysql> SHOW tables;
+-----------------------+
| Tables_in_dbPerdition |
+-----------------------+
| tblPerdition          |
+-----------------------+
1 row in set (0.00 sec)

Code:

mysql> DESCRIBE tblPerdition;
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| user       | varchar(128) | NO   | PRI |         |       |
| servername | varchar(255) | NO   |     |         |       |
| port       | varchar(8)   | YES  |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

On editing data on the table;

Code:

mysql> INSERT INTO user VALUES
    -> ('[email protected]'),
    -> ('[email protected]'),
    -> ('[email protected]');
ERROR 1146 (42S02): Table 'dbPerdition.user' doesn't exist

Please advise how to fix the problem? Whether I need to edit;

Code:

('userA'@'domainA.com')

???


TIA


B.R.
satimis

 

your table seems to suggest

Code:

mysql> use dbPerdition;
    ->INSERT INTO tblPerdition (user, servername) VALUES
    -> ('userA','domainA.com'),
    -> ('userA','domianB.com'),
    -> ('userA','domainC.com');

 

Hi geek.de.nz,


Thanks for your advice.

Ran;

Code:

mysql> INSERT INTO tblPerdition (user, servername) VALUES
     -> ('satimis','satimis.com'),
     -> ('satimis','satimis.changeip.net'),
     -> ('satimis','satimis.dnsalias.com');

ERROR 1062 (23000): Duplicate entry 'satimis' for key 1


B.R.
satimis

 

I was following this document;
http://www.vergenet.net/linux/perdition/perditiondb.5.shtml

to config/setup perdition creating a MySQL table. The primary key is required there. Their mailing list can't help me out. I'm looking around for a solution.

Besides, the descriptor of Null is either YES or NO. It needs blank there.


satimis

 

Same user holding several email address must be allowed which is not considered as duplicate user (on MySQL table maybe). Actually the setup on 2 key components are critical, the config file of perdition and the table of the database, 'tblPerdition'.

The whole system is now working perfectly on Intranet. Incoming mails are routed by the routing mail server to their mail servers running as guests on the Xen box. Mail clients running on workstations on the Intranet can send and receive mails via their own mail server. If allotting each mail server a port my problem may be solved already. But this is NOT the goal of my test. Not many perdition document/link can be found on googling. If I can't solve my problem with Perdition I'll move to nginx.


B.R.
satimis