does anyone know the default mysql password?

gave up here, made a manual install of OP. Now testing it (discovered a few problems unfortunately again) and will test the backup on my new manual installation.

Btw, the SQL root password seems to be randomly set when using the package installer, am I right?

TU

Hi,

it seems to me you did a lot of work because of missing information. I assume you are not familiar with the openproject-ce run command right. If so we have to put more effort into our documentation to get things more clear. In my opinion the whole gem update bundler and so on is not necessary at all.

I have to admit I’m a little bit confused what you are trying to accomplish? Please let us start over by explaining what you want to do and what you already did to accomplish your goal. I’m sure we can figure something out and get everything up and running.

Cheers,
Karsten

Hi,

according to the manual https://www.openproject.org/download/backup-guide/ the first command to type is

RAILS_ENV=production bundle exec rake backup:database:create

which unfortunately threw an error.
Unfortunately, and I don´t know why really, I did not post the error message in my first post nor do I remember it at the moment anymore.

Then I tried to tar some files but that didn´t work (of course) because I was missing obviously a lot of important files and databases :)
(must have been the long day and time of the day when writing my post, I must admin it is confusing :) ).
Anyhow, I gave up on this subject and started a new manual setup which seems to be working so far.

And I agree on your point that improving the documentation might be necessary. But from what I see in the past days this is being done at the moment.

Best regards
TU

Hi,

if you using the packaged installation like OpenProject Community Edition you have to prefix all commands with openproject-ce run to ensure the correct environment settings are used. If you are interested which settings like mysql root password are used please have a look at /etc/openproject-ee and at /etc/openproject-ce/install.dat in particular.

I recommend you switch back to the packaged installation to have an easier update path in the future. I know that might be to much to ask for because of the effort you invested but I think it is the right thing to do in the long term.

If you have any further questions please let me know.

Regards,
Karsten

if you using the packaged installation like OpenProject Community Edition you have to prefix all commands with openproject-ce run to ensure the correct environment settings are used.

well, that is some information that is definitely worth adding to the page, I would say.

If you are interested which settings like mysql root password are used please have a look at /etc/openproject-ee and at /etc/openproject-ce/install.dat in particular.

Thank you, I will.
I guess that is also worth being added and noted somewhere in the help files, btw.

I recommend you switch back to the packaged installation to have an easier update path in the future. I know that might be to much to ask for because of the effort you invested but I think it is the right thing to do in the long term.

Shouldn´t be a problem, running OP at the moment for testing purposes inside Virtualbox and created LOTS of snapshots ;) .
Thanks again!

Regards
TU

alright.
(very frustrated)

Reverted to an earlier snapshot of my virtual installation.

Had version 4.0.6 installed, did an

apt-get upgrade

Then I ran

sudo openproject-ce reconfigure

(besides that it seems not possible to change the MySQL settings in the installer so I had to use the mysql commandline options to reset the mysql password) I (tried) to setup SMTP, using Gmail (was previously working in my manual OP installation) which did not work (was logged in all the time during the update and clicked therefore on the “Send Testmail” button.

Tried to add a user, when clicking on “Create” I got an “internal server error” (same error as when not being able to add work packages, see my other post https://community.openproject.org/topics/4173 ).

This made me want to v*****t over my keyboard.

I saw that the line

smtp_enable_starttls_auto: true

is missing in /etc/openproject-ce/config.d/smtp , tried to add it but seems to throw an error when trying to reconfigure OP.

Thought that a reboot might be a good idea, but now the OP website is not opening anymore in my browser.

Has been very long ago I had so many frustrating experiences in trying to setup a software.

TU

Apache2 seems not to start:

sudo service apache2 start
 * Starting web server apache2                                                   *
 * The apache2 configtest failed.
Output of config test was:
apache2: Syntax error on line 219 of /etc/apache2/apache2.conf: Syntax error on line 1 of /etc/apache2/sites-enabled/openproject-ce.conf: No matches for the wildcard '*.conf' in '/etc/openproject-ce/addons/apache2/includes/server', failing (use IncludeOptional if required)
Action 'configtest' failed.
The Apache error log may have more information.

The directory /etc/openproject-ce/addons/apache2/includes/server is emtpy.

I edited the file /etc/apache2/sites-enabled/openproject-ce.conf so it looks like the one below, changed both “Include” to “IncludeOptional”

IncludeOptional /etc/openproject-ce/addons/apache2/includes/server/*.conf

<VirtualHost *:80>
  ServerName OP-Guest
  DocumentRoot /opt/openproject-ce/public

  ProxyRequests off

  IncludeOptional /etc/openproject-ce/addons/apache2/includes/vhost/*.conf

  ProxyPass / http://127.0.0.1:6000/ retry=0
  ProxyPassReverse / http://127.0.0.1:6000/

</VirtualHost>

Now Apache is starting again and I can login.

Mails can still not be send, though. Is there a way to add the option “smtp_enable_starttls_auto: true” option to the file /etc/openproject-cs/conf.d/smtp?

EDIT:
I edited /etc/openproject-cs/conf.d/other and added

export SMTP_ENABLE_STARTTLS_AUTO="true"

but mails still cannot be send out.

Side note: Can I change the settings of the RAILS_CACHE_STORE in conf.d/other from “file_store” to “memcache”?

TU