View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - populate postgres - ProjeQtOr
 
 

populate postgres

More
20 May 2020 18:19 #1 by moserwi
populate postgres was created by moserwi
Hi,

I do have a clean install site (projeqtorV8.4.4)and expect the database to be populated after "continue"

############################
cat parameters.php
<?php
// =======================================================================================
// Automatically generated parameter file
// =======================================================================================
$paramDbType = 'pgsql';
$paramDbHost = '127.0.0.1';
$paramDbPort = '5432';
$paramDbUser = 'projeqtor';
$paramDbPassword = 'My11Pass';
$paramDbName = 'projeqtor';
$paramDbDisplayName = 'ProjeQtOr';
$paramDbPrefix = '';
$SslKey = '';
$SslCert = '';
$SslCa = '';
$paramLdap_allow_login = 'false';
$paramLdap_base_dn = 'dc=mydomain,dc=com';
$paramLdap_host = 'localhost';
$paramLdap_port = '389';
$paramLdap_version = '3';
$paramLdap_search_user = 'cn=Manager,dc=mydomain,dc=com';
$paramLdap_search_pass = 'secret';
$paramLdap_user_filter = 'uid=%USERNAME%';
$paramMailSender = 'This email address is being protected from spambots. You need JavaScript enabled to view it.';
$paramMailReplyTo = 'This email address is being protected from spambots. You need JavaScript enabled to view it.';
$paramAdminMail = 'This email address is being protected from spambots. You need JavaScript enabled to view it.';
$paramMailSmtpServer = 'localhost';
$paramMailSmtpPort = '25';
$paramMailSendmailPath = '';
$paramDefaultPassword = 'My11Pass';
$paramPasswordMinLength = '5';
$paramDefaultLocale = 'de';
$paramDefaultTimezone = 'Europe/Vienna';
$currency = '€';
$currencyPosition = 'after';
$paramFadeLoadingMode = 'false';
$paramIconSize = '22';
$defaultTheme = 'ProjeQtOrFlatBlue';
$paramAttachmentDirectory = '/home/projeqtor/files/attach/';
$paramAttachmentMaxSize = '2097152';
$AttachmentMaxSizeMail = '2097152';
$paramReportTempDirectory = '/home/projeqtor/files/report/';
$paramMemoryLimitForPDF = '512';
$logFile = '/home/projeqtor/files/logs/projeqtor_${date}.log';
$logLevel = '2';
#####################
DATABASE was created with:
sudo -u postgres psql -c "CREATE ROLE projeqtor LOGIN PASSWORD 'My11Pass';"
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
sudo service postgresql reload
######################
nmap -sT 127.0.0.1
PORT STATE SERVICE
5432/tcp open postgresql
######################
postgresql-11 log:
2020-05-20 17:39:03.373 CEST [32519] projeqtor@projeqtor FEHLER: Relation »parameter« existiert nicht bei Zeichen 15
2020-05-20 17:39:03.373 CEST [32519] projeqtor@projeqtor ANWEISUNG: select * from parameter where (idUser is null and idProject is null)
2020-05-20 18:09:48.967 CEST [4667] [unbekannt]@[unbekannt] LOG: konnte Daten vom Client nicht empfangen: Die Verbindung wurde vom Kommunikationspartner zurückgesetzt
2020-05-20 18:09:48.967 CEST [4667] [unbekannt]@[unbekannt] LOG: unvollständiges Startpaket
#######################
No a single table is create and it looks like the sql-scripts are not compatible with pgsql
#######################

Question: where is the bunch of sql scripts that I can use to pupulate the db manually??

OK I bet there is a solution: proceed with mysql and migrate the database to pgsql thereafter. BUT I am sure that is not whst i, and you, want.

willi

Please Log in or Create an account to join the conversation.

More
25 May 2020 12:06 - 25 May 2020 12:07 #2 by babynus
Replied by babynus on topic populate postgres
Hi,

With postgreSql you have to create db manually.
You also have to create a db user user with all access rights to this DB.
Then define credentials to DB in configuration screen.

On continue, DB is not populated yet.
You reach login screen and need to connect as admin/admin
This will populate the DB.

Question: where is the bunch of sql scripts that I can use to pupulate the db manually??

You must absolutely not do this.

OK I bet there is a solution: proceed with mysql and migrate the database to pgsql thereafter. BUT I am sure that is not whst i, and you, want.

Migration from MySql to PostgreSql is not so easy...

Babynus
Administrator of ProjeQtOr web site
Last edit: 25 May 2020 12:07 by babynus.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.031 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.