Configuring Netcool Omnibus 7.4 on SLES 11

Please note that this is NOT a detailed installation information just made notes to myself not to forget how I got this sorted 🙂

1: Install the product from the provided media

2: Create the object server by running the following command

sudo ./nco_dbinit

This will create the default object sever NCOMS.

3: Edit the omni.dat file

The omni.dat file has to be edited. The defined “omnihost” hostname has to be replaced with the server’s hostname. This file is located at ./netcool/etc/ directory NOT in ./netcool/omnibus/etc directory. The replacable sections are highlighted below:

#
# omni.dat file as prototype for interfaces file
#
# Ident: $Id: omni.dat 1.5 1999/07/13 09:34:20 chris Development $
#
[NCOMS]
{
Primary: omnihost 4100
}
[NCO_GATE]
{
Primary: omnihost 4300
}
[NCO_PA]
{
Primary: omnihost 4200
}
[NCO_PROXY]
{
Primary: omnihost 4400
}

4: Create the interfaces with nco_igen or nco_xgen command. This will generate the interface file in ./netcool/etc using the data provided in omni.dat

-rw-rw-r– 1 root root 3928 Mar 14 10:06 tds.dat
drwxrwxr-x 3 root root 4096 Mar 14 10:07 security
drwxrwxr-x 2 root root 4096 Mar 14 10:08 default
-rw-r–r– 1 root root    0 Mar 14 15:13 interfaces
-rw-rw-r– 1 root root  283 Mar 14 15:21 omni.dat
-rw-r–r– 1 root root  664 Mar 14 15:23 interfaces.linux2x86

5: Create group ncoadmin and add administrative users to that group. Only users belonging to this group can execute process control commands.

6: Define ncoadmin as admin group using  ./nco_pad -admingroup ncoadmin command

8: Define IDUC port. This will fix the IDUC port to any specified port number. If this is not done a random available port will be used. Add the following line to /etc/services

nco_NCOMS 3832/tcp

7: Make Omnibus server PA ware by adding the hostname at ./netcool/omnibus/etc/nco_pa.conf

nco_process ‘MasterObjectServer’
{
Command ‘$OMNIHOME/bin/nco_objserv -name NCOMS -pa NCO_PA’ run as 0
Host            =       ‘yourhostname
Managed         =       True
RestartMsg      =       ‘${NAME} running as ${EUID} has been restored on ${HOST}.’
AlertMsg        =       ‘${NAME} running as ${EUID} has died on ${HOST}.’
RetryCount      =       0
ProcessType     =       PaPA_AWARE
}

8: Start process control in ./netcool/omnibus/bin/

./nco_pad -name NCO_PA

9. Start omnibus server

./netcool/omnibus/bin/nco_pa_start -process MasterObjectServer

10. Check status of Omnibus Server

./netcool/omnibus/bin # ./nco_pa_status
Login Password:
——————————————————————————-
Service Name         Process Name         Hostname   User      Status      PID
——————————————————————————-
Core                 MasterObjectServer   omnihost   root      RUNNING   12830
——————————————————————————-

Configuring Tivoli Common Reporting with DB2 and ITM Warehouse Database on AIX

The ITM Warehouse database has to be added as a Data Source Connection to Tivoli Common Reporting. To be able to do that we have no make sure that the Tivoli Common Reporting server sees the native DB2 libraries.

We had to edit the startTCRserver.sh file to add additional environment variables to achieve this.

We have added the path to the DB2 32 bit libraries since Tivoli Common Reporting expects 32 bit libraries even though you system is 64 bit:

LIBPATH=/opt/IBM/DB2/V9.7/lib32
export LIBPATH

In some cases you might also need to source the DB2 environment variables:

. /home/[db2instance]/sqllib/db2profile

Once these are done log in to the Tivoli Integrated Portal and go to the following:

Go to Reporting -> Common Reporting

Go to Launch drop-down list, and choose the Administration.

Select Configuration tab and Data Source Connections

Then select the New Data Source icon on the upper right corner of the browser window.

Type the name of the datasource and press next. We used tdw21 as datasource name.

Select DB2 from the drop down menu then click next

Fill in the database name and connection string. The database connection string should look the following:

jdbc:db2://[database-server-hostname]:[db2-connection-port]/[db2-database-name]

In our case it is:

jdbc:db2://localhost:50000/WAREHOUS

Then fill in the database connection user id and password on the bottom of the page and press the “test connection” link.

If everything went fine you should see that the connection has succeeded. Save the database settings at the next window and your DB2 database is now setup.

Clean up DJANGO_SESSION table automatically.

