Location of Blacklist?

Discussion in 'Mail Gateway: Installation and configuration' started by killmasta93, Jun 15, 2018.

  1. killmasta93

    killmasta93 Member

    Joined:
    Aug 13, 2017
    Messages:
    223
    Likes Received:
    7
    Hi,
    I was wondering if someone could shed some light on the location on the file where it holds the blacklist, as im still slowly moving from scrolloutf1 i have a large blacklist and instead of putting each on on the webGUI i was wondering the location of that file in Proxmox. I was thinking maybe i would of been in /var/spool but i guess not.

    Thank you
     
  2. dietmar

    dietmar Proxmox Staff Member
    Staff Member

    Joined:
    Apr 28, 2005
    Messages:
    16,245
    Likes Received:
    276
    We store such data inside a postgres database.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. killmasta93

    killmasta93 Member

    Joined:
    Aug 13, 2017
    Messages:
    223
    Likes Received:
    7
    Thanks for the reply, is there a way i can access that database though winscp or another way to put in the list?
     
  4. heutger

    heutger Active Member

    Joined:
    Apr 25, 2018
    Messages:
    281
    Likes Received:
    69
    Although I don’t use blacklists, would be great, if you would contribute your blacklist to community. Maybe PMG will provide support in future for centralized antispam efforts like bayes database of all customers, blacklists of all customers etc. who want to contribute.
     
    killmasta93 likes this.
  5. killmasta93

    killmasta93 Member

    Joined:
    Aug 13, 2017
    Messages:
    223
    Likes Received:
    7
    Sure ill post back on all the domains i have listed on my blacklist
     
  6. killmasta93

    killmasta93 Member

    Joined:
    Aug 13, 2017
    Messages:
    223
    Likes Received:
    7
    So this is my blacklist if anyone else want to add more, but still could not be able to copy all that to that proxmox blacklist :(
    i tried accessing the database only see 4 tables

    Code:
    postgres=# \l
                                         List of databases
          Name      |  Owner   | Encoding  |   Collate   |    Ctype    |   Access privileges
    ----------------+----------+-----------+-------------+-------------+-----------------------
     Proxmox_ruledb | postgres | SQL_ASCII | C           | C           |
     postgres       | postgres | UTF8      | en_US.UTF-8 | en_US.UTF-8 |
     template0      | postgres | UTF8      | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
                    |          |           |             |             | postgres=CTc/postgres
     template1      | postgres | UTF8      | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
                    |          |           |             |             | postgres=CTc/postgres
    (4 rows)
    
    Code:
    @csilatinoamerica.com
    @frutafrescavirtual.com
    @web-crearmedia.com
    @label-news.com
    @sercomunicaciones.com
    @america-retail.com
    @noticiasgranformatolatinamerica.com
    @experticiatotal.com
    @fenalcosolidario.com
    @corpcomercio.com
    @online.alkomprar.com
    @youversion.com
    @paisavirtual.com
    @hotelestodoincluido.com.co
    @planillaexcel.com
    @cadenaemail.com
    @linkedin.com
    @shopepk.com.co
    @grupoimasd.com
    @kiusys.com
    @andigraf.com.co
    info@shopepk.com.co
    @paginaswebcolombia.ml
    .shopepk.com.co
    cordeincodireccioncomercial@gmail.com
    @co.needishmail.com
    noreply@co.needishmail.com
    @accor-mail.com
    @politecnicosuperior.edu.co
    @hotelestodoincluido.com.co
    @cactusit.ma
    @uniremington.edu.co
    @tiendeo.com.co
    .needishmail.com
    @engine92.com
    @picer.sakura.ne.jp
    @yeah.net
    @sina.cn
    @haoyuanxing.com
    @vg-global.net
    @winkalmail.com
    @bingoblitz.com
    @choprameditacion.com
    @chinamouldco.com
    @bigao-f.com
    @aliyun.com
    @goroc.net
    @educatemia.com
    @bkstg.com
    .linio.com.co
    @grouponmail.com.co
    @r.grouponmail.com.co
    @twoomail.com
    @directvla.com.co
    @sg.booking.com
    @plastico.mediosb2b.com
    @linkedin.com
    @virtualianet.com
    @cosmoprof.it
    @pulpower.com
    @viajala.com.co
    @mercadoni.com
    @incae.edu
    @moldex3dnews.com
    @calapresenta.com
    @enerconmail.com
    @ideatraining.com.co
    @kepware.com
    @facebookmail.com
    @practica.com.co
    @viajaengrande.com
    @vmware-latam.com
    huixinsoft106@foxmail.com
    @sendnovo.com
    @ibserp.co
    @metodosilvadevida.com
    @orca-inc.com
    @centrumx.org
    @citizengo.org
    @centronacionaldeconsultoria.com
    @mailing.farmatodo.com
    @javerianacali.edu.co
    @surveymonkey.com
    @central.com.co
    @isaca.msgfocus.com
    @vacacionante.com
    @mejorquelocompres.com
    @hao-mold.com
    @novasoft.com.co
    @edenred.com
    @expovacaciones.com.co
    @funiber.org
    @eidhi.com
    @espirituceleste.com
    @email.momondo.com
    @airbnb.com
    @molds.net
    @automationrecovery.com
    @correoviajes.com
    @aliexpress.com
    @ventusconsultores.com
    @xlineassets.com
    @a.mango.com
    @mail.gef.com.co
    @mailesprit.com.co
    @ronnerdesign.com
    @teatrocolon.gov.co
    @pacmail.em.marketinghq.net
    @ctrlatam.com
    @accor-mail.com
    @bosquesgranadaycayunda.com
    @cosmeticsdesign.com
    @procolombia.com
    @tecnnova.org
    @andi.com.co
    @moss.it
    @dms.ms
    @pcfk.com.co
    @consejoyfigura.com
    @ekstromcarlson.com
    @happyeureka.com
    @e.icis.com
    @hotelestodoincluido.com.co
    @interempresas.net
    @imts.com
    @tappsi.co
    @cosmeticsdesign-europe.com
    @research.net
    @hotelbono.com
    @freertool.com
    @ahk-colombia.com
    @toolstore.com.co
    @industria-alimentaria16.com
    @conquistaloya.com
    @assistcard.com
    @cicalidad.com
    @neurs.com
    @rodpub.com
    @e.mango.com
    @uniandes.edu.co
    @responsabilidadempresarialcol.org
    @liveworx.com
    @capitaleficiente.com
    @softwareone.com
    @vasanthatools.com
    @industryarena.com
    melaopublicidad@gmail.com
    @axure.com
    @corp.homecenter.com.co
    @grupoerf.com
    @mercadeolegis.com
    @saphety.com
    @oxohotel.com
    @pafltda.com
    @tastecocinaycava.com
    @4spe.org
    infoactivecode@gmail.com
    @cosmeticsdesign-asia.com
    @eeesanail.com
    @meadoworksinc.com
    @e.ofertia.com.co
    @fenalcosolidario.com
    @info.olx.com.co
    @minutodedios.org
    @durespo.com.co
    @bolivariano.com.co
    @ucaldas.edu.co
    @lanotaeconomica.co
    @change.org
    @bodyphilosophymicropigmentacion.com
    @keyence.com
    @service.babbel.com
    @baiedesomme.com
    @zoepearndesigns.com
    @catalogodelogistica.mediosb2b.com
    @directorioslegis.com
    @xmartplm.com
    @dolareshoy.com
    expobelleza@aol.com
    @purecambogiaultralatam.com
    @adecco.com
    ventas5@une.net.co
    @metrologiaglobal.com
    @co.falabella.com
    @badoo.com
    @mail.instagram.com
    @happycity.com.co
    @bodyphilosophyestetica.com
    @linkediw.com
    @ikonosoft.com
    @email.hbr.org
    @tuboleta.com
    @virginmobilecolombia.com
    @o.mango.com
    @EIFOODBANK.ORG
    @hk.bureauveritas.com
    @elysealexandria.com
    @mailing.emailmax.com.ar
    @knowldgy.com
    @notificacionesap.com.co
    @entrenamientoejecutivo.info
    @okpaypal.com
    @china-haichen.com
    @arrendaequipos.com
    @rappi.com
    @explore.pinterest.com
    @pinterest.com
    @antojese.com
    @globalrepsltda.com
    @awtsagroup.com
    @sinceretech.net
    ecoliteiluminacionled@hotmail.com
    @movichhotels.com
    @datamart-consultoria.com
    @ccb.org.co
    seminarios@practica.com.co
    @mail.vresp.com
    @exapro.info
    @printu.co
    @t-online.de
    @cartrackgps.net
    @mailmundosumas.com
    @adenibsnews.org
    @dekosas.com
    @cnczone.com
    @qareers.com
    asistente.espirituceleste@gmail.com
    escuelaege@gmail.com
    @arte-vip.net
    @sautau.com
    @163.com
    @fastcogroup.com
    @manpower.com.mx
    @co.needishmail.com
    @ultraviajes.com
    @travelandvacationreviews.com
    @sina.com
    @aundd-gmbh.de
    @hotel-bollmannsruh.de
    @dotojob.com
    @a-e-mag.com
    @anif.org
    @belplasticos.com
    @carvajal.com
    @clientesmailexito.com
    @co.falabella.com
    @corp.homecenter.com.co
    @despegar.com
    @dynisco.com
    @edm.regalhotel.com
    equipsalesusa@gmail.com
    @escobartrading.com
    @fashionmag.com
    @getmyinspiration4life.com
    @halldata.com
    @inssa.com.co
    @jatzer.com
    @locatelcolombia.com
    @mail.gef.com.co
    @maximconsultingjob.com
    Emma@wkspg.cn
    @abundance-mantra.com
    victoriasecretsgift@offsecretrevealed.com
    jenny.prosperity@gmail.com
    @mdc.org.co
    @megasistemas.com
    @mercadeo.com
    @mkt.adenibs.org
    @offcorss.com
    @polyassets.com
    @practica.com.co
    @printwearmag.com
    @provimarcas.com.co
    @reporteroindustrial.mediosb2b.com
    @revista-labarra.com.co
    @solucionesplasticos.com
    @springglobal.com
    @thenbmshow.com
    @tutiendaporinternet.ml
    @ubmcanon-info.com
    @variadores.com.co
    @vid.org.co
    @mundogerencial.net
    @isanin.com.co
    @novasoft.com.co
    @revista-fierros.com.co
    @molds.net
    @publicar.com
    @compasdobleclic.co
    ventasfactorysistem@gmail.com
    .despegar.com
    @coalconference.us
    promocionescyf@une.net.co
    @xingular.co
    @revista-en-obra.com.co
    @linkedin.com
    @enlacesasociados.com
    @camacolvalle.org.co
    @smarttek.com.co
    @greenscreen.mx
    @icef.com.co
    @ingredes.com
    chamois1984eventos@gmail.com
    @aciertodigital.com
    @ofertainmobiliaria.com.co
    @bcpcolombia.com
    @americaempresarial.com
    @suerveymonkey.com
    @lifesecrtsonline.com
    @comprasdobleclic.co
    @comprasdobleclic.com
    @conectiononline.com
    @polycom.com
    profeadomicilio2016@hotmail.com
    @enlineaagenciaauto.com
    @temporada.ec
    @entregavalida.com
    @deloitte.com
    @e-zigurat.com
    @fvcolombia.org
    @emaildigital.net
    sistemasdigit@gmail.com
    @sigmamovil.com
    @revista-lavarra.com.co
    robert@abundance-mantra.com
    @mail9.borknuer.vip
    @fassidigital.com
    @enlineaagenciauto.com
    @mail12.vertizement.vip
    @boletines1.com
    mariechristelle47@yahoo.com
    @lotonacional.com
    @autosanjorge.com
    @conganoticiasec.com
    @1999999.org
    @mydmarketing.com
    @venaycia.com
    @mercuryff.com
    @dispensertec.com.co
    @gtc.com.co
    @southcorp.com.pk
    @unitherm.com
    jenn.sa3@gmail.com
    @mkt.donweb.com
    @thepotup.com
    @zosprp.pl
    @takeitallsnow.com
    @thecofeepath.com
    @daslictindir.com
    @getrdyforchristmas.com
    @modeloares.com
    @163.com
    @themostamazingcam.com
    @waterpresssures.com
    @bestprohdcams.com
    @skincomplexionama.com
    @plusunderpants.com
    @betterredeemer.com
    @thefamousgrass.com
    @moreofferplease.com
    @reviewhddevice.com
    @automundial.com.co
    @agenciacreativa.ml
    @arte-vip.net
    @attherightpoint.com
    @niosline.com
    @headvrsetss.com
    @morevipwomens.com
    @gogetthemails.com
    @actionpots.com
    @towineyou.com
    @vrgoodness.com
    @northlotto.com
    @rvspinfoinside.com
    @excellencego.com
    @thehotspotnews.com
    @higherofferss.com
    @betterexcellence.com
    @smartaudit-ec.info
    @queenpots.com
    @incredibleruins.com
    @mustarisow.com
    @themostbeutygft.com
    @tutiendaprofesional.ml
    @v.vidacelosa.com
    @neweatway.com
    @ipc.org.ec
    @themeeatup.com
    @einforma.co
    @abrightspots.com
    @excelsiorwomen.com
    @thepentac.com
    @ezmal.org
    @elistas.net
    @fast-email-marking.com
    ventas1opalogroup@gmail.com
    empresariosaldia.sas@gmail.com
    @barb.epsonbusiness.info
    @monsuensuempresa.info
    daviducroseventosyturismo@hotmail.com
    @inilid.com
    nurygarcia@gmail.com
    suproductividad2016@outlook.es
    @worldclassequipment.net
    gente1a@une.net.co
    info@publivision.co
    @iqelite.com
    paulandreaonvacation99999@gmail.com
    @economizadores.info
    @gwen.alcatelmediasoft.com
    @greenscreen.media
    @alame.org
    @ifpo.es
    @buennegocio.info
    escueladelservicio@une.net.co
    @mere.ciscoculture.com
    @planinnova.com
    @cartrackgps.net
    @monsucapacita.info
    @nico.intelcompanylive.com
    .intelcompanylive.com
    @mercomailserver.com
    @croydon.com.co
    @oslore.com
    @hoochem.com
    @capacitacionesmonsu.org
    .greenscreen.media
    @loarcompany.com
    @masclicks.online
    .economizadores.info
    .amazonculture.net
    @ivancepedacastro.com
     
  7. heutger

    heutger Active Member

    Joined:
    Apr 25, 2018
    Messages:
    281
    Likes Received:
    69
    I don't think, this are tables, usually this looks like 4 databases, so you need to enter Proxmox_ruledb (looks to match best) and look into this database. Usually syntax should be similar to

    use Proxmox_ruledb;

    and then you could do something like

    show tables;

    Regards,
    Christian
     
  8. killmasta93

    killmasta93 Member

    Joined:
    Aug 13, 2017
    Messages:
    223
    Likes Received:
    7
    Thanks for the reply as i tried running that command but im getting this
    Code:
    postgres=# use Proxmox_ruledb;
    ERROR:  syntax error at or near "use"
    LINE 1: use Proxmox_ruledb;
    
    Thank you
     
  9. heutger

    heutger Active Member

    Joined:
    Apr 25, 2018
    Messages:
    281
    Likes Received:
    69
    I don't use postgresql usually, so I told you syntax for mysql and that it should be similar. Google says:

    \connect DBNAME
    or
    \c DBNAME

    is similar to use DBNAME;

    So you should try

    \c Proxmox_ruledb

    Show tables; seems to be in pgsql:

    \dt
     
  10. killmasta93

    killmasta93 Member

    Joined:
    Aug 13, 2017
    Messages:
    223
    Likes Received:
    7
    ooOo gotcha thanks again sorry did not read the last part of the similar
    So within those tables there has to be a line where it says blacklist and white list and the parent folder might be who objects
    also been trying to connect using pgAdmin which would be easier to visualize but cannt get it to connect as the port is 5432 and the maintenance database i could imagine is postgres
    the username is postgres and the password of the proxmox?

    Code:
    Proxmox_ruledb=# \dt
               List of relations
     Schema |     Name     | Type  | Owner
    --------+--------------+-------+-------
     public | attribut     | table | root
     public | cgreylist    | table | root
     public | clusterinfo  | table | root
     public | cmailstore   | table | root
     public | cmsreceivers | table | root
     public | creceivers   | table | root
     public | cstatistic   | table | root
     public | dailystat    | table | root
     public | domainstat   | table | root
     public | localstat    | table | root
     public | object       | table | root
     public | objectgroup  | table | root
     public | rule         | table | root
     public | rulegroup    | table | root
     public | statinfo     | table | root
     public | userprefs    | table | root
     public | virusinfo    | table | root
    
     
    #10 killmasta93, Jun 21, 2018
    Last edited: Jun 21, 2018
  11. heutger

    heutger Active Member

    Joined:
    Apr 25, 2018
    Messages:
    281
    Likes Received:
    69
    Honestly, don't know and the table names also don't help on where to expect, so you may ask @dietmar on more information regarding his post above. Alternative you should use \dt tablename to see the columns, maybe this helps to understood. Otherwise use

    select * from tablename

    to see tables content (may be long)
     
  12. heutger

    heutger Active Member

    Joined:
    Apr 25, 2018
    Messages:
    281
    Likes Received:
    69
    @killmasta93: If you're still searching for a solution, look here: #3
     
    killmasta93 likes this.
  13. killmasta93

    killmasta93 Member

    Joined:
    Aug 13, 2017
    Messages:
    223
    Likes Received:
    7
    wow thank you i was doing it manually still havent finished
     
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice