Location of Blacklist?

[killmasta93]

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

 

[dietmar]

We store such data inside a postgres database.

 

[killmasta93]

Thanks for the reply, is there a way i can access that database though winscp or another way to put in the list?

 

[heutger]

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]

Sure ill post back on all the domains i have listed on my blacklist

 

[killmasta93]

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

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)

@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

 

[heutger]

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

 

[killmasta93]

Thanks for the reply as i tried running that command but im getting this

postgres=# use Proxmox_ruledb;
ERROR:  syntax error at or near "use"
LINE 1: use Proxmox_ruledb;

Thank you

 

[heutger]

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

 

[killmasta93]

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?

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

 

[heutger]

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)

 

[heutger]

@killmasta93: If you're still searching for a solution, look here: #3

 

[killmasta93]

wow thank you i was doing it manually still havent finished