Tag: how to
Has your Suite CRM global search broken? I hear you. Hard times. I actually went through the entire process of upgrading our whole instance for about a month and after finishing all that, it turns out it was just this broken index! Good news is that the newer version of Suite CRM is about ten times more awesome so I’m glad I was forced to upgrade. But here’s the point – this tutorial might be all you need to fix your Suitecrm broken global search.
The problem is that if you are in a shared host environment like me and not very skilled it’s just downright scary to perform some of the tutorials I found. I had no choice but to give it a shot and thankfully it worked. Hopefully this tutorial will remove some of the fear for you that I had to go through.
First, as always, none of this would have been possible without all the history of awesome developers who put their code into the Suitecrm project. I will refer to a few specific folks but there are many others involved as with any free software proejct. To you we are all thankful and hopefully this tutorial helps others join the Suitecrm project.
Next, let’s talk about the task at hand
Before We Begin
I find it’s useful to look at the steps in a casual way before doing them. No one really does this in tutorials but I find it lowers stress levels when you approach each step. What we’re going to do here is just back up a few things so we don’t kill our crm forever if we make a mistake, rename a folder, learn a couple of new things in Phpmyadmin (some tool in Cpanel and elsewhere), delete a bunch of old rows in a database table that’s making your Global Search broken, and then tell Suitecrm to ‘start indexing afresh’. That’s it. So remember, ‘If Wayne can do it, you can do it too. Just take your time.
I am assuming that you are using a Cpanel shared hosting environment. If you aren’t, I’m guessing that you are probably smarter than me anyway and this tutorial will feel to baby-like. Feel free to skip to this tutorial here if that is you. Pretty much all of what I’m doing is from that but he didn’t explain a few things I simply couldn’t figure out online.
Step 0 – Advise Others Not to Use SuiteCRM
I always tell others to not use the crm when I do maintenance. Probably you should advise the same.
Step 1 – Back up your Whole Suite CRM instance
In theory you ‘could’ skip this step but I’ve learned it’s worth it. We’re only renaming one directory in this tutorial so if you are careful you could skip it. But since you probably need a recent backup anyway, why not do it?
- a) Go to file manager
- b) Go to your suite crm install folder and back it up. There are two ways to do it I’ve learned. You can compress it where it is with the Cpanel compress tool and then just download to your computer or, better, use an FTP tool and get it that way. Both work.
Step 2 – Back up your MySQL Database
Besides your files in Step 1, these database files are the other critical files to back up.
- a) Go to ‘backup’ section of cpanel,
- b) go to “Download a MySQL Database Backup”
- c) select the database asssociated with your suitecrm and click it. If you don’t now what your database is, and you have a few, then there are two ways to figure it out:
- if you installed by Softaculous, you can just search Suitecrm in the search field, find your install and then click the pencil icon to see the details which will show the database name
- If you didn’t install it that way, you’ll have to find the Suitecrm directory in file manager, go into the directory, and then click the ‘view’ button after selecting the config.php file. Scroll down until you see a block that looks like this which will expose your info:
‘db_host_name’ => ‘localhost’,
‘db_host_instance’ => ‘SQLEXPRESS’,
‘db_user_name’ => ‘yourdatabaseNAMEwillbehere’,
‘db_password’ => ‘randomPASSWORDwillbehere’,
‘db_name’ => ‘yourdatabaseUSERNAMEwillbehere’,
‘db_type’ => ‘mysql’,
‘db_port’ => ”,
‘db_manager’ => ‘MysqliManager’,
Now you have your database file safely saved on your machine as well as a backup of your suitecrm. Nice work.
Step 3 – Rename the Index file.
In your file manager navigate to this spot:
(yes, that’s a lot of indexes!)
Inside this is, no surprise, another index folder! But this is the one we want. Double click on the text and re-name it to ‘index.backup’ from it’s current ‘index’. Just so you know what’s going to happen here is the system will go looking for ‘index’ but because you just renamed it it won’t find it and will create a new one (which is a trick, because that’s what we want, you trickster!). At the same time you’re backing up the old one so bonus.
And that’s it for the work you need to do in your file manager for now.
Step 4 – Stop your Cron Jobs if You Have Them Started (which I’m thinking you do…)
If your Suitecrm is doing workflow stuff and sending alerts, probably your cron jobs are setup so you already know what a cron job is. If not, back up your current cron setting so you can quickly get it up and running again. I just saved this in in a safe place in a text file to use again after completing this stuff.
- a) go to Cron Jobs in cpanel
- b) copy and paste the settings you have into the text file and save it safely somewhere
- c) delete the cron job This makes sure the cron job won’t run while you are doing the next steps. I went a step further, ( not sure if it’s needed ) and changed all my scheduled events in admin/schedules to ‘inactive’ to assure that I could turn them on one at a time later after I turned this on again. I think this was a good move so I’ll advise it next:
Step 5 – Turn all your scheduled jobs in Suite CRM Scheduler to ‘Inactive’
See comments just above.
## Do the Database Work
Ok, now we’re ready to do the stuff that was totally foreign to me but pretty fast and easy once you know how. Go into ‘Phpmyadmin’ section of Cpanel to begin.
Delete Rows from Table aod_index
This one is pretty easy. just find it on the left
… and click it then click the red delete circle and say yes to delete (or was it ‘go’? whatever, you’ll know…)
Delete Rows from aod_indexevent
This next step requires getting rid of WAAAAY too many rows to do by a human. Trust me, I tried before I was forced to find this better and faster way.
This one is a bit more ‘cryptic’ since you have to write a code. But the neat part is yiou know you are doing it right because it auto-fills as you type it.
- a) go to SQL tab at the top of your Phpmyadmin
- b) highlight and delete whatever is in that big white query box at the top if there is anything
- c) Start typing this command and use the tab key (for fun) to autofill when it pops up stuff:
- c) press ‘go’ on the far right
- d) agree when the warning Do you really want to execute “TRUNCATE aod_indexevent”? comes up
Boom. Done. Now we have to turn everything back on.
Step 6 – Turn Everything Back On
- 1. your cron job
- 2. your schedulers in admin, but see note below
There are two important admin schedulers related to your searches which need to index. the main one related to above which I believe broke our Global Search was the ‘Optimize AOD Index’ job. SO, for this one what I did was set it to ‘every 2 hours’ after I did the steps above. This would allow me to see an improvement sooner. Then, once I realized it was fixed, I switched it back to ‘every 14 hours’. I’m not sure what a good amount of time is but that seems to be working well for me. SO maybe you could do the same which will allow you to see if its working sooner. It seemed that by the end of the first day mine was fully working again.
Hope this tutorial helps someone as I don’t have developer skills to pay the project back
EDIT: Sorry, I had one weird ‘-yes’ stuck in that first command a while back but have fixed it and this tutorial works again with copy/paste of commands. Sorry for any inconvenience.
I’ll admit I should probably upgrade my printer but… it’s still alive so I won’t. Problem is that now it’s getting harder to install on Ubuntu. Hopefully this will help someone who is havin similar issues. For me it looked like it was installed and working on 16.04 but it wouldn’t print so I reverted to command line because the HPLIP Toolbox seems to no longer be there in the Software Center…
1 Install the HP LIP Thing with GUI with this command in terminal
sudo apt-get install python-qt4 hplip-gui
2 Run the tool with this command:
3 Next, next, next, next, next, I agree, next….
4 Name your printer in ‘Description’5 Save, send test page (if you want), etc.
5 Save, send test page (if you want), etc.
Hope that helps!
Yes, this is the hard way but seems to be the ‘only way’ right now at the time of this blog. Always first check to make sure it’s not simply sitting in the software center before beginning this tutorial.
No, I can’t figure out why the packages aren’t in the Ubuntu software centre.
All I did to make this tutorial was update the wget link from this fine lad’s blog post so thanks Mr. Ji M
For 32-bit system:
For 64-bit system:
To actually install what you just downloaded on both 32-bit & 64-bit run following command:
(hint: as soon as you have hit the 2.5 part and press ‘tab’ button it will auto-fill the rest then just press enter and it starts)
sudo dpkg -i jitsi_2.5-latest_*.deb
When it’s done doing it’s thing then just hit your super button and start typing jitsi and you should find it. However, mine would not work until I did a software update.
I am not sure the best way to trigger the software update but I did it by going through my dash to
s ‘system settings’ then ‘details’ and then click the update button and upon restarting my machine
i went to the dash, searched Jitsi, opened it and it started working.
Before you begin: Always first check in the stock ubuntu software center to make sure that it’s not simply available there first. As of the date of this post it is not, but I expect it will be there very soon. Do not proceed with this tutorial if there is a one click app in the software center 🙂
1 Go to this link on your Ubuntu phone browser, follow the installation instructions.
2 Scroll down until you see the ‘Open Store’ app
Click ‘install’ and it will show you the 4 steps you have to follow. Follow them. Do them. Love them. However, if you aren’t awesome with difficult stuff, I’ll expand on each step:
- download the openstore thing: click it. It will download. Then at bottom of browser, slide up again and it will bring you back to instruction page
- your terminal app is the black thing on your main home screen of phone (image coming). open that.
- to navigate to your downloads file, in your terminal app, type this: cd ~/Downloads
- for the ‘run the command’ simply copy the pkcon install-local – – allow-untrusted openstore.openstore-team_0… stuff’ to your phones clipboard by pushing and holding. Long slide from the right side of your screen. paste it in your terminal with a long push on screen and then enter key by pushing the keyboard icon lower right.
3 Go back to the link above and scroll down until you see the owncloud file sync app and click the ‘install’ button. It will give you a warning that you are about to kill your phone and ruin your life. Accept this because life is short.
4 Install again (you’ll see an orange install button down a bit after the warning screen)
5 Go back to your home screen of phone and the owncloud app will be waiting for you. When you open it enter your owncloud or nextcloud credentials and server location
From here you should be able to connect a shared calendar and also share files and backup files. I’ll do a quick tutorial on that at my next available minute but hopefully this helps a few people out.
I realized years ago that believers live in a very imperfect world. We are fish swimming upstream and there is nothing that the enemy of our soul would love more than to keep us weak and ignorant of God’s holy Word.
I knew that I had to find some form of ‘structure’ around my daily Bible reading. I found that I would get on a spiritual tangent and spend all my time in Proverbs, or shift over to Psalms, or again to the book of Acts for fun and adventure. But if you asked me who Habakkuk was I’d say “Habak who?” Since I knew that every word in the Bible is inspired something had to change.
I then tried a straight read through the Bible for X amount of minutes per day. The problem was that life would happen and I’d lose track and such. I needed something with a bit of ‘drive’ behind it. Something that would push against the desire of my flesh to stop. That’s when I heard about ‘Bible in a year’ idea. The idea is that the whole Bible is divided into daily reading segments so that the whole Bible is consumed in a calendar year. Genius! And so I began.
I spent time on Odb.org and simply clicked their daily Bible reading link but recently I discovered that it was linking to a Bible company whose ethics I can no longer suffer. So last week I disconnected myself from Biblegateway.com since its owned by the questionable company Zondervan.
The only problem was that now I had to search for another website that I could go to that would allow me to check to see where I was at and where I should be at. I found most of the websites either linked to Zondervan, or, didn’t have the audio Bible option (which I like). Most were just a list of 365 days and you had to figure out what day you were on today. Too hard for me.
Thankfully I found this website which appears to have solved my problem. It’s the International Bible Society’s site and although their website defaults to the NIV version (shame on them) at least it has all the features I need and doesn’t send traffic to Zondervan’s site.
I also understand that this great website has a pretty impossible-to-remember URL for people who want to actually go their daily so I made a permanent page here at W.O.T. for you to remember more easily:
This turned out to be *even better* than the program I was on because it also breaks out Psalms and Proverbs into their own daily chunks which is just awesome. Truly Psalms and Proverbs need to be consumed daily and it looks like this program does it. Here is a quick tutorial to set yourself up and navigate the tools:
Also, it is helpful to note that you should right click (or whatever the option is on your device) and ‘open in new tab’ when you click the Bible links because for some reason it doesn’t open a new tab/window automatically.
Although there is an option to change your start date, you may want to consider just starting today and leave it as January 1st. It is useful, I find, to have January 1st always as the start date. I don’t have a lot of explanation as to why but I just find it helps keep momentum.
Finally, you may want to consider doing what I plan which is to drop where I am in my current plan and use this. Mine didn’t have the Psalms/Proverbs section so now everything is different from where I am. I think it’s very worth changing the plan to synchronize with this one.
EDITED October 31, 2016
This tutorial might also work on Ubuntu 14.04, I haven’t tried yet.
I love Ubuntu and I love Hangul but I’m not going to deny it – it’s not hyper-easy to get it running on Ubuntu, not because it’s super hard but because there aren’t any helpful blog posts out there to walk someone through it.
By golly, miss molly, that ends today! Let’s begin…
- Hit the super key and type ‘languages’ and then click/open the “language support” icon as per this:
2. Click ‘install/remove languages’ as per this:
English should be selected already (if your mother-tongue install was English).
3. Choose “korean” from the list, then apply, and wait (a really long time sometimes) while it downloads King Sejong and the kitchen sink…
EDIT! Some have reported not finding the Korean option in this list. I cannot explain why this would be, nor have I experienced this, but I would recommend that if this is your case try logging out completely and logging back in and trying again. Let me know if that helped.
Here is where the non-intuitive stuff starts. You’d think doing the above would be all you need but you need to do a bit more.
EDIT! If you have tried this tutorial before, make sure you *log out* here completely and log back in or you might not see the next “Korean (Hangul) (ibus)” option.
4. Go to the top right of the screen where you see English (En) and click that and you’ll see ‘text entry settings’
Now you will English sitting there all alone.
5. Press the + sign and then type ‘korean’ and select it. Then you’ll see a screen like this. Choose Korean (Hangul) (Ibus).
I had some issues leaving the ‘master keyboard’ (that’s a name I gave it) switching with the default (something with the super key) and so I changed mine to Control + space bar. You can do whatever you want by just clicking in the space where the default is and hitting your favourite combo in on your keyboard. When finished just close the window and your changes will be saved.
Remember, this is *not* the hangul-english keyboard language switching combo. This is the keyboard combo that switches your keyboard from the “English only” (En) one to the “Korean with English capabilities” one.
Now, we’re getting close to being able to angle your Hangul, but just one more critical step that will save you the pulling out of multiple strands of hair.
6. You must now either reboot, or log out and log back in again in order to be able to eat your green eggs with Hangul.
You will know that you have successfully reached Hangul-Land when the top right area that used to say “En” is now a colourful Korean swirl like so:
Although you now have full Korean capabilities, you now must use the keyboard combos found within this Korean keyboard in order to switch between English and Korean. The default combo is shift + space bar, and you can try it out now for a fun test. You may, like me, wish to change this keyboard combo to something else. If you do, go on to the next section.
How to Customize Your Shiny New Korean Keyboard with a Custom Language Toggle Keyboard Combo
Click the colourful swirl and select ‘setup’ as per this:
Next, you will see the Hangul toggle key space with the defaults. If you want to change the keys used to toggle between Korean and English, just click ‘add’ and then, even though it says ‘key’ singular in the pop up, you can hit the key combo with your computer and it will work.
*Warning!* It shows this popup when you hit ‘add’ under the Hangul toggle area, which is *incorrect*. It should say ‘hangul’ not hanja here. Both hanja and hangul display the same pop up box so it just needs a bug report to fix this but I’m too tired at the point of writing this blog…
In this case, I used control +right alt key because I remember using something like that back in the day and it felt comfortable. You can do whatever floats your boat.
아이구! 신기 신기! 오렛동안 한국말 이컴퓨터에서 못했어…. 드디어.
Hope this helps you grow in Ubuntu and Korean!
Ubuntu is by far the best operating system in existence. One of the things that hasn’t been broadcast around much is how Ubuntu is also awesome for business.
If you run a business (or work in one) you will know that PDF files are one of the most standard documents that you work with, or would like to work with. Here is a bullet proof list of things that I’m always dealing with and that Ubuntu solves:
- people sending .jpg or .tiff or .png files instead of PDFs (unprofessional but a reality)
- PDF files being way too big which is unfair to bandwidth, especially if someone will be downloading on a mobile (good percentage chance)
- I need to split a bunch of pages, do something, and then glue them back together again and I don’t want to print it all and scan it
- I need to watermark or stamp a PDF with something
- I need to create a PDF from a word processing document or spreadsheet
These are just some of my regular issues, but great news! All of them will be solved for you in this post, once and for all, and for free.
How to Compress a Big PDF File Without Killing the Quality
This one took me a while, but all you have to do is:
- open a terminal (if you don’t know how, click here)
- Navigate with the terminal to where your over-sized PDF file is (If you don’t know how, go to the section on “File & Directory Commands” on this page.)
- In the gobbly-gook that is sitting in step #4 below, change the ‘OUTPUTFILENAME’ to the name you want the resulting file to be named and the INPUTFILENAME to the name of the file that is too big and is sitting in the directory you just navigated to.
- copy this gobbly gook into your computer clipboard AFTER doing step #3 to it. I would recommend pasting it to a separate text editor (like body of an email) first, do your changes, and then re-pasting it to the terminal) : gs -sDEVICE=pdfwrite -dCompatibilityLevel=1.4 -dPDFSETTINGS=/default -dNOPAUSE -dQUIET -dBATCH -dDetectDuplicateImages -dCompressFonts=true -r150 -sOutputFile=OUTPUTFILENAME.pdf INPUTFILENAME.pdf
- Copy your updated version of the gobbly-gook to the computer’s clipboard
- Paste it to the terminal with this *different* version of control V. If you use the normal paste, it won’t work. Do this: control + Shift (same time) then press ‘v’ and it will paste to the terminal.
- press the enter key and the process will run
You should now have a smaller PDF file that didn’t lose too much quality. There are other versions of this command above which I found killed the quality too much. This one was great for me.
How to Convert a .jpg or a .tiff or a .png File to a PDF File
- Open a terminal (if you don’t know how, click here)
- Navigate with your terminal to where your .jpg or a .tiff or a .png files are (If you don’t know how, go to the section on “File & Directory Commands” on this page.)
- type ‘convert’ and then start typing the name of the file you want to convert. *TIP: after you start typing the file name, you can press ‘tab’ and it will auto fill. If it doesn’t completely auto fill it means there is another file name there similar so you have to type a few more letters and then ‘tab’ again. This saves much time and errors.
- start typing the name of the file you want the newly created PDF to be named. Likely it will be the same as the photo name which is great and convenient because you can use the same TIP above with the tab button and it will auto-fill it quickly. Caution: if you use auto-fill make sure you change the last three letters to ‘.pdf’ so that it will actually open as a pdf!
- Here is what an example command will look like before you press enter: convert photo_document.png photo_document.pdf
- Press enter
If you know how to do basic terminal navigation, this is truly a lightening fast process and super useful. That said, there is probably a light conversion app out there that does this on Ubuntu and I’d like not to use the terminal if possible so please share
How to Take a Multi-Page PDF File and Split Them into Individual Files
- go to the Ubuntu software center search and get “PDF Sam”
- Use the ‘split’ feature
- Mess around with all the options (I don’t have time to do a full tutorial here)
How to Take a Multi-Page PDF File and Split Them at a Certain Point in the File
- go to the Ubuntu software center search and get “PDF Sam”
- Use the ‘split’ feature
- Make sure you choose the ‘split after these pages’ and the file will ‘cut’ right there. I haven’t tried it but I bet you could put a comma in there after each page number you want to split at and split a whole series of pages….
How to Watermark or Stamp or Batch Adjust Multiple Pages on a PDF in 10 Easy Steps
How to Rotate All Pages in a Multi Page PDF File
I wrote this tutorial earlier for this one here.
How to Turn Anything You Can Print into a PDF Document (ie. Emails, web pages, etc)
I wrote this tutorial earlier for this one here.
There are two ways:
1. FROM THE LAUNCHER ON THE LEFT
On the left side of your Ubuntu machine you’ll see the vertical column of apps you can one-click open. Usually the terminal is here. It’s the black box thing with the right-pointing greater than symbol thing and underscore. Click it. It opens.
2. THROUGH THE DASH
- push your super key (aka ‘windows key’ if you have a redeemed machine)
- start typing ‘terminal’
- it shows up
- click it with mouse or use arrow keys to navigate to it and push ‘enter’ key
- it opens
If opened it looks like so:
Unlike my typical tutorial formats, this one will be a near copy/paste from an email I sent to a real person so that other real people can connect this to their real brain and emotions:
I’m going to forewarn you that this email is dripping with anger/frustration so try to just plunder through it and even try to enjoy it if you can….
Apple/mac is nuts. I can’t put into words how much I can’t stand the company.
They do everything under the sun to make their users dumb and compliant – in fact, it’s creepy if you think about this…. I remember now (after this morning) why I full scale boycotted Apple and threw this iPod in the ‘smartphone trash pile’.
I will stop my rant here.
<insulting section about all iphone users removed>
But, back to the solution because at this point I just want to get our calendars working for the next few months, but please let me put in a plug here to strongly consider the company you are supporting and know that yes, there is a way to totally escape the Apple corporation forever. – It’s called Ubuntu. I hope your next move is far away from these guys… I leave it with you and I promise to dedicate all my free time to helping you if/when you are ready to make the move. Until then I hope I never have to turn this stupid thing on again:
Do this in this impossible-to-imagine difficult workaround solution, and I hope by God’s grace that your ‘issue’ is the same one I’m having here which has everything to do with the Fruit Co. and their ‘ways’.,,,
1. go to ‘settings’
2. go to ‘mail/contacts/calendars, etc’
3. add account
4. go to ‘other’ (because they weren’t respectful enough to give calDav and iCal a title or it’s own option space)
5. add calDAV account (*not* calendar subscription because it seems this fruit co can’t make this work without upgrading to the $10,000 phone or buying the latest fruit air laptop to go with it…??)
6. server: YOURSERVER.COM
7. user name: YOURCLOUDUSERNAME
8. password: your cloud password
9. description: your creative name for calendars
10. hit ‘next’
now here is where it gets *real lame*. It will say want to continue without SSL? Sure, no problem:
11. continue (yes, i will move forward without SSL)(why? Because fruit co is not secure so why bother with https? in fact, let’s make it *not work at all*)(let’s encrypt is legit SSL and it doesn’t want to work)
12. you will get “unable to verify account information” error. Why? No reason. Just because they want you to use their systems… but let’s overcome!
14. advanced settings
15. change whatever port number is listed there to 80
16. make sure SSL is off (should be)
17. go back (which somehow saves these settings even though there was no indication saving was happening..?)
18. hit ‘next’
19. but it doesn’t work! cannot verify account details blah blah? why? Because for no explainable reason, the advanced settings just randomly chose its own URL for the calendar – randomly – as if somehow Fruit Corporation is supposed to know where your calendar is hosted? no problem. let’s overcome…
20. hit ‘advanced settings’
21. make sure the ‘account URL’ is set exactly to this: http://YOURSERVER.COM:80/YOURSUBDIRECTORY/remote.php/dav/principals/users/YOURUSERNAME/
22. go back
23. done (which somehow means save?)
Here is a summary of what the two screens should look like to make it more simple to make sure you ‘followed their rules’
user name: YOURCLOUDUSERNAME
password: YOUR CLOUD PASSWORD
description: some long url probably
2. advanced settings screen
use ssl: off
account url: http://YOURSERVER.COM:80/YOURSUBDIRECTORY/remote.php/dav/principals/users/YOURCLOUDUSERNAME/
Now, you *BETTER* report back to me that this @#$#$@#$@#$@#$ is working or I’ll @#$@#$
<SMASHES FACE ON DESK>
Wayne Out There
I have a great group of people around me. Thoughtful people. Thought-provoking people. People who rub me the wrong way and who challenge me to grow and think critically. These fine people send me articles that they read and most of them are good.
But once in a while, one of these articles stops me in my tracks and when I’m done all I can say is
“Wow…. I’m going to re-blog that now.”
This article entitled “Peak Indifference” is truly a winner.
Why am I so excited? Because it says everything I want to say to people and now I don’t have to write it.
Do yourself a favour. When you read this, don’t just sit there like a toad and say “Yeah I should do something.” Just start. If you don’t know what to do next, reply to this post and I’ll be motivated to start helping you down the journey.
Privacy is a long journey. I’m not there yet but I’m way further than I was 5 years ago. Except for a few foolish bread crumbs I’ve left around the internet, I’m starting to lose online importance which is just plain awesome.
Here’s the article again in case you didn’t click and read it yet.