Norse Technologies Knowledge Base Free Knowledge Articles

The system won’t boot with the normal default configuration that GRUB assigns. The APIC or something related causes the system to go to a blank screen and stay there. Manually change these settings at boot time, or permanently change them in /etc/default/grub

GRUB_CMDLINE_LINUX=”nolapic nohz=off”

Posted under Linux, Operating System

Thanks to Mike Dent’s efforts and OTRS, we now know how a CSV file can be imported into the MySQL database directly. Here is the sample code:

mysql> load data infile '/tmp/otrs_test.txt' into table customer_user
fields terminated by '\t' lines terminated by '\r' (first_name,
last_name, address, postcode, phone1, email, customer_id, valid_id,
create_time, create_by, change_time, change_by, login);

Make sure to import all the required fields (that is, the ones that the database requires, see the table schema for details, >show table x;)

Posted under Freeware, MySQL, WebDev

Using conditional formatting one may easily show duplicate values in any chosen range of data. Find all duplicate values, and highlight any values that appear more than once.

=COUNTIF(A:A,A2)>1

This is the meat, and here is how:

• Highlight the cell to work on.
• Click Format > Conditional Formatting
• Set Formula Is
• Enter the formula above, replacing the ranges as follows:
  • (A:A means that it will look inside the entire A range. Replace this with your own range, e.g. B3:B5 or CC:CC
  • ,A2) means to count how many times the value in A2 appears in the designated range. This needs to match the cell you are currently working on.
• Then set the format you want to see when the count of identical values existing in the range is greater than one. This value can be altered to a higher number in order to highlight cells that have more than two duplicates, e.g. change it to be >5 to highlight the cell when at least 5 cells have the same value as the current cell, including this cell itself.
• Copy the formula only to other cells in the range. To do this, copy the current cell, then Paste Special and choose Formulas and paste into the other cells in the range.

An excellent tutorial is at MREXCEL.COM, and thanks to that site for this knowledge and info.

Posted under Excel, Microsoft, Office

Ran across this installing Red Hat’s free Linux distribution Fedora Core 9 code named Suplhur. Installed totally vanilla install with the GUI anaconda front end. The box sees the NIC, and can ping within the local subnet of the LAN network, but can’t ping out. BTW, it holds a static IP on the network interface card (NIC). Gets the error:

connect: Network is unreachable error

We need to set a default route. Here’s how:

Looked in /etc/sysconfig/network-scripts for the file route-eth0 but it wasn’t there.

Using vi (you can use whichever text editor you prefer) I created that file route-eth0, and put in this one line:

defult via 192.168.0.1

(note: 192.168.0.1 is the LAN IP address of my router. Your router IP address may differ. So you should put in whatever the IP addres of your router is, instead. Most Netgear routers and Qwest DSL boradband modems use 192.168.0.1 and Linksys uses 192.168.1.1 and Belkin uses 192.168.2.1 just to name some common ones.)

Then a simple task of restarting the network and testing:

# service network restart

# ping yahoo.com

Success!

Also, I found that the ethernet adapters weren’t starting automatically. Using the GUI taskbar/ Start Menu, I went into System Administration, then into Services, and enabled the “network” service. Then change runlevel to 3. Ping works so eth0 is up, and that happened at the runlevel change. Change to runlevel 5, test, and… yeppers, it works.

Posted under Freeware, Linux, Network

This applies to (at least) OTRS 2.2 on Fedora Core 6 running Apache 2:

To fix this, change the following in the file /etc/httpd/conf.c/otrs.conf
Find the line that reads “Deny from All”, and comment it out by placing a # at the beginning of the line.

Save the file.

Restart Apache

# service httpd restart

Now try browsing your webserver otrs from other machines, success!

Posted under Linux, WebDev