1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Mail to nonexistent user: where is the data stored in database

Discussion in 'Plesk for Linux - 8.x and Older' started by s.huisman, Dec 22, 2006.

  1. s.huisman

    s.huisman Guest

    0
     
    Hello can anyone help me where the settings and email are being stored in psa database of:

    Mail to nonexistent user
    Forward to adress: test@example.com

    The migration manager doesn't work this out well, when i want to migrate using templates. So i want to sync the databases so everything wil be te same, without goint troug 300 domains.

    Hope you can help me saving much of time, thanx !
     
  2. blank_page

    blank_page Regular Pleskian

    24
    53%
    Joined:
    Dec 17, 2006
    Messages:
    229
    Likes Received:
    0
    Hello,


    From domains table you get the id.

    From mail table you get the mailnames.
    (select * from domains where dom_id=x;)
    --> here you can find the account_id
    From accounts table you get the passwords with the account_id from the mail table.

    mn_param table contains other params like drweb.


    You have check a bit the table structure a bit for yourself so you can create the script that you want.
     
  3. s.huisman

    s.huisman Guest

    0
     
    Ok thanx, i'll go into it!
     
  4. s.huisman

    s.huisman Guest

    0
     
    Hello, Are you talking about the same subject, because we couldn't find this information in:

    mail
    domains
    mn_param
    accounts

    Anyone else have a good sugestion?
     
  5. rgfincher

    rgfincher New Pleskian

    22
    90%
    Joined:
    Jun 28, 2003
    Messages:
    18
    Likes Received:
    0
    Location:
    London
    Did you ever get an answer to this? I need to know.
     
  6. rgfincher

    rgfincher New Pleskian

    22
    90%
    Joined:
    Jun 28, 2003
    Messages:
    18
    Likes Received:
    0
    Location:
    London
    select name from Parameters,domains where parameter = 'nonexist_mail' and value='bounce' and Parameters.id=domains.id order by name;
     
Loading...