Domain or mail account creation error: mailmng-outgoing failed

Follow

Comments

2 comments

  • Avatar
    Dan Heitbohmer

    Hi Yulia,

    The domains are all set to "No web hosting" in the Plesk panel.

    After running the script, I receive the following errors (I have changed the domain names):

    root@psk1:/mailpatch# ./kb213371469.sh /affected_domains.txt
    ========================================================
    Domain: domain1.com            ipCollectionId: 71                   ipAddressId:
    ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
    psa.IpAddressesCollections table for domain1.com has been updated

    ========================================================
    Domain: domain2.com            ipCollectionId: 86                   ipAddressId:
    ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
    psa.IpAddressesCollections table for domain2.com has been updated

    ========================================================
    Domain: domain3.com            ipCollectionId: 76                   ipAddressId:
    ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
    psa.IpAddressesCollections table for domain3.com has been updated

    ========================================================
    Domain: domain4.com            ipCollectionId: 176                   ipAddressId:
    ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
    psa.IpAddressesCollections table for domain4.com has been updated

    psa.IpAddressesCollections table for all domains has been updated

    I would appreciate any assistance.

  • Avatar
    Robert Asilbekov

    @Dan Heitbohmer

    The script supposes that domains have a web hosting enabled and IP for the web hosting is configured properly. As it updating 'mail' service by using IP address information configured for web hosting. That's why it could not help you. If all domains on your server are using the same IP address, you may explicitly set actual id of IP address from the psa database instead of "$ipaid" 

    in the string  "insert into IpAddressesCollections values ($ipcid,$ipaid)"

    To get list of all IP addresses and their id run the following in the terminal:

    # plesk db "select * from IP_Addresses"

     

Please sign in to leave a comment.

Have more questions? Submit a request