software – ricardo malla's blog

October 13, 2020October 13, 2020elasticsearch

elasticsearch: secure

https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-elasticsearch-on-ubuntu-20-04 To test: Run from the local server to see if the server can connect to the elasticsearch cluster: curl -X GET ‘http://localhost:9200’ Run a test from a remote server, to see if a remote user can access […]

November 17, 2018idempiere

idempiere: allow sales pricelist on purchase order

Show product Pricelist on Purchase Order Go to System profile, Windows, Tabs & Fields Select Purchase Order Tab (header tab) Remove the statement from the Sql Where field. C_Order.IsSOTrx=’N’

August 19, 2018idempiere, java, openbravo, tibco - jasper reports

jasper reports: java compatibility

We user Jasper Reports on multiple projects: We have a stand-alone Jasper Server that runs all types of reports from our server We have an Openbravo ERP Instance We have an iDempiere ERP Instance Running (same fork root as Openbravo). […]

August 18, 2018November 30, 2019idempiere

idempiere: restart server

sudo service idempiere stop sudo service idempiere start

July 12, 2018November 30, 2019fail2ban

asterisk: fail2ban & ip tables

https://www.voip-info.org/fail2ban-with-iptables-and-asterisk/ /etc/init.d/fail2ban restart /etc/init.d/fail2ban reload /etc/init.d/iptables-persistent restart When you reload or restart fail2ban all the bans are removed. One problem with this wonderful solution (which is related to iptables, not fail2ban), is that when you reboot your server all […]

February 16, 2018February 16, 2018mautic

mautic: bounces retrieval not working

Error: [Symfony\Component\Debug\Exception\ClassNotFoundException] Attempted to load class “Type” from namespace “Mautic\EmailBundle\MonitoredEmail\Processor\Bounce”. Did you forget a “use” statement for e.g. “JMS\Serializer\Annotation\Type”, “Doctrine\DBAL\Types\Type”, “Aws\DynamoDb\Enum\Type”, “Symfony\Component\Validator\Constraints\Type” or “Mautic\Emai lBundle\MonitoredEmail\Processor\Bounce\Definition\Type”? Best way to solve this is by adding the verbose option to the fetch […]

February 8, 2018mautic

mautic: placeholders

Related to contacts {contactfield=firstname} Related to Companies {contactfield=companyname} {contactfield=city} {contactfield=companyfax} Custom Fields???

December 24, 2017December 24, 2017idempiere, postgresql

delete duplicate rows on pgsql and mysql

This code shows how to delete duplicate rows on pgsql DELETE FROM m_product WHERE sku in( SELECT sku FROM ( SELECT sku, count(*) FROM m_product GROUP BY sku HAVING count(*) > 1 ) a ) AND em_mg_manufacturer = 1000012 […]

December 21, 2017February 27, 2020mautic

mautic: clear bounces not working correctly

Some emails are parsed, while others are not. It depends on the format of the email. Here are some highlights: Files of interest: /app/bundles/EmailBundle/MonitoredEmail/Processor/Bounce/DsnParser.php /app/bundles/EmailBundle/MonitoredEmail/Mailbox.php: /app/bundles/EmailBundle/MonitoredEmail/Processor/Bounce.php The process as I understand it is the following: Step 1. On Mailbox.php you […]

December 2, 2017February 3, 2018scrapy

scrapy: basic commands

Create Project scrapy startproject EXAMPLE /home/Scripts/scrapy/EXAMPLE 2 . Create Project inside the spiders folder with the format: example_spider.py 3. Start testing with the console. scrapy shell ‘http://quotes.toscrape.com’ And execute the XPath commands https://devhints.io/xpath To run the […]