it – ricardo malla's blog

mautic: configuration

Posted July 12, 2017April 26, 2021 Ricardo MallaLeave a commentPosted in Mautic

https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful Add Mailto to the List-Unsubscribe Header: Go to -> /app/bundles/EmailBundle/Helper/MailHelper.php: Aproximately on line 1484 /** * Generate and insert List-Unsubscribe header. */ private function addUnsubscribeHeader() { if (isset($this->idHash)) { $unsubscribeLink = $this->factory->getRouter()->generate('mautic_email_unsubscribe', ['idHash' => $this->idHash], true); $this->headers['List-Unsubscribe'] = "<unsubscribe@[DOMAIN]>,<$unsubscribeLink>"; […]

mautic: understanding how it works

Posted July 13, 2017April 26, 2021 Ricardo MallaLeave a commentPosted in Mautic

Add your contacts. Create your segments and apply the filters you want. Update the segments using this query php /var/www/html/[DOMAIN]/mail/app/console mautic:segments:update Rebuild Campaign php /var/www/html/[DOMAIN]/mail/app/console mautic:campaigns:rebuild Trigger Campaign ---> Note that once you trigger the campaign the email will appear […]

ubuntu: relevant and useful commands

Posted November 10, 2012April 19, 2021 Ricardo MallaLeave a commentPosted in Ubuntu

Example of the Command FIND How to find all the Logs on your server find / -iname '*.log' find /var/spool/asterisk/monitor/ -iname '*0414*' Change server Timezone dpkg-reconfigure tzdata Restart Openbravo Tomcat /etc/init.d/openbravo-tomcat restart To Check if your server is 32 or […]

ubuntu: only route traffic through vpn tunnel

Posted April 18, 2021April 18, 2021 Ricardo MallaLeave a commentPosted in openvpn, Ubuntu

mysql: extract domain from email

Posted April 17, 2021April 17, 2021 Ricardo MallaLeave a commentPosted in MySQL, Uncategorized

SUBSTR(email_addresses.email_address, INSTR(email_addresses.email_address, '@') + 1)

mysql: capitalize first word of all words

Posted April 17, 2021April 17, 2021 Ricardo MallaLeave a commentPosted in MySQL

credits to: http://joezack.com/2008/10/20/mysql-capitalize-function/ create a function: CREATE FUNCTION CAP_FIRST (input VARCHAR(255)) RETURNS VARCHAR(255) DETERMINISTIC BEGIN DECLARE len INT; DECLARE i INT; SET len = CHAR_LENGTH(input); SET input = LOWER(input); SET i = 0; WHILE (i < len) DO […]

mysql: backup databases

Posted August 18, 2013April 16, 2021 Ricardo MallaLeave a commentPosted in MySQL

Backups all databases mysqldump -u [user] -p[password] --all-databases > [filename].sql specific databases mysqldump -u [user] -p[password] [database_name] > [filename].sql specific database but omitting specific tables mysqldump -u [user] -p[password] [database_name] --ignore-table=db1.tbl1 --ignore-table=db2.tbl1 > [filename].sql restore mysql -u […]

pgsql: pgdump authentication

Posted May 27, 2016April 15, 2021 Ricardo MallaLeave a commentPosted in PostgreSQL

create .pg_pass file on the root folder of the user that will run the pgsql command for example. /root or /user touch /root/.pgpass chmod 600 .pgpass add the credentialas user and password that will be user […]

mysql: remove only_full_group_by and make it persistent

Posted November 25, 2019March 24, 2021 Ricardo MallaLeave a commentPosted in MySQL

update it from the console (will revert upon reboot) from the command line go to the mysql console mysql then edit the sql_mode entry SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); SELECT @@sql_mode; SELECT @@GLOBAL.sql_mode; for a persistent change, in mysql […]

wordpress: text being changed

Posted February 9, 2018March 24, 2021 Ricardo MallaLeave a commentPosted in Wordpress

update: edit: /wp-includes/default-filters.php comment out all the 11 times the add_filter is added. for example add_filter( 'the_content', 'wptexturize' );