Where communities thrive

  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
    [Unknown] no.. I mean inserting a new line on top of the “catch” one
    [Unknown] yep thumbsup emoji
    [Unknown] then you can run just php ./phinx.php
    [Gerald Emmanuel Thomas] should i try the migrate command or your command now
    [Gerald Emmanuel Thomas] Array
    [LS_COLORS] => rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=00:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lha=01;31:*.lz4=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.tzo=01;31:*.t7z=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lrz=01;31:*.lz=01;31:*.lzo=01;31:*.xz=01;31:*.zst=01;31:*.tzst=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.alz=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.cab=01;31:*.wim=01;31:*.swm=01;31:*.dwm=01;31:*.esd=01;31:*.jpg=01;35:*.jpeg=01;35:*.mjpg=01;35:*.mjpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.m4a=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.oga=00;36:*.opus=00;36:*.spx=00;36:*.xspf=00;36:
    [LANG] => en_US.UTF-8
    [HOME] => /home/gerald
    [TERM] => xterm-256color
    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin
    [MAIL] => /var/mail/root
    [LOGNAME] => root
    [USER] => root
    [USERNAME] => root
    [SHELL] => /bin/bash
    [SUDO_COMMAND] => /usr/bin/php ./phinx.php
    [SUDO_USER] => gerald
    [SUDO_UID] => 1001
    [SUDO_GID] => 1001
    [APP_ENV] => production
    [APP_DEBUG] => false
    [APP_KEY] => {32characterkey}
    [DB_CONNECTION] => mysql
    [DB_HOST] =>
    [DB_PORT] => 3306
    [DB_DATABASE] => platform
    [DB_USERNAME] => platform
    [DB_PASSWORD] => Slmanage468
    [CACHE_DRIVER] => redis
    [QUEUE_DRIVER] => sync
    [REDIS_HOST] =>
    [REDIS_PORT] => 6379
    [Gerald Emmanuel Thomas] it is reading everything from the .env file
    [Unknown] mmm yep I see it matches… well,, I am clueless. Let me see if someone else can help.

    [Gerald Emmanuel Thomas] gerald@hris:/var/www/html/platform$ sudo php artisan migrate
    using config file ./phinx.php
    using config parser php
    using migration paths

    • /var/www/html/platform/migrations
      using seed paths
    • /var/www/html/platform/seeds
      warning no environment specified, defaulting to: ushahidi
      using adapter mysql
      using database platform

    In MysqlAdapter.php line 115:

    There was a problem connecting to the database: SQLSTATE[HY000] [1045] Acce
    ss denied for user 'platform'@'localhost' (using password: NO)

    [Gerald Emmanuel Thomas] where can i locate this file
    [29:1ywoz-V4I1IKiPouk7sZ0jJKRM6e_DnFvXZLWTnnr4AM] where can i locate this file ????
    [Unknown] that’s vendor/robmorgan/phinx/src/Phinx/Db/Adapter/MysqlAdapter.php
    [Gerald Emmanuel Thomas] if i want to change the database and use postgresql
    [Gerald Emmanuel Thomas] can you help me with the .env for postgresql database
    [Gerald Emmanuel Thomas] maybe it is some security on mysql
    [Unknown] I think there are certain bits in the code that will not work with Postgresql
    [Gerald Emmanuel Thomas] OK
    [Gerald Emmanuel Thomas] Please is there anyone willing to help me
    [Unknown] Hi Gerald
    can you try running these commands :
    php artisan route:cache php artisan route:clear php artisan config:cache php artisan config:clear php artisan optimize
    [Unknown] can you try running
    php artisan cache:clear php artisan optimize
    [Gerald Emmanuel Thomas] php artisan optimize seem not to be available anymore
    [Unknown] yep . can you try to put the password between quotations in .env file
    [DB_PASSWORD] => "Slmanage468"
    [Unknown] yes , can you try migration now

    [Gerald Emmanuel Thomas] [1651669194] Sameroom: [Unknown] yes , can you try migration now

    <<< Still not working

    [Gerald Emmanuel Thomas] Do i need a special version of mysql
    [Gerald Emmanuel Thomas] gerald@hris:/var/www/html/platform$ mysql --version
    mysql Ver 14.14 Distrib 5.7.37, for Linux (x86_64) using EditLine wrapper
    [Unknown] I see. I will tell you when I discover anything
    [Gerald Emmanuel Thomas] Good morning
    [Gerald Emmanuel Thomas] Is there anyone who can help
    [Gerald Emmanuel Thomas] Should i start the installation all over again ?
    [Gerald Emmanuel Thomas] Please assist

    [Unknown] it’s such a weird thing that we have not seen before Gerald … let’s see if we can find a work around for you .

    What would you like to do with platform? Would you like to develop it or just to run it?

    [Gerald Emmanuel Thomas] For now i will like to run it
    [Gerald Emmanuel Thomas] and develop other features on it
    [Gerald Emmanuel Thomas] in 2015 i started working on it in Ghana but that was on version 2
    [Gerald Emmanuel Thomas] I need to see the new features on version 3 or 4 and probably test it in our upcoming election
    [David Losada, Ushahidi] I see. An alternative way to get the software running , is to use Docker as a container platform. Is that something you may be familiar with?
    [Gerald Emmanuel Thomas] yes i am familiar with docker
    [David Losada, Ushahidi] mm great!
    [Gerald Emmanuel Thomas] Do you have the installation steps for docker containers
    [David Losada, Ushahidi] the quickest way to get the latest stable version running is to get this repo : https://github.com/ushahidi/platform-release/
    [David Losada, Ushahidi] and run “docker-compose up”
    [David Losada, Ushahidi] this is not the latest code, but it gives you both the API and the frontend up in one go