Toolkit 2.3 for 3.0 ?

[Marrot]

Hi,

Is Toolkit 2.3 compatible with beta 3.0 ?.

Following installation , all I have at the moment are these errors:

[image: image.png]

Thank you !.
PM.

[Guillaume Lajarige]

Hello Marrot,

The toolkit is technically compatible with iTop 3.0 yes, but as you can see in your screenshot, its UI is broken. You can still use it though, when the 3.0 is officially released, a compatible toolkit version will be as well.

Take care,
Guillaume

[Marrot]

Thank you for your answer.

But, how can it be used without its UI operative ?.
PM.

[Guillaume Lajarige]

Only the tabs should have their display broken, but you can still click on them.

Guillaume

[Marrot]

You may see attached all the errors when using the "Itop update" tab;
All thee errors seems to be type errors in tables.

So I think when using it for a new extension module, I'll just have to :

• clear all the sql statements related to these types errors
• keep the SQL statements related to my new extension
• apply with "Update ITop code" (or Update ITop code and database" ?)

What do you think ?.
PM.

[Guillaume Lajarige]

Hello Marrot,

This DB messages are ok, it's just iTop trying to rectify the schema but sometimes it thinks some stuff has to be changed when it is not necessary.

You can try updating the toolkit to use the one for iTop 2.7, it might fix some stuff, I don't recall to be honest. You can find it here

Cheers,
Guillaume

[Marrot]

I updated to Toolkit 2.7, but error messages are still present.

I then created the following test module (to try to add a "field1" entry to server item, and
"Update ITop code and Database".

Code is correctly copied to "en-production", but it seems that Mysql update is not
effective (see below), maybe this is related to the bunch of errors previsouly mentioned.

If you have any hint, you are welcome !
PM.

<itop_design xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0">
<constants>
</constants>
<classes>
<class id="user-content-Server" _delta="if_exists">
<fields>
<field id="user-content-field1" xsi:type="AttributeText" _delta="define">
<sql>field1</sql>
<default_value>
<is_null_allowed>true</is_null_allowed>
</default_value></field>
</fields>
</class>
</classes>
<user_rights>
<groups>
</groups>
<profiles>
</profiles>
</user_rights>
</itop_design>

mysql> describe server;

+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | int | NO | PRI | NULL | auto_increment |
| osfamily_id | int | YES | MUL | 0 | |
| osversion_id | int | YES | MUL | 0 | |
| oslicence_id | int | YES | MUL | 0 | |
| cpu | varchar(255) | YES | | | |
| ram | varchar(255) | YES | | | |
+--------------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)

[Guillaume Lajarige]

When running the toolkit with "Update code and database", the toolkit will create new tables, columns, but it will NOT run the ALTER queries that are printed in the screen. Those are to be runned by you, that's why the SQL commands are printed just below.

Cheers,
Guillaume

[Marrot]

The problem is that using using the following module , the "Update code and database" does not create the new tables columns.

See above and below.
Thank you for your support.
PM.

<itop_design xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0">
<classes>
<class id="user-content-Server" _delta="if_exists">
<fields>
<field id="user-content-field1" xsi:type="AttributeText" _delta="define">
<sql>field1</sql>
<default_value>
<is_null_allowed>true</is_null_allowed>
</default_value></field>
</fields>
</class>
</classes>
</itop_design>

[Pierre Goiffon]

Hello, works like a charm for me ?!??

Here is the procedure I followed :

1. add the module
2. open the toolkit
3. click on the "iTop update" link
4. click on the "Check DB Schema" button
5. the toolkit displays the new field to be added :
   field 'field1' could not be found in table 'server'
   ALTER TABLE server ADD field1 TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
6. click on the "📀 Update iTop code and Database!" button
7. after processing is done, check the DB

At the end of the process I get those columns in the Server table :

server table
id int(11) AI PK
osfamily_id int(11)
osversion_id int(11)
oslicence_id int(11)
cpu varchar(255)
ram varchar(255)
field1 text

Did you do it differently ?