Topic: [Announce] Inventory tools: OCS and GLPI for SME 7.x

[cool34000]

Hi Kevin,

It could be possible with GLPI I think...
Go to Administration -> Setup -> Email followup
Try over there...

Else you can rise a feature request!

[cool34000]

Hi all


I'm asking a simple question which was raised by Jader:
At uninstall stage, should or should not the MySQL DataBase be dropped automatically?

By now, the database is automatically dropped at uninstall stage so you have to save your database on your own if you plan to update RPMs.


Thanks in advance!
Best regards,
Sylvain

[Franco]

Can the uninstall script ask if you want to drop it?

[Daniel B.]

Can the uninstall script ask if you want to drop it?

No, in a rpm, the scripts must be non-interactive, but you could dump the bases just before dropping them, just like a signal-event pre-backup would do

mysqldump --add-drop-tables dbname > /home/e-smith/db/mysql/dbname.dump

this way, if you install an upgraded version, the script could check if the dump exists, if it do, then, just create the database and fill it like this:

mysql dbname < /home/e-smith/db/mysql/dbname.dump

If it doesn't exists, that means it's a new install, sso just fill it with the default values. Just an idea.

[cool34000]

Thanks for the info VIP-Ire!
I will take a look ASAP!

[kevinb]

In response to my earlier question ..... I found this infomation on the OCS forum:

Q:
I would like to find out is there any way to find out if there is a change in the hardware of a server/desktop on day to day basis.  
If any desktop/sesrver is upgraded then it should inform me via an email/alert.

A:
This feature is not currently available in OCS or GLPI.
Perhaps in the future ?

[cjensen]

Thank you for your work Sylvain.  This is a very useful set of tools.

I have a few suggestions that may save you some questions from users who made similar assumptions/mistakes during setup but do not have wiki edit access.

1)immed after this line"OCS Reports' web interface can be reached at http://your-server/ocs" add the instruction to choose a language before actual login (might save someone like me from trying to maneuver without the labels ;0)

2) if you include the distribution link for download at the point under Use for ocs with/or near this text "The client side is available on all platforms." (obvious eventually, but this makes it clearer)

Again, thank you for the great contribution!!

Craig Jensen

[cool34000]

Hi,

About the flag, it's a known bug which will be fixed by OCS team in the next release.
About the availability on all platforms, it was in the links just at the end of the wiki (download section).

Anyway, I've added those 2 infos on the wiki... Thanks for your comments.

By the way here's a link to learn how to modify the wiki by your-self : http://wiki.contribs.org/Help:Editing_pages
Pretty easy isn't it?

[dmac]

Can you verify how your accessing the mysql database?
I get the following error,
Decompressing files...
Creating MySQL user and DataBase...
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
Importing MySQL DataBase...
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Applying modifications to MySQL...
Restarting mysqld [  OK  ]
Applying modifications to httpd...

when installing.  When i connect to the mysql database at the command line, i use the "mysql -u root -p" options and have to type the password to get access.

If this doesn't work, then I will need to go the long install route.

Thanks,

Darin

[veeresh]

Hi,

Why is the link to OCS_Reports_and_GLPI  removed from the main contribs page in the wiki.


thanks

[Franco]

It's there:
http://wiki.contribs.org/Category:Howto

[veeresh]

sorry was looking for it in the contribs

thanks

veeresh

[cool34000]

Hi guys,

I've made a new RPM for OCS and GLPI. All goes in a single RPM now.
What's new?
- Inventorying SME is now possible (Agent Linux installed by default)
- GLPI has been upgraded to 0.68.3-2 (send mail security fix)
- Full SME integration
- a few bug fixes


I've modified the wiki article and put it back to Contrib section.
http://wiki.contribs.org/OCS_Reports_and_GLPI

If you're updating old RPMs, please read carefuly the update section

[Jáder]

Hi Silvain

I'm back!
I removed old 2 rpms... and after download your rpm did:

Code: [Select]



root@tigre ~# yum localinstall smeserver-inventory-tools-1-1.i386.rpm
 ==============================================================
WARNING: Additional commands may be required after running yum
==============================================================
Loading "fastestmirror" plugin
Loading "smeserver" plugin
Setting up Local Package Process
Examining smeserver-inventory-tools-1-1.i386.rpm: smeserver-inventory-tools - 1-1.i386
Marking smeserver-inventory-tools-1-1.i386.rpm to be installed
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package smeserver-inventory-tools.i386 0:1-1 set to be updated
--> Running transaction check
Setting up repositories
Loading mirror speeds from cached hostfile
Reading repository metadata in from local files
--> Processing Dependency: ocsinventory-ipdiscover >= 1.01-2 for package: smeserver-inventory-tools
--> Processing Dependency: ocsinventory-agent >= 0.0.6-1 for package: smeserver-inventory-tools
--> Processing Dependency: monitor-edid >= 1.11-1 for package: smeserver-inventory-tools
--> Finished Dependency Resolution
Error: Missing Dependency: ocsinventory-ipdiscover >= 1.01-2 is needed by package smeserver-inventory-tools
Error: Missing Dependency: ocsinventory-agent >= 0.0.6-1 is needed by package smeserver-inventory-tools
Error: Missing Dependency: monitor-edid >= 1.11-1 is needed by package smeserver-inventory-tools
================================================================
No new rpms were installed. No additional commands are required.
================================================================


there are missing dependencies... or I forgot to add some repo  ??
Thanks

Jáder

[cool34000]

Hi Jader!

Download dependencies and install these 3 missing packages using yum.
Then install the new RPM!