Menu

Database issues on upgrade

2016-09-12
2016-09-12
  • Warren H. Prince

    I had some issues upgrading so I want report the problems and what worked for me.

    I'm using MySql 5.7.13 and this is the first time I've created a config.local.php

    The comments indicate:

    // Database Config
    // mysql = MySQL 3.23 and 4.0, 4.1 or 5
    // mysqli = MySQL 4.1+ or MariaDB
    // pgsql = PostgreSQL
    // sqlite = SQLite 3

    So, in my config.local.php I indicated "mysql" without changing config.inc.php. Setup reported that it could no connect to the database. After testing the settings I'm using and an hour or so of trial and error, I figured that maybe the config.local wasn't being read correctly, so I changed the daatabase_type in config.inc to "mysql". This time, when I refreshed, I received an error that I must use "mysqli" for the database_type if I'm using MySql. I changed both config.inc and config.local to "mysqli" and I was able to connect to the database.

    I had a similar issue in the setup_password where I had to add the same password to both config.local and config.inc.

    PostfixAdmin is now working and I can log in, however, the contents of config.local.php are appearing at the top of the web page. I tried ?debug=0 but that didn't help.

     
  • Christian Boltz

    Christian Boltz - 2016-09-12

    however, the contents of config.local.php are appearing at the top of the web page

    That explains everything. Your conflig.local.php has to start with <?php ;-)

     
  • Warren H. Prince

    Doh!

    Guess it's been too long since I wrote anthing in php.

    Thanks

     

Log in to post a comment.

MongoDB Logo MongoDB