First step: open an SSH connection to the astaro login as loginuser and su to root.
To set the database as local:
cc set http sc_local_db mem
Reload the service:
Verify first DB download (Web surfing will be stopped until done - about 370 MB):
ls -lh /var/chroot-http/var/pattern/sfcontrol
Verify DB settings:
cc get http sc_local_db
cc set http sc_local_db [none,disk,mem]
none - default, don't use local categorization at all use online query as default.
disk - use local Database, but use it only on disk. Useful for boxes with little RAM.
mem - use local Database, and keep it in memory for faster access.