Zotlabs|Hubzilla Development

Tue, 07 Aug 2018 07:47:36 +0000

!Hubzilla Development,

Just want to install Hubzilla with postgresql and following below link.

https://zotadel.net/channel/support&dend=2018-03-31&dend=2018-03-31&jsdisabled=0&jsdisabled=0&cat=Postgres

In an installation can we use hubzilla-setup.sh to intialize postgresql db or we have to link postgresql server once the typical setup completed with mysql ?

show all 6 Comments

Einer von Vielen

Wed, 08 Aug 2018 09:46:09 +0000

@Lasantha Ranaweera

Basically the install script installs mysql and creates the Hubzilla DB and grants the privileges to an admin user.

    Q1="CREATE DATABASE IF NOT EXISTS $hubzilla_db_name;"
    Q2="GRANT USAGE ON *.* TO $hubzilla_db_user@localhost IDENTIFIED BY '$hubzilla_db_pass';"
    Q3="GRANT ALL PRIVILEGES ON $hubzilla_db_name.* to $hubzilla_db_user@localhost identified by '$hubzilla_db_pass';"
    Q4="FLUSH PRIVILEGES;"
    SQL="${Q1}${Q2}${Q3}${Q4}"     
    mysql -uroot -p$phpmyadminpass -e "$SQL"

After the installation when you open your fresh Hubzilla installation in a web browser for the very first time you will be guided to a setup procedure of your Hubzilla instance. There you "tell" Hubzilla what DB to use, the DB user and the password. This is the same the script created for you.

If you decide to uses postgres instead of MySQL you should

create the DB manually (what the script does for you)
tell Hubzilla what DB to use during the setup procedure (very first call in a browser)

Does this answer your question?

Lasantha Ranaweera

Wed, 08 Aug 2018 11:08:59 +0000

Yep. That answer my question. Thanks a lot @Einer von Vielen .

Einer von Vielen

Wed, 08 Aug 2018 14:16:00 +0000

Welcome @Lasantha Ranaweera