Problem on editing data on MySQL table

Discussion in 'Server Operation' started by satimis, Dec 7, 2008.

  1. satimis

    satimis New Member

    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
     
  2. geek.de.nz

    geek.de.nz New Member

    your table seems to suggest

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

    satimis New Member

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

    marpada New Member

    user field is primary key, so you can't have duplicate values. Maybe you created the primary key wrong.
    ________
    VAPORBROTHERS
    ________
    THREESOME MOVIES
     
    Last edited: May 13, 2011
  5. satimis

    satimis New Member

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

    marpada New Member

    If a user must be resolved to a host and a port is doesn't make sense that you try to add duplicate users, does it?
    ________
    Ipad guide
    ________
    big women Cam
     
    Last edited: May 13, 2011
  7. satimis

    satimis New Member

    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
     

Share This Page