View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Installation V8.4.4.1 - No datsbase - Page 2 - ProjeQtOr
 
 

[SOLVED] Installation V8.4.4.1 - No datsbase

More
29 May 2020 09:38 #7 by babynus
Please show error logged in projeqtor log file.
(the message "ERROR : An error occurred on 2020-05-26 at 20:26:27" indicates that detail of error can be found in log file with that timestamp)

Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
More
29 May 2020 10:03 #8 by moserwi
The topic has been locked.
More
31 May 2020 19:31 #9 by babynus
During installation, you must give to php user write access to projector structure.
On linux Debian / Ubuntu:
chown -R www-data: /var/www/html/projeqtor
chmod -R 755 /var/www/html/projeqtor

Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
More
01 Jun 2020 16:24 #10 by moserwi
Thank you - that did it - finally - with mariadb.

I think it would be good if you publish the install instructions more detailed.
##########################################
here is my install log for a debian10 buster
apt install -y apache2 php libapache2-mod-php zip postgresql postgresql-contrib php-gd php-mbstring php-pgsql php-xml php-zip php-imap

a2enmod ssl
a2ensite default-ssl
systemctl restart apache2

# su - postgres
# createuser projeqtor
# ALTER USER projeqtor WITH ENCRYPTED password 'MyPASS';
# CREATE DATABASE projeqtor OWNER projeqtor;
# \q
# exit
# Funktioniert so nicht - also mit Webmin

sudo -u postgres psql -c "CREATE ROLE projeqtor LOGIN PASSWORD 'MyPASS';"
sudo -u postgres createdb projeqtor -O projeqtor --encoding='utf-8' --locale=de_DE.utf8 --template=template0
echo 'local all projeqtor peer' | sudo -u postgres tee -a $(sudo -u postgres psql -t -P format=unaligned -c 'show hba_file') > /dev/null
# /etc/postgresql/11/main/postgresql.conf
# listen_addresses = '*' # listen on all IP's;
# /etc/postgresql/11/main/pg_hba.conf (at the end)
# host all all 0.0.0.0/0 md5
sudo service postgresql reload

## create an email sender for projeqtor
adduser admin --shell /bin/false --gecos "" --disabled-password
# projeqtor disk space
adduser projeqtor --shell /bin/false --gecos "" --disabled-password

cd /home/projeqtor/
mkdir files
mkdir files/attach
mkdir files/log
mkdir files/config
chown -R www-data:www-data /var/www/html/projeqtor
chmod -R 755 /var/www/html/projeqtor

# /etc/php/7.3/apache2/php.ini
memory_limit = 1024M
max_input_vars = 4000
max_execution_time = 60
file_uploads = On
upload_max_filesize = 128M

register_globals = Off
magic_quotes_gpc = Off
request_terminate_timeout = 0
suhosin.post.max_vars = 4000
suhosin.request.max_vars = 4000

# php --info | grep error

ProjectSite="http://192.168.100.19/arm64/lxcPM"

cd /var/www/html
wget $ProjectSite/projeqtorV8.4.4.zip
unzip projeqtorV8.4.4.zip
rm projeqtorV8.4.4.zip

# Set-up :
# - Unzip projeqtorVx.y.z.zip to the web server directory
# - Run application in your favorite browser, using http://yourserver/projeqtor
# - Enjoy !

# Configuration :
# - At first run, configuration screen will be displayed.
# - Default parameters may work for a test instance.
# - For MySql, default user is 'root', default password is 'mysql' but may also be '' (blank) on some xAMP stacks.
# - To run again configuration screen, just delete "/tool/parametersLocation.php" file.
# - On first connection, database will be automatically updated.
# - login : admin/admin

# install mariadb
apt update && sudo apt -y upgrade
apt -y install mariadb-server mariadb-client
apt policy mariadb-server
systemctl status mariadb
# mysql_secure_installation
apt-get install php-mysql
The topic has been locked.
Moderators: babynusprotion
Time to create page: 0.035 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.