Content
    2026-10-15

    If you encounter errors when connecting to a ClickHouse database via PhpStorm or DataGrip:   

    DBMS: ClickHouse (ver. 26.9.6.6) Case sensitivity: plain=exact, delimited=lower 
    Driver: ClickHouse JDBC Driver (ver. 0.10.0, JDBC4.2) 
    [HY000] Invalid LZ4 magic byte: '-112'.

    or

    DBMS: ClickHouse (ver. 26.9.6.6) Case sensitivity: plain=exact, delimited=lower 
    Driver: ClickHouse JDBC Driver (ver. 0.10.0, JDBC4.2) 
    [08000] Failed to create connection Unknown and unmapped config properties: [sslmode].

    In that case, you need to make the following changes to the connection settings.

    On the General tab, add the parameter ?ssl=true at the end of the URL field

      On the SSH/SSL tab, it must be turned off "Use SSL":

    In the Advanced tab, locate the "compress" setting and set it to "false."