Use of 2.0 database on 2.3 server

Question

Hi,

I use a 2.0 database to create a 2.3 OCS server on CentOS 7 (on a fresh install) 

, unfortunatly all my objects are specified as "empty network" as you can see:

What can i do ?

Answer 1

Hello,

How did you proceed to import / export the DB ?

Answer 2

With mysqldump

And i import it with "source /..." in mysql

Answer 3

I did like this and got no issue :

#export from old server

mysqldump -u root -p ocsweb > ocsweb.sql

Then, I put the ocsweb.sql in my new server and did :

mysql -u root -p ocsweb < ocsweb.sql

And everything was ok... Try like that but before, clean your ocs DB on the new server

Answer 4

No it didn't work,

 and this time i can't see any computer but still 6431 objects as "empty network"

Answer 5

I found this : http://ask.ocsinventory-ng.org/3706/migrate-from-2-0-to-2-2

What if :

- Clean your new OCS DB

- import / export those files : dbconfig.inc.php / ocsinventory-reports.conf / ocsinventory-server.conf

- import / export your DB from 2.0 to 2.3

- restart apache service (just in case you know..)

?

Answer 6

already done, when i install 2.3 after importing database i got an empty ocsweb database

Answer 7

hmm, looks crazy, when my database is empty still showing 6431 "empty network".

I also send my pc's informations via OCS client to the empty database, i can see my pc here:

but not there:

Answer 8

Oh I think I know why !

In fact, it is in non inventoried because you imported the DB, you may have all your computers but your new server still hasn't inventoried it. 

You should wait for the agent to do their job, change the PROLOG_FREQ to a few hours and wait... if it is not that I don't have any idea 

Answer 9

OK i'll try this, thank you for your help.