[29:1agDuUpPv4NZQXHZ6x99TzTPjm3Ue7Gqi_BoRWTLFs04] [1658129695] Sameroom: [Unknown] hi @John Obiorah . It should just be a matter of having the configured the proper URL pointing at the API endpoint /sms/smssync , and the same shared secret key of your choosing
<<< So how exactly would I get this accomplished? Do you have a documentation on how to achieve this or could you please tell the file to edit in order to achieve this?
[John Obiorah] [1658154394] Sameroom: [David Losada, Ushahidi] @John Obiorah please take a look at the Platform user manual, if you haven’t yet: https://docs.ushahidi.com/ushahidi-platform-user-manual/3.-configuring-your-deployment/3.4-data-sources#3-4-5-smssync
<<< Many thanks David Losada. The link you shared is quite helpful. The Ushahidi mobile app on Google Play upon download to android devices renders the survey forms broken. I dunno whether this experience has been reported by others using self-hosted platform-release system. Another question I have is what could be to make the Ushahidi deployment to be stunningly fast? Could this be achieved with Redis?
[Unknown] Hello @jcoonrod, thank you for your feedback. I have notified our developers of your suggestion.
To add Bengali to the list of languages, you need a transifex account to join a translation team.
This will guide you https://docs.ushahidi.com/platform-developer-documentation/translation/software-localization-and-translation on how to go about translating.
Transifex provides you with an editor that gives you space to work on the content that you want to translate. This guide will redirect to articles that will help you get started and show you the steps you need to take.
Please log into your deployment to see all responses via the chat messenger.
[John Obiorah] [1662365974] Sameroom: [Unknown] Hi @John Obiorah https://github.com/ushahidi/platform-release/releases/download/v5.3.1/ushahidi-platform-release-v5.3.1.tar.gz should hopefully resolve your issues
<<< The logo image still appear broken and so are all posts or submissions with images.
[John Obiorah] [1663315981] Sameroom: [Unknown] @John Obiorah , is there any way you could share with us your URL and configuration details (.env file, configuration folder, description of your setup)? You can do that confidentially by sending a message to community-support-deb-aaaaevfbn7xrojbzkjtklnmwfu@ushahidi.slack.com
<<< I'll do that in the next hour.
[Unknown] Hello @John Obiorah … saw you .env
and I believe something is missing … can you add the below to you .env file and try again
FILESYSTEM_DRIVER=public
this should tell the framework that platform is built on where to find your images.
[John Obiorah] [1663326919] Sameroom: [Unknown] Hello @John Obiorah … saw you `.env` and I believe something is missing … can you add the below to you .env file and try again
```FILESYSTEM_DRIVER=public ```
this should tell the framework that platform is built on where to find your images.
<<< Done.
Hello guys. MySQL-8.0.31. I am stuck on migration. How do I fix this error?
root@gw:/usr/local/www/data/ushahidi-platform-release-v5.3.1/html/platform # ./bin/phinx migrate -c phinx.php
Phinx by Rob Morgan - https://phinx.org. 0.8.1
using config file ./phinx.php
using config parser php
using migration paths
In MysqlAdapter.php line 115:
There was a problem connecting to the database: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
However, from the CLI, the user can connect to the DB:
root@gw:/usr/local/www/data/ushahidi-platform-release-v5.3.1/html/platform # mysql -uushahidiuser -p ushahidi
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 423
Server version: 8.0.31 Source distribution
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
ushahidi531@localhost [ushahidi]>
[Unknown] Hello @odhiambo
By default and for some reason, mysql 8 uses a different auth plugin which is auth_socket
… and is different from previous versions
If you have not yet already changed your mysql default auth plugin, you can do so by running this sql command:
ALTER USER 'ushahidiuser'@'localhost' IDENTIFIED WITH mysql_native_password
BY 'ushahidi';
[Unknown] Hello @odhiambo
By default and for some reason, mysql 8 uses a different auth plugin which is
auth_socket
… and is different from previous versionsIf you have not yet already changed your mysql default auth plugin, you can do so by running this sql command:
ALTER USER 'ushahidiuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ushahidi';
Actually, that is how I create all the users.
And from the CLI, as demonstrated, the user is able to connect to the database. It is only within the platform where the command fails and so I am unable to migrate.
Thanks for a quick response, but I am still stuck.
[Unknown] @odhiambo, do you mind using mysql 5.7?
Isn't this something that I need to change within the ushahidi files for this to work? As I mentioned, "mysql -uushahidi -pPASS ushahidi " works as expected, so there is something within the platform files that needs to change. I just don't know which file it is and what it is :)