Unfortunately Django doesn’t clean up the sessions table so you could end up having hundreds of thousands of entries slowing down the backup and restore procedure tremendously. To fix this issue please follow this guide.

First all we need to create an SQL script that will move data around to keep the current sessions only. I am using the code published on djangosnippets.org.

DROP TABLE IF EXISTS `django_session_cleaned`;
CREATE TABLE `django_session_cleaned` (
`session_key` varchar(40) NOT NULL,
`session_data` longtext NOT NULL,
`expire_date` datetime NOT NULL,
PRIMARY KEY  (`session_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `django_session_cleaned` SELECT * FROM `django_session` WHERE `expire_date` > now();

RENAME TABLE `django_session` TO `django_session_old_master`, `django_session_cleaned` TO `django_session`;

DROP TABLE `django_session_old_master`;

Now we need to automate the cleanup process. We need to run this script from every day at a given time. The command to run this script from the command line is:

mysql -u [username] -p[password-no-space-between-p-and-password]  [database_name] < cleanup.sql

We added this command to the cleanup.sh shell script which is then scheduled to run at 2.00am every day.

Prestashop currency ISO codes

AFGHANISTAN Afghani AFN 971 2
ÅLAND ISLANDS Euro EUR 978 2
ALBANIA Lek ALL 008 2
ALGERIA Algerian Dinar DZD 012 2
AMERICAN SAMOA US Dollar USD 840 2
ANDORRA Euro EUR 978 2
ANGOLA Kwanza AOA 973 2
ANGUILLA East Caribbean Dollar XCD 951 2
ANTARCTICA No universal currency


ANTIGUA AND BARBUDA East Caribbean Dollar XCD 951 2
ARGENTINA Argentine Peso ARS 032 2
ARMENIA Armenian Dram AMD 051 2
ARUBA Aruban Florin AWG 533 2
AUSTRALIA Australian Dollar AUD 036 2
AUSTRIA Euro EUR 978 2
AZERBAIJAN Azerbaijanian Manat AZN 944 2
BAHAMAS Bahamian Dollar BSD 044 2
BAHRAIN Bahraini Dinar BHD 048 3
BANGLADESH Taka BDT 050 2
BARBADOS Barbados Dollar BBD 052 2
BELARUS Belarussian Ruble BYR 974 0
BELGIUM Euro EUR 978 2
BELIZE Belize Dollar BZD 084 2
BENIN CFA Franc BCEAO XOF 952 0
BERMUDA Bermudian Dollar BMD 060 2
BHUTAN Ngultrum BTN 064 2
BHUTAN Indian Rupee INR 356 2
BOLIVIA, PLURINATIONAL STATE OF Boliviano BOB 068 2
BOLIVIA, PLURINATIONAL STATE OF Mvdol BOV 984 2
BONAIRE, SINT EUSTATIUS AND SABA US Dollar USD 840 2
BOSNIA AND HERZEGOVINA Convertible Mark BAM 977 2
BOTSWANA Pula BWP 072 2
BOUVET ISLAND Norwegian Krone NOK 578 2
BRAZIL Brazilian Real BRL 986 2
BRITISH INDIAN OCEAN TERRITORY US Dollar USD 840 2
BRUNEI DARUSSALAM Brunei Dollar BND 096 2
BULGARIA Bulgarian Lev BGN 975 2
BURKINA FASO CFA Franc BCEAO XOF 952 0
BURUNDI Burundi Franc BIF 108 0
CAMBODIA Riel KHR 116 2
CAMEROON CFA Franc BEAC XAF 950 0
CANADA Canadian Dollar CAD 124 2
CAPE VERDE Cape Verde Escudo CVE 132 2
CAYMAN ISLANDS Cayman Islands Dollar KYD 136 2
CENTRAL AFRICAN REPUBLIC CFA Franc BEAC XAF 950 0
CHAD CFA Franc BEAC XAF 950 0
CHILE Unidades de fomento CLF 990 0
CHILE Chilean Peso CLP 152 0
CHINA Yuan Renminbi CNY 156 2
CHRISTMAS ISLAND Australian Dollar AUD 036 2
COCOS (KEELING) ISLANDS Australian Dollar AUD 036 2
COLOMBIA Colombian Peso COP 170 2
COLOMBIA Unidad de Valor Real COU 970 2
COMOROS Comoro Franc KMF 174 0
CONGO CFA Franc BEAC XAF 950 0
CONGO, THE DEMOCRATIC REPUBLIC OF Congolese Franc CDF 976 2
COOK ISLANDS New Zealand Dollar NZD 554 2
COSTA RICA Costa Rican Colon CRC 188 2
CÔTE D’IVOIRE CFA Franc BCEAO XOF 952 0
CROATIA Croatian Kuna HRK 191 2
CUBA Peso Convertible CUC 931 2
CUBA Cuban Peso CUP 192 2
CURAÇAO Netherlands Antillean Guilder ANG 532 2
CYPRUS Euro EUR 978 2
CZECH REPUBLIC Czech Koruna CZK 203 2
DENMARK Danish Krone DKK 208 2
DJIBOUTI Djibouti Franc DJF 262 0
DOMINICA East Caribbean Dollar XCD 951 2
DOMINICAN REPUBLIC Dominican Peso DOP 214 2
ECUADOR US Dollar USD 840 2
EGYPT Egyptian Pound EGP 818 2
EL SALVADOR El Salvador Colon SVC 222 2
EL SALVADOR US Dollar USD 840 2
EQUATORIAL GUINEA CFA Franc BEAC XAF 950 0
ERITREA Nakfa ERN 232 2
ESTONIA Euro EUR 978 2
ETHIOPIA Ethiopian Birr ETB 230 2
EUROPEAN UNION Euro EUR 978 2
FALKLAND ISLANDS (MALVINAS) Falkland Islands Pound FKP 238 2
FAROE ISLANDS Danish Krone DKK 208 2
FIJI Fiji Dollar FJD 242 2
FINLAND Euro EUR 978 2
FRANCE Euro EUR 978 2
FRENCH GUIANA Euro EUR 978 2
FRENCH POLYNESIA CFP Franc XPF 953 0
FRENCH SOUTHERN TERRITORIES Euro EUR 978 2
GABON CFA Franc BEAC XAF 950 0
GAMBIA Dalasi GMD 270 2
GEORGIA Lari GEL 981 2
GERMANY Euro EUR 978 2
GHANA Ghana Cedi GHS 936 2
GIBRALTAR Gibraltar Pound GIP 292 2
GREECE Euro EUR 978 2
GREENLAND Danish Krone DKK 208 2
GRENADA East Caribbean Dollar XCD 951 2
GUADELOUPE Euro EUR 978 2
GUAM US Dollar USD 840 2
GUATEMALA Quetzal GTQ 320 2
GUERNSEY Pound Sterling GBP 826 2
GUINEA Guinea Franc GNF 324 0
GUINEA-BISSAU CFA Franc BCEAO XOF 952 0
GUYANA Guyana Dollar GYD 328 2
HAITI Gourde HTG 332 2
HAITI US Dollar USD 840 2
HEARD ISLAND AND McDONALD ISLANDS Australian Dollar AUD 036 2
HOLY SEE (VATICAN CITY STATE) Euro EUR 978 2
HONDURAS Lempira HNL 340 2
HONG KONG Hong Kong Dollar HKD 344 2
HUNGARY Forint HUF 348 2
ICELAND Iceland Krona ISK 352 0
INDIA Indian Rupee INR 356 2
INDONESIA Rupiah IDR 360 2
INTERNATIONAL MONETARY FUND (IMF)  SDR (Special Drawing Right) XDR 960 N.A.
IRAN, ISLAMIC REPUBLIC OF Iranian Rial IRR 364 2
IRAQ Iraqi Dinar IQD 368 3
IRELAND Euro EUR 978 2
ISLE OF MAN Pound Sterling GBP 826 2
ISRAEL New Israeli Sheqel ILS 376 2
ITALY Euro EUR 978 2
JAMAICA Jamaican Dollar JMD 388 2
JAPAN Yen JPY 392 0
JERSEY Pound Sterling GBP 826 2
JORDAN Jordanian Dinar JOD 400 3
KAZAKHSTAN Tenge KZT 398 2
KENYA Kenyan Shilling KES 404 2
KIRIBATI Australian Dollar AUD 036 2
KOREA, DEMOCRATIC PEOPLE’S REPUBLIC OF North Korean Won KPW 408 2
KOREA, REPUBLIC OF Won KRW 410 0
KUWAIT Kuwaiti Dinar KWD 414 3
KYRGYZSTAN Som KGS 417 2
LAO PEOPLE’S DEMOCRATIC REPUBLIC Kip LAK 418 2
LATVIA Latvian Lats LVL 428 2
LEBANON Lebanese Pound LBP 422 2
LESOTHO Loti LSL 426 2
LESOTHO Rand ZAR 710 2
LIBERIA Liberian Dollar LRD 430 2
LIBYA Libyan Dinar LYD 434 3
LIECHTENSTEIN Swiss Franc CHF 756 2
LITHUANIA Lithuanian Litas LTL 440 2
LUXEMBOURG Euro EUR 978 2
MACAO Pataca MOP 446 2
MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF Denar MKD 807 2
MADAGASCAR Malagasy Ariary MGA 969 2
MALAWI Kwacha MWK 454 2
MALAYSIA Malaysian Ringgit MYR 458 2
MALDIVES Rufiyaa MVR 462 2
MALI CFA Franc BCEAO XOF 952 0
MALTA Euro EUR 978 2
MARSHALL ISLANDS US Dollar USD 840 2
MARTINIQUE Euro EUR 978 2
MAURITANIA Ouguiya MRO 478 2
MAURITIUS Mauritius Rupee MUR 480 2
MAYOTTE Euro EUR 978 2
MEMBER COUNTRIES OF THE AFRICAN DEVELOPMENT BANK GROUP ADB Unit of Account XUA 965 N.A.
MEXICO Mexican Peso MXN 484 2
MEXICO Mexican Unidad de Inversion (UDI) MXV 979 2
MICRONESIA, FEDERATED STATES OF US Dollar USD 840 2
MOLDOVA, REPUBLIC OF Moldovan Leu MDL 498 2
MONACO Euro EUR 978 2
MONGOLIA Tugrik MNT 496 2
MONTENEGRO Euro EUR 978 2
MONTSERRAT East Caribbean Dollar XCD 951 2
MOROCCO Moroccan Dirham MAD 504 2
MOZAMBIQUE Mozambique Metical MZN 943 2
MYANMAR Kyat MMK 104 2
NAMIBIA Namibia Dollar NAD 516 2
NAMIBIA Rand ZAR 710 2
NAURU Australian Dollar AUD 036 2
NEPAL Nepalese Rupee NPR 524 2
NETHERLANDS Euro EUR 978 2
NEW CALEDONIA CFP Franc XPF 953 0
NEW ZEALAND New Zealand Dollar NZD 554 2
NICARAGUA Cordoba Oro NIO 558 2
NIGER CFA Franc BCEAO XOF 952 0
NIGERIA Naira NGN 566 2
NIUE New Zealand Dollar NZD 554 2
NORFOLK ISLAND Australian Dollar AUD 036 2
NORTHERN MARIANA ISLANDS US Dollar USD 840 2
NORWAY Norwegian Krone NOK 578 2
OMAN Rial Omani OMR 512 3
PAKISTAN Pakistan Rupee PKR 586 2
PALAU US Dollar USD 840 2
PALESTINIAN TERRITORY, OCCUPIED No universal currency


PANAMA Balboa PAB 590 2
PANAMA US Dollar USD 840 2
PAPUA NEW GUINEA Kina PGK 598 2
PARAGUAY Guarani PYG 600 0
PERU Nuevo Sol PEN 604 2
PHILIPPINES Philippine Peso PHP 608 2
PITCAIRN New Zealand Dollar NZD 554 2
POLAND Zloty PLN 985 2
PORTUGAL Euro EUR 978 2
PUERTO RICO US Dollar USD 840 2
QATAR Qatari Rial QAR 634 2
RÉUNION Euro EUR 978 2
ROMANIA New Romanian Leu RON 946 2
RUSSIAN FEDERATION Russian Ruble RUB 643 2
RWANDA Rwanda Franc RWF 646 0
SAINT BARTHÉLEMY Euro EUR 978 2
SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA Saint Helena Pound SHP 654 2
SAINT KITTS AND NEVIS East Caribbean Dollar XCD 951 2
SAINT LUCIA East Caribbean Dollar XCD 951 2
SAINT MARTIN (FRENCH PART) Euro EUR 978 2
SAINT PIERRE AND MIQUELON Euro EUR 978 2
SAINT VINCENT AND THE GRENADINES East Caribbean Dollar XCD 951 2
SAMOA Tala WST 882 2
SAN MARINO Euro EUR 978 2
SAO TOME AND PRINCIPE Dobra STD 678 2
SAUDI ARABIA Saudi Riyal SAR 682 2
SENEGAL CFA Franc BCEAO XOF 952 0
SERBIA Serbian Dinar RSD 941 2
SEYCHELLES Seychelles Rupee SCR 690 2
SIERRA LEONE Leone SLL 694 2
SINGAPORE Singapore Dollar SGD 702 2
SINT MAARTEN (DUTCH PART) Netherlands Antillean Guilder ANG 532 2
SISTEMA UNITARIO DE COMPENSACION REGIONAL DE PAGOS “SUCRE” Sucre XSU 994 N.A.
SLOVAKIA Euro EUR 978 2
SLOVENIA Euro EUR 978 2
SOLOMON ISLANDS Solomon Islands Dollar SBD 090 2
SOMALIA Somali Shilling SOS 706 2
SOUTH AFRICA Rand ZAR 710 2
SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS No universal currency


SOUTH SUDAN South Sudanese Pound SSP 728 2
SPAIN Euro EUR 978 2
SRI LANKA Sri Lanka Rupee LKR 144 2
SUDAN Sudanese Pound SDG 938 2
SURINAME Surinam Dollar SRD 968 2
SVALBARD AND JAN MAYEN Norwegian Krone NOK 578 2
SWAZILAND Lilangeni SZL 748 2
SWEDEN Swedish Krona SEK 752 2
SWITZERLAND WIR Euro CHE 947 2
SWITZERLAND Swiss Franc CHF 756 2
SWITZERLAND WIR Franc CHW 948 2
SYRIAN ARAB REPUBLIC Syrian Pound SYP 760 2
TAIWAN, PROVINCE OF CHINA New Taiwan Dollar TWD 901 2
TAJIKISTAN Somoni TJS 972 2
TANZANIA, UNITED REPUBLIC OF Tanzanian Shilling TZS 834 2
THAILAND Baht THB 764 2
TIMOR-LESTE US Dollar USD 840 2
TOGO CFA Franc BCEAO XOF 952 0
TOKELAU New Zealand Dollar NZD 554 2
TONGA Pa’anga TOP 776 2
TRINIDAD AND TOBAGO Trinidad and Tobago Dollar TTD 780 2
TUNISIA Tunisian Dinar TND 788 3
TURKEY Turkish Lira TRY 949 2
TURKMENISTAN Turkmenistan New Manat TMT 934 2
TURKS AND CAICOS ISLANDS US Dollar USD 840 2
TUVALU Australian Dollar AUD 036 2
UGANDA Uganda Shilling UGX 800 2
UKRAINE Hryvnia UAH 980 2
UNITED ARAB EMIRATES UAE Dirham AED 784 2
UNITED KINGDOM Pound Sterling GBP 826 2
UNITED STATES US Dollar USD 840 2
UNITED STATES US Dollar (Next day) USN 997 2
UNITED STATES US Dollar (Same day) USS 998 2
UNITED STATES MINOR OUTLYING ISLANDS US Dollar USD 840 2
URUGUAY Uruguay Peso en Unidades Indexadas (URUIURUI) UYI 940 0
URUGUAY Peso Uruguayo UYU 858 2
UZBEKISTAN Uzbekistan Sum UZS 860 2
VANUATU Vatu VUV 548 0
Vatican City State (HOLY SEE) Euro EUR 978 2
VENEZUELA, BOLIVARIAN REPUBLIC OF Bolivar Fuerte VEF 937 2
VIET NAM Dong VND 704 0
VIRGIN ISLANDS (BRITISH) US Dollar USD 840 2
VIRGIN ISLANDS (US) US Dollar USD 840 2
WALLIS AND FUTUNA CFP Franc XPF 953 0
WESTERN SAHARA Moroccan Dirham MAD 504 2
YEMEN Yemeni Rial YER 886 2
ZAMBIA Zambian Kwacha ZMK 894 2
ZIMBABWE Zimbabwe Dollar ZWL 932 2
ZZ01_Bond Markets Unit European_EURCO Bond Markets Unit European Composite Unit (EURCO) XBA 955 N.A.
ZZ02_Bond Markets Unit European_EMU-6 Bond Markets Unit European Monetary Unit (E.M.U.-6) XBB 956 N.A.
ZZ03_Bond Markets Unit European_EUA-9 Bond Markets Unit European Unit of Account 9 (E.U.A.-9) XBC 957 N.A.
ZZ04_Bond Markets Unit European_EUA-17 Bond Markets Unit European Unit of Account 17 (E.U.A.-17) XBD 958 N.A.
ZZ05_UIC-Franc UIC-Franc XFU Nil N.A.
ZZ06_Testing_Code Codes specifically reserved for testing purposes XTS 963 N.A.
ZZ07_No_Currency The codes assigned for transactions where no currency is involved XXX 999 N.A.
ZZ08_Gold Gold XAU 959 N.A.
ZZ09_Palladium Palladium XPD 964 N.A.
ZZ10_Platinum Platinum XPT 962 N.A.
ZZ11_Silver Silver XAG 961 N.A.

How to check if product support for TEPS / ITM6 is correctly installed

After installing the specific product support, check if the files are correctly added. Find out what the product code is and run find for that pattern, in this example we will be using Tivoli Network Manager IP Agent. The product code for this is NP or KNP.

find . -name knp*
./aix536/cq/sqllib/knp.his
./aix536/cq/sqllib/knp_kcj.sql
./aix536/cq/sqllib/knppackage.xml
./aix536/cw/classes/candle/knp
./aix536/cw/classes/candle/knp/resources/help/de/knp_contents.htm
./aix536/cw/classes/candle/knp/resources/help/de/knp_home.htm
./aix536/cw/classes/candle/knp/resources/help/de/knp_notices.htm
./aix536/cw/classes/candle/knp/resources/help/de/knp_trademarks.htm
./aix536/cw/classes/candle/knp/resources/help/es/knp_contents.htm
./aix536/cw/classes/candle/knp/resources/help/es/knp_home.htm
./aix536/cw/classes/candle/knp/resources/help/es/knp_notices.htm
./aix536/cw/classes/candle/knp/resources/help/es/knp_trademarks.htm
./aix536/cw/classes/candle/knp/resources/help/fr/knp_contents.htm
./aix536/cw/classes/candle/knp/resources/help/fr/knp_home.htm
./aix536/cw/classes/candle/knp/resources/help/fr/knp_notices.htm
./aix536/cw/classes/candle/knp/resources/help/fr/knp_trademarks.htm
./aix536/cw/classes/candle/knp/resources/help/hu/knp_contents.htm
./aix536/cw/classes/candle/knp/resources/help/hu/knp_home.htm
./aix536/cw/classes/candle/knp/resources/help/hu/knp_notices.htm
./aix536/cw/classes/candle/knp/resources/help/hu/knp_trademarks.htm
./aix536/cw/classes/candle/knp/resources/help/it/knp_contents.htm
./aix536/cw/classes/candle/knp/resources/help/it/knp_home.htm
./aix536/cw/classes/candle/knp/resources/help/it/knp_notices.htm
./aix536/cw/classes/candle/knp/resources/help/it/knp_trademarks.htm
./aix536/cw/classes/candle/knp/resources/help/ja/knp_contents.htm
./aix536/cw/classes/candle/knp/resources/help/ja/knp_home.htm
./aix536/cw/classes/candle/knp/resources/help/ja/knp_notices.htm
./aix536/cw/classes/candle/knp/resources/help/ja/knp_trademarks.htm
./aix536/cw/classes/candle/knp/resources/help/knp_contents.htm
./aix536/cw/classes/candle/knp/resources/help/knp_home.htm
./aix536/cw/classes/candle/knp/resources/help/knp_notices.htm
./aix536/cw/classes/candle/knp/resources/help/knp_trademarks.htm
./aix536/cw/classes/candle/knp/resources/help/ko/knp_contents.htm
./aix536/cw/classes/candle/knp/resources/help/ko/knp_home.htm
./aix536/cw/classes/candle/knp/resources/help/ko/knp_notices.htm
./aix536/cw/classes/candle/knp/resources/help/ko/knp_trademarks.htm
./aix536/cw/classes/candle/knp/resources/help/pl/knp_contents.htm
./aix536/cw/classes/candle/knp/resources/help/pl/knp_home.htm
./aix536/cw/classes/candle/knp/resources/help/pl/knp_notices.htm
./aix536/cw/classes/candle/knp/resources/help/pl/knp_trademarks.htm
./aix536/cw/classes/candle/knp/resources/help/pt_BR/knp_contents.htm
./aix536/cw/classes/candle/knp/resources/help/pt_BR/knp_home.htm
./aix536/cw/classes/candle/knp/resources/help/pt_BR/knp_notices.htm
./aix536/cw/classes/candle/knp/resources/help/pt_BR/knp_trademarks.htm
./aix536/cw/classes/candle/knp/resources/help/ru/knp_contents.htm
./aix536/cw/classes/candle/knp/resources/help/ru/knp_home.htm
./aix536/cw/classes/candle/knp/resources/help/ru/knp_notices.htm
./aix536/cw/classes/candle/knp/resources/help/ru/knp_trademarks.htm
./aix536/cw/classes/candle/knp/resources/help/zh_CN/knp_contents.htm
./aix536/cw/classes/candle/knp/resources/help/zh_CN/knp_home.htm
./aix536/cw/classes/candle/knp/resources/help/zh_CN/knp_notices.htm
./aix536/cw/classes/candle/knp/resources/help/zh_CN/knp_trademarks.htm
./aix536/cw/classes/candle/knp/resources/help/zh_TW/knp_contents.htm
./aix536/cw/classes/candle/knp/resources/help/zh_TW/knp_home.htm
./aix536/cw/classes/candle/knp/resources/help/zh_TW/knp_notices.htm
./aix536/cw/classes/candle/knp/resources/help/zh_TW/knp_trademarks.htm
./aix536/cw/classes/knp_resources.jar
./aix536/cw/knp.inf
./config/.ConfigData/.tmp/knpenv
./config/.ConfigData/knpenv

Check if the applet.html is properly updated, grep for knp on your applet.html. This file is located in different directories in each platform, if you are unsure where it is just do a find for it:

find . -name applet.html
./aix536/cw/applet.html

grep -i knp ./aix536/cw/applet.html

optimizeArchiveOrder( ‘<PARAM NAME = CACHE_ARCHIVE VALUE=”cnp_vbjorball.jar, kjrall.jar,         util.jar,  chart.jar, ae.jar,             cnp_jviewsall.jar, terminal.jar, browser.jar, browser-@P.jar, browser-core-@P.jar, icu4jm32.jar, deploy.jar,         cnp_ps.jar, cnp.jar,            kum_resources.jar,  kdy_resources.jar,  kis_resources.jar, koq_resources.jar, kqb_resources.jar, kq7_resources.jar, kqf_resources.jar, koy_resources.jar, kq5_resources.jar, klz_resources.jar,  kno_resources.jar, kqp_resources.jar, ism.jar, kp5_resources.jar, kqr_resources.jar, kqv_resources.jar, ka4_resources.jar,  kex_resources.jar, kph_resources.jar, nvnways.jar,         kqx_resources.jar, kdp_resources.jar,  kib_resources.jar, kr2_resources.jar, log4j-1.1.1.jar,     kr6_resources.jar, km5.jar,  kpx_resources.jar, ksy_resources.jar, kmq_resources.jar, kr4_resources.jar, jrim.jar,            console.jar,         kgw_resources.jar,  kud_resources.jar, kpv_resources.jar, k99_resources.jar, kul_resources.jar,  kip_resources.jar,  kn3_resources.jar,  khd_resources.jar, kor_resources.jar, kcp_resources.jar,  klo_resources.jar, commons-codec-1.3.jar, k3z_resources.jar, kcf.jar, k87_resources.jar, jsafe.zip,           kqi_resources.jar, kux_resources.jar,  ibmjsse.jar,         kht_resources.jar, kva_resources.jar, ks3.jar,            jcf.jar,             kmc.jar, kgb_resources.jar, kpk_resources.jar, km5_resources.jar, ks3_resources.jar,  tec_tap.jar,         khv_resources.jar, uif.jar,             knt_resources.jar,  nways_dep.jar,       launch.jar,          kr3_resources.jar, kvm_resources.jar, jhall.jar,           kyn_resources.jar, kit.jar,             kr5_resources.jar, k07_resources.jar, knp_resources.jar,”>’ );

/opt/IBM/ITM/bin/cinfo -i

Look for the product from the list.

np      IBM Tivoli Network Manager
tps     Version: 03.90.00.00
tpw     Version: 03.90.00.00

/opt/IBM/ITM/bin/tacmd listworkspaces |grep knp

Application Type: knp
Application Type: knp
Application Type: knp
Application Type: knp
Application Type: knp

If there knp can not be found in applet.html or in the listworkspaces the TEPS server will have to be reconfigured. This will kick off the InstallPresentation.sh script which will then configure the support correctly. This can be achieved in the following 2 ways:

/opt/IBM/ITM/bin/itmcmd config -A cq <- this will reconfig the entire TEPS server

./itmcmd execute cq <ITMHOME>/arch/cq/bin/InstallPresentation.sh <- this will only configure the things you need and it can also be run as a non-root user.

 

Matrice – Prestashop 1.4.3 – Undefined variable: nb_products FIX

I am rebuilding one of our webshops and run into this nasty error when clicking on the home category from the TOP navigation menu.

Notice: Undefined variable: nb_products in /var/www/html/shopname/tools/smarty/sysplugins/smarty_internal_data.php on line 291 There are no products.

We are using the Matrice theme which is truly amazing however there seems to be an issue here with it. If you run into the same as a quick fix just change the following in the category.tpl:

 

{if $nb_products == 0}{l s=’There are no products.’}

{else}

{if $nb_products == 1}{l s=’There is’}{else}{l s=’There are’}{/if}&#160;
{$nb_products}&#160;
{if $nb_products == 1}{l s=’product.’}{else}{l s=’products.’}{/if}

{/if}

 

to

<!–

{if $nb_products == 0}{l s=’There are no products.’}

{else}

–>

{if $nb_products == 1}{l s=’There is’}{else}{l s=’There are’}{/if}&#160;
{$nb_products}&#160;
{if $nb_products == 1}{l s=’product.’}{else}{l s=’products.’}{/if}
<!–

{/if}

–>

Make sure that you are changing the Matrice theme not the default one 🙂

Email Forwarding with iRedMail and phpLDAPadmin – How to?

After installation of iRedMail I was quite happy with the product up until the point that I realized that there is no mail forwarding option in iRedMail backend. I was browsing forums but I only could find very complicated solutions or hints that you can do it either from the postfixadmin backend ( which is not coming with the iRedMail product anymore ) or you can use the phpLDAPadmin backend to configure this.

I was playing around with phpLDAPadmin and finally got to this solution:

First create a mail user using your iRedMail backend. I am not going into detail on how to do this it is quite self explanatory.

After iRedMail installation there is a very helpful summary file in the folder where you are kicking of the installation from. It contains all passwords, userids, and URLs you might need to use iRedMail and all underlying products. I does in fact installs many including Dovecot, Postfix, phpLDAPadmin, etc. This summary file is iRedMail.tips

Get your phpLDAPadmin URL, password and master user id from this file and log in to phpLDAPadmin backend. The URL is usually:

https://www.yourdomain.com/phpldapadmin/htdocs/cmd.php

Log in go to and drill down to the email user you have previously created and click on it.

























You will have a couple of options on the right panel, select default, then select add new attribute.










Select mailForwardingAddress from the dropdown list and fill in the email address where you would like to forward emails from this account. Please note that you can set both internal or external email addresses. Click on Update Object at the bottom of the page.






Click on Commit at the next screen to confirm changes and it is done 🙂

There are other ways to enable this and if you use iRedAdmin-Pro you can even do it from the Admin backend. I am only covering the phpLDAPadmin part. Please read this post for more information:

http://www.iredmail.org/forum/post9958.html#p9958

Slow to receive emails? – Disable Postfix Greylisting

Once you install iRedMail on your own VPS you might encounter issues by mails not being received on time or not being received at all. In my case I just had to disable the Postfix Policyd greylisting. I have seen many reject error messages in /var/www/mail.log :

Jun 11 18:13:55 ProcessingEngine postfix/smtpd[13562]: connect from gateway01.websitewelcome.com[69.41.242.19]
Jun 11 18:13:56 ProcessingEngine postfix-policyd: rcpt=16, greylist=abuse, host=69.41.242.19 (gateway01.websitewelcome.com), from=ORIGIN@EMAILREMOVED.COM, to=DESTINATION@EMAILREMOVED.COM, size=0
Jun 11 18:13:56 ProcessingEngine postfix/smtpd[13562]: NOQUEUE: reject: RCPT from gateway01.websitewelcome.com[69.41.242.19]: 450 4.7.1 : Re cipient address rejected: Policy Rejection- Please try later.; from= to= proto=SMTP helo=
Jun 11 18:13:56 ProcessingEngine postfix/smtpd[13562]: disconnect from gateway01.websitewelcome.com[69.41.242.19]

After a bit of a research I have figured that the postfix-policyd configuration file contains the entry where you can disable greylisting. Once I have done that I have been able to send and receive mails instantly.

The config file on my ubuntu 10.4.2 LTS server is located at:

/etc/postfix-policyd.conf

Just set the GREYLISTING paramter to 0

#####################################################################
#
# enable greylisting                                  default: on
#
#   whether greylisting should be enabled or disabled.
#
#                                                     1=on  0=off
GREYLISTING=0

Setting “In-stock first” as default option on products pages – Prestashop 1.4

There is no option like that in Back Office  -> Preferences -> Products. The relevant admin tabs code shows ( AdminPPreferences.php) :

array(‘id’ => ‘0’, ‘name’ => $this->l(‘Product name’)),
array(‘id’ => ‘1’, ‘name’ => $this->l(‘Product price’)),
array(‘id’ => ‘2’, ‘name’ => $this->l(‘Product added date’)),
array(‘id’ => ‘4’, ‘name’ => $this->l(‘Position inside category’)),
array(‘id’ => ‘5’, ‘name’ => $this->l(‘Manufacturer’)),
array(‘id’ => ‘3’, ‘name’ => $this->l(‘Product modified date’))

which is missing option “6” that stands for the “In-stock first” option.

Simply modify the following two database configuration options:

Change the PS_CONFIGURATION table PS_PRODUCTS_ORDER_BY option to “6”

Change the PS_CONFIGURATION table PS_PRODUCTS_ORDER_WAY option to “1”

That’s it