If you have vTiger error like:

/var/www/vtigercrm/usr_privileges/sharing_priviliges_xyz.php on line xyz

its because of erroneous data in your vtiger database.

ERRONEOUS DATA FROM DATABASE:

login into mysql:

mysql -u root -p

use vtiger;

select * from vtiger_def_org_share where editstatus=0;

output:

+--------+-------+------------+------------+
| ruleid | tabid | permission | editstatus |
+--------+-------+------------+------------+
| 1 | 2 | 2 | 0 |
| 3 | 6 | 2 | 0 |
| 4 | 7 | 2 | 0 |
| 6 | 13 | 1 | 0 |
| 8 | 20 | 2 | 0 |
| 9 | 21 | 2 | 0 |
| 10 | 22 | 2 | 0 |
| 11 | 23 | 2 | 0 |
| 12 | 26 | 2 | 0 |
| 13 | 8 | 2 | 0 |
| 14 | 30 | 3 | 0 |
| 15 | 32 | 2 | 0 |
| 16 | 38 | NULL | 0 |
+--------+-------+------------+------------+
13 rows in set (0.00 sec)

The NULL data is what caused the error to be generated as VTiger creates a php
file from this database each time you create a user. After reviewing your privileges
under "Sharing Access" in the admin area - it looks like your install is corrupted or
your database data is corrupt. At the end of organizational sharing rules, you will
find the grid is not displayed correctly at the end.

As a warning, if someone does recalculate your permissions, it is possible you have
other errors show up due VTiger currently not being a proper installation with regards
to this.

QUERY WHICH FIX THE ISSUE:

update vtiger_def_org_share set permission = 2 where ruleid = 16 and tabid = 38

Thanks to Martin our consultant :-)

Cheers
Daniel

The kids decided to bake a sprinkle cake... so we did it and yes they put lots of sprinkles on... :-)

We called the cake "death by sprinkles"

We also planted some new water plants at our house entrance, now we need to buy some malaysian fighter fishes to eat all the future mosquito larvae......

Cheers and enjoy the week!

Daniel

For all of out there using NDO and MySQL "just" for Nagvis there is a new cool module called mklivestatus, which directly communicates with the Nagios core. Therefore you don't need the relatively slow NDO broker and database anymore.

From Nagvis website:

The mklivestatus module provides a unix socket for data exchange. The main advantage of this module is that it provides direct access to the status information in the Nagios core without storing any information in a database or file. This way it is extremely fast to get the status information since it is only CPU time needed to gather those information. No disk IO or memory processing at all.

To be able to use the mklivestatus backend you need to extend your Nagios core with the livestatus eventbroker module. The module can be downloaded here. The documentation on how to install the module can be found here. Additionally you may need to extend your PHP with the socket extension.

Its a cool module and makes Nagvis enterprise ready!!!! :-)

Cheers
Daniel

Wow,im also back from my long holiday and absence of blogs, www and e-mail.
Hope you all had a great time and i wish you a awesome 2010.

The year starts exciting for us here at Intuit since we got invited to participate and speech at the upcoming Atricon-Europe in Paris!

AstriEurop briefly:

AstriEurop brings together all of the major European players from the Asterisk® community to provide a complete overview of the market.

Attend AstriEurop is to contribute to the development of Asterisk® European market.

Looking for a telephony solution !

* Innovative,
* Flexible,
* Interoperable,
* Evolving,
* Promoting the reduction of costs…

Would be cool to meet some of you there!

I have a couple of exciting technical stuff to blog in the next days and hope to see you here...

Cheers and have a great day!

Daniel

We had a great swiss raclette (melted cheese with boiled potatoes) at our usual friday apero.

I was happy that our clients, partners and Intuiter liked the treat. :-)

6kg potatoes, 3.5 kg cheese and lots of liquids... yumm yumm

Cheers and hope to see you at our office this Friday!

Daniel