These are chat archives for ushahidi/Community

11th
Nov 2016
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 03:51
The
@Theniqabicodermum Here is the linkhttps://youtu.be/E6ckr9V5Cns
Tsega
@tsepeaces_twitter
Nov 11 2016 04:10
Hello! A few of us are looking to develop a 'hate crime map' for the U.S. after this election and I suggested that we look into Ushahidi. I'm not a developer but was hoping to know:
1) What the price is for installing the platform
2) If there would be anyone familiar with the Ushahidi platform who may be interested in supporting this effort
3) How we start getting the data into the maps?
Very appreciative of your responses
Ushbot
@ushbot
Nov 11 2016 04:17
[Robbie Mackay, Ushahidi] @tsepeaves_twitter Hi there. Are you looking for someone to install the platform for you? or to install it yourself?
[Robbie Mackay, Ushahidi] Ushahidi is open source and free to install yourself. We also have a hosted version you can use, plan details are here: https://www.ushahidi.com/plans
[Robbie Mackay, Ushahidi] The Ushahidi staff have also been running http://www.usaelectionmonitor.com/
You could work with us on that deployment.
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 05:56
Hi again, the platform/httpdocs/api/v3/config cannot be found and is not in the platform folder
tameen
@tameen
Nov 11 2016 07:49

Hi,

Please ignore my last email and reply me of that, actually i need this urgently.
What i did:
1- Installed php 5.5, MySql 5.6, Apache and Composer.
2- I placed platform folder in /
3- in /etc/apache2/apache2.config change /var/www to:

<Directory /platform>
Options Indexes FollowSymLinks
AllowOverride None
Require all granted
</Directory>

4- Changed Document Root to /platform/httpdocs
5- Changed /template.htaccess to .htaccess
6- Copy the application/config/init.php file into application/config/environments/development/ (create this directory if it doesn't exist).
7- Edit init.php and changed index_file to "index.php" like:
index.php => 'FALSE'
8- Executed these commands:

chmod 0777 application/logs application/cache application/media/uploads
chown www-data application/logs application/cache application/media/upload

9- Created Databse:

CREATE DATABASE ushahidi_db;
GRANT ALL ON ushahidi_db.* to ushahidi_user@localhost IDENTIFIED BY 'ushahidi-db-password';
quit;

10- created .env file and inserted this code in it:

DB_HOST=localhost
DB_NAME=ushahidi_db
DB_TYPE=MySQLi
DB_USER=ushahidi_user
DB_PASS=ushahidi-db-password</code>

then i executed this command php composer.phar install which results in two errors:

In file 'MySQLi .php' in database folder, no information regarding database was present which causes access exception. I mentioned required variables:

// Extract the connection parameters, adding required variabels
extract($this->_config['connection'] + array(
'database' => 'ushahidi_db',
'hostname' => 'localhost',
'username' => 'ushahidi_user',
'password' => 'ushahidi-db-password',
'socket' => '',
'port' => 3306,
)

Secondly, after mentioning this it causes following error log:

{
"errors": [
{
"status": 1146,
"title": "Table 'ushahidi_db.users' doesn't exist [ SELECT users. FROM users WHERE users.id IS NULL LIMIT 1 ]",
"message": "Table 'ushahidi_db.users' doesn't exist [ SELECT users.
FROM users WHERE users.id IS NULL LIMIT 1 ]",
"class": "Database_Exception",
"file": "/platform/application/classes/Database/MySQLi.php",
"line": 155,
"trace": [
{
"file": "/platform/vendor/ohanzee/database/src/Database/Query.php",
"line": 251,
"function": "query",
"class": "Database_MySQLi",
"type": "->",
"args": [
1,
"SELECT users.* FROM users WHERE users.id IS NULL LIMIT 1",
false,
[

                    ]
                ]
            },
            {
                "file": "/platform/application/classes/Ushahidi/Repository.php",
                "line": 188,
                "function": "execute",
                "class": "Database_Query",
                "type": "->",
                "args": [
                    {
                        "last_query": null
                    }
                ]
            },
            {
                "file": "/platform/application/classes/Ushahidi/Repository.php",
                "line": 69,
                "function": "selectOne",
                "class": "Ushahidi_Repository",
                "type": "->",
                "args": [
                    {
                        "users.id": null
                    }
                ]
            },
            {
                "file": "/platform/application/classes/Ushahidi/Core.php",
                "line": 109,
                "function": "get",
                "class": "Ushahidi_Repository",
                "type": "->",
                "args": [
                    null
                ]
            },
Ushbot
@ushbot
Nov 11 2016 07:49

[tameen] Hi,

Please ignore my last email and reply me of that, actually i need this urgently.
What i did:
1- Installed php 5.5, MySql 5.6, Apache and Composer.
2- I placed platform folder in /
3- in /etc/apache2/apache2.config change /var/www to:

<Directory /platform>
Options Indexes FollowSymLinks
AllowOverride None
Require all granted
</Directory>

4- Changed Document Root to /platform/httpdocs
5- Changed /template.htaccess to .htaccess
6- Copy the application/config/init.php file into application/config/environments/development/ (create this directory if it doesn't exist).
7- Edit init.php and changed index_file to "index.php" like:
index.php => 'FALSE'
8- Executed these commands:

chmod 0777 application/logs application/cache application/media/uploads
chown www-data application/logs application/cache application/media/upload

9- Created Databse:

CREATE DATABASE ushahidi_db;
GRANT ALL ON ushahidi_db._ to ushahidi_user@localhost IDENTIFIED BY 'ushahidi-db-password';
quit;

10- created .env file and inserted this code in it:

DB_HOST=localhost
DB_NAME=ushahidi_db
DB_TYPE=MySQLi
DB_USER=ushahidi_user
DB_PASS=ushahidi-db-password</code>

then i executed this command php composer.phar install which results in two errors:

In file 'MySQLi .php' in database folder, no information regarding database was present which causes access exception. I mentioned required variables:

// Extract the connection parameters, adding required variabels
extract($this->_config['connection'] + array(
'database' => 'ushahidi_db',
'hostname' => 'localhost',
'username' => 'ushahidi_user',
'password' => 'ushahidi-db-password',
'socket' => '',
'port' => 3306,
)

Secondly, after mentioning this it causes following error log:

{
"errors": [
{
"status": 1146,
"title": "Table 'ushahidi_db.users' doesn't exist [ SELECT users._ FROM users WHERE users.id IS NULL LIMIT 1 ]",
"message": "Table 'ushahidi_db.users' doesn't exist [ SELECT users.* FROM users WHERE users.id IS NULL LIMIT 1 ]",
"class": "Database_Exception",
"file": "/platform/application/classes/Database/MySQLi.php",
"line": 155,
"trace": [
{
"file": "/platform/vendor/ohanzee/database/src/Database/Query.php",
"line": 251,
"function": "query",
"class": "Database_MySQLi",
"type": "->",
"args": [
1,
"SELECT users.* FROM users WHERE users.id IS NULL LIMIT 1",
false,
[

                    \]
                \]
            },
            {
                "file": "/platform/application/classes/Ushahidi/Repository.php",
                "line": 188,
                "function": "execute",
                "class": "Database\_Query",
                "type": "->",
                "args": \[
                    {
                        "last\_query": null
                    }
                \]
            },
            {
                "file": "/platform/application/classes/Ushahidi/Repository.php",
                "line": 69,
                "function": "selectOne",
                "class": "Ushahidi\_Repository",
                "type": "->",
                "args": \[
                    {
                        "users.id": null
                    }
                \]
            },
            {
                "file": "/platform/application/classes/Ushahidi/Core.php",
                "line": 109,
                "function": "get",
[David Losada, Ushahidi] did you run bin/update ?
tameen
@tameen
Nov 11 2016 07:54
yes
i did
and which returns in '>> skipping git'
Ushbot
@ushbot
Nov 11 2016 09:13
[David Losada, Ushahidi] You'd need to run the phinx database migrations somehow. I'm not sure about some of the steps you took like creating/editing a mysqli.php file. Personally I've never needed to do that.
tameen
@tameen
Nov 11 2016 10:37

What i did:
1- Installed php 5.5, MySql 5.6, Apache and Composer.
2- I placed platform folder in /
3- in /etc/apache2/apache2.config change /var/www to:

<Directory /platform>
Options Indexes FollowSymLinks
AllowOverride None
Require all granted
</Directory>

4- Changed Document Root to /platform/httpdocs
5- Changed /template.htaccess to .htaccess
6- Copy the application/config/init.php file into application/config/environments/development/ (create this directory if it doesn't exist).
7- Edit init.php and changed index_file to "index.php" like:
index.php => 'FALSE'
8- Executed these commands:

chmod 0777 application/logs application/cache application/media/uploads
chown www-data application/logs application/cache application/media/upload

9- Created Databse:

CREATE DATABASE ushahidi_db;
GRANT ALL ON ushahidi_db.* to ushahidi_user@localhost IDENTIFIED BY 'ushahidi-db-password';
quit;

10- created .env file and inserted this code in it:

DB_HOST=localhost
DB_NAME=ushahidi_db
DB_TYPE=MySQLi
DB_USER=ushahidi_user
DB_PASS=ushahidi-db-password</code>

then i executed this command php composer.phar install which results in two errors:

In file 'MySQLi .php' in database folder, no information regarding database was present which causes access exception. I mentioned required variables:

// Extract the connection parameters, adding required variabels
extract($this->_config['connection'] + array(
'database' => 'ushahidi_db',
'hostname' => 'localhost',
'username' => 'ushahidi_user',
'password' => 'ushahidi-db-password',
'socket' => '',
'port' => 3306,
)

Secondly, after mentioning this it causes following error log:

{
"errors": [
{
"status": 1146,
"title": "Table 'ushahidi_db.users' doesn't exist [ SELECT users. FROM users WHERE users.id IS NULL LIMIT 1 ]",
"message": "Table 'ushahidi_db.users' doesn't exist [ SELECT users.
FROM users WHERE users.id IS NULL LIMIT 1 ]",
"class": "Database_Exception",
"file": "/platform/application/classes/Database/MySQLi.php",
"line": 155,
"trace": [
{
"file": "/platform/vendor/ohanzee/database/src/Database/Query.php",
"line": 251,
"function": "query",
"class": "Database_MySQLi",
"type": "->",
"args": [
1,
"SELECT users.* FROM users WHERE users.id IS NULL LIMIT 1",
false,
[

                    ]
                ]
            },
            {
                "file": "/platform/application/classes/Ushahidi/Repository.php",
                "line": 188,
                "function": "execute",
                "class": "Database_Query",
                "type": "->",
                "args": [
                    {
                        "last_query": null
                    }
                ]
            },
            {
                "file": "/platform/application/classes/Ushahidi/Repository.php",
                "line": 69,
                "function": "selectOne",
                "class": "Ushahidi_Repository",
                "type": "->",
                "args": [
                    {
                        "users.id": null
                    }
                ]
            },
            {
                "file": "/platform/application/classes/Ushahidi/Core.php",
                "line": 109,
                "function": "get",
                "class": "Ushahidi_Repository",
                "type": "->",
                "args": [
                    null
                ]
            },
            {
                "function": "{closure}",
                "class": "Ushah
Ushbot
@ushbot
Nov 11 2016 10:37

[tameen] What i did:
1- Installed php 5.5, MySql 5.6, Apache and Composer.
2- I placed platform folder in /
3- in /etc/apache2/apache2.config change /var/www to:

<Directory /platform>
Options Indexes FollowSymLinks
AllowOverride None
Require all granted
</Directory>

4- Changed Document Root to /platform/httpdocs
5- Changed /template.htaccess to .htaccess
6- Copy the application/config/init.php file into application/config/environments/development/ (create this directory if it doesn't exist).
7- Edit init.php and changed index_file to "index.php" like:
index.php => 'FALSE'
8- Executed these commands:

chmod 0777 application/logs application/cache application/media/uploads
chown www-data application/logs application/cache application/media/upload

9- Created Databse:

CREATE DATABASE ushahidi_db;
GRANT ALL ON ushahidi_db._ to ushahidi_user@localhost IDENTIFIED BY 'ushahidi-db-password';
quit;

10- created .env file and inserted this code in it:

DB_HOST=localhost
DB_NAME=ushahidi_db
DB_TYPE=MySQLi
DB_USER=ushahidi_user
DB_PASS=ushahidi-db-password</code>

then i executed this command php composer.phar install which results in two errors:

In file 'MySQLi .php' in database folder, no information regarding database was present which causes access exception. I mentioned required variables:

// Extract the connection parameters, adding required variabels
extract($this->_config['connection'] + array(
'database' => 'ushahidi_db',
'hostname' => 'localhost',
'username' => 'ushahidi_user',
'password' => 'ushahidi-db-password',
'socket' => '',
'port' => 3306,
)

Secondly, after mentioning this it causes following error log:

{
"errors": [
{
"status": 1146,
"title": "Table 'ushahidi_db.users' doesn't exist [ SELECT users._ FROM users WHERE users.id IS NULL LIMIT 1 ]",
"message": "Table 'ushahidi_db.users' doesn't exist [ SELECT users.* FROM users WHERE users.id IS NULL LIMIT 1 ]",
"class": "Database_Exception",
"file": "/platform/application/classes/Database/MySQLi.php",
"line": 155,
"trace": [
{
"file": "/platform/vendor/ohanzee/database/src/Database/Query.php",
"line": 251,
"function": "query",
"class": "Database_MySQLi",
"type": "->",
"args": [
1,
"SELECT users.* FROM users WHERE users.id IS NULL LIMIT 1",
false,
[

                    \]
                \]
            },
            {
                "file": "/platform/application/classes/Ushahidi/Repository.php",
                "line": 188,
                "function": "execute",
                "class": "Database\_Query",
                "type": "->",
                "args": \[
                    {
                        "last\_query": null
                    }
                \]
            },
            {
                "file": "/platform/application/classes/Ushahidi/Repository.php",
                "line": 69,
                "function": "selectOne",
                "class": "Ushahidi\_Repository",
                "type": "->",
                "args": \[
                    {
                        "users.id": null
                    }
                \]
            },
            {
                "file": "/platform/application/classes/Ushahidi/Core.php",
                "line": 109,
                "function": "get",
                "class": "Ushahidi\_Repository",
                "type": "->",
                "args": \[
Ushbot
@ushbot
Nov 11 2016 11:35
[David Losada, Ushahidi] what happens if you run ./bin/phinx migrate -c application/phinx.php ?
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 11:40
My errir
And even the files do not exist
Ushbot
@ushbot
Nov 11 2016 11:43
[David Losada, Ushahidi] that is a dynamic route, it’s not supposed to exist . index.php is all that is necessary to process those requests . Do you have a .htaccess file?
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 11:44
Yes I do
Ushbot
@ushbot
Nov 11 2016 11:44
[David Losada, Ushahidi] and running apache too?
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 11:44
Double and triple checked
tameen
@tameen
Nov 11 2016 11:45
root@tameen-ThinkPad-E520:/platform# /bin/phinx migrate -c application/phinx.php
-bash: /bin/phinx: No such file or directory
Ushbot
@ushbot
Nov 11 2016 11:45
[David Losada, Ushahidi] samurai, the other thing to check is having “AllowOverride All” in the apache virtual host specification
tameen
@tameen
Nov 11 2016 11:46
david is it for me?
Ushbot
@ushbot
Nov 11 2016 11:46
[David Losada, Ushahidi] tameen, how about composer install --no-interaction --no-scripts
[David Losada, Ushahidi] no, that was for samuraiNick
tameen
@tameen
Nov 11 2016 11:46
root@tameen-ThinkPad-E520:/platform# composer install --no-interaction --no-scripts
No command 'composer' found, did you mean:
Command 'compose' from package 'mime-support' (main)
composer: command not found
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 11:46
@ushbot i did check and its there
Screenshot from 2016-11-11 11-49-45.png
Ushbot
@ushbot
Nov 11 2016 11:47
[David Losada, Ushahidi] tameen, you need composer installed in your system. see https://getcomposer.org/doc/00-intro.md
[David Losada, Ushahidi] samuraiNick, any other virtual hosts enabled in apache config?
[David Losada, Ushahidi] if that’s not the default virtual host, it will not match “localhost” in your request
[David Losada, Ushahidi] apachectl -S should list the enabled virtual hosts for you
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 11:50
@ushbot yes a separate one for the platform
tameen
@tameen
Nov 11 2016 11:51
Screenshot from 2016-11-11 16:50:23.png
composer is installed
then why is this
Ushbot
@ushbot
Nov 11 2016 11:52
[David Losada, Ushahidi] tameen, then php composer.phar install --no-interaction --no-scripts
tameen
@tameen
Nov 11 2016 11:52
root@tameen-ThinkPad-E520:/platform# composer install --no-interaction --no-scripts
No command 'composer' found, did you mean:
Command 'compose' from package 'mime-support' (main)
composer: command not found
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 11:52
Screenshot from 2016-11-11 14-51-45.png
@ushbot have a look
tameen
@tameen
Nov 11 2016 11:53
@ushbot see this is in return:
root@tameen-ThinkPad-E520:/platform# php composer.phar install --no-interaction --no-scripts
Do not run Composer as root/super user! See https://getcomposer.org/root for details
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Warning: The lock file is not up to date with the latest changes in composer.json. You may be getting outdated dependencies. Run update to update them.
Nothing to install or update
Package guzzle/guzzle is abandoned, you should avoid using it. Use guzzlehttp/guzzle instead.
Package league/url is abandoned, you should avoid using it. Use league/uri instead.
Generating autoload files
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 11:54
did you put composer to the path? @tameen
tameen
@tameen
Nov 11 2016 11:54
Screenshot from 2016-11-11 16:54:06.png
to which path?
@d_samuraiNick_twitter
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 11:55
so that it can be used globally @tameen
Ushbot
@ushbot
Nov 11 2016 11:55
[David Losada, Ushahidi] samuraiNick, anything helpful in the apache error.log
[David Losada, Ushahidi] ?
tameen
@tameen
Nov 11 2016 11:55
where do i have to put this?
Ushbot
@ushbot
Nov 11 2016 11:55
[David Losada, Ushahidi] tameen, see https://getcomposer.org/doc/00-intro.md#globally
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 11:56
@ushbot where is this error log located?
Ushbot
@ushbot
Nov 11 2016 11:57
[David Losada, Ushahidi] usually /var/log/apache or /var/log/apache2
tameen
@tameen
Nov 11 2016 11:57
Screenshot from 2016-11-11 16:57:09.png
see another error
[InvalidArgumentException]
There was a problem connecting to the database: SQLSTATE[HY000] [1045] Access denied for user 'ushahidi_user'@'localhost' (using password:
YES)
Ushbot
@ushbot
Nov 11 2016 11:58
[David Losada, Ushahidi] from your steps, I don’t think GRANT ALL ON ushahidi_db._ to ushahidi_user@localhost IDENTIFIED BY ‘ushahidi-db-password’; is right
[David Losada, Ushahidi] try changing ushahidi_db._ to ushahidi_db.*
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 11:59
@ushbot cant see any big problem
or anything is hould run?
tameen
@tameen
Nov 11 2016 12:00
@ushbot should i change this in database or in .env file?
Ushbot
@ushbot
Nov 11 2016 12:00
[David Losada, Ushahidi] samuraiNick , 127.0.0.2 , 127.0.0.4, 127.0.0.8 did you define aliased interfaces for those? lo:0 , lo:1 , etc
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 12:02
Screenshot from 2016-11-11 15-02-00.png
like this?
@ushbot
Ushbot
@ushbot
Nov 11 2016 12:02
[David Losada, Ushahidi] mm ok maybe, I’m quite unsure how that would work without trying it myself
[David Losada, Ushahidi] try http://two.nicholasokoth.me.ke/api/v3/config
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 12:03
it has given me a json output
Ushbot
@ushbot
Nov 11 2016 12:03
[David Losada, Ushahidi] ah that’s good then
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 12:03
@ushbot is that god?
*good
tameen
@tameen
Nov 11 2016 12:04
@ushbot should i change this in database or in .env file?
@d_samuraiNick_twitter yes you have reached
Ushbot
@ushbot
Nov 11 2016 12:05
[David Losada, Ushahidi] I think you should repeat that GRANT statement
[David Losada, Ushahidi] from the mysql prompt
[David Losada, Ushahidi] but with the changes I suggested
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 12:06
but i cannot run the domain that starts with 'mine' which i used for the client
tameen
@tameen
Nov 11 2016 12:08
Screenshot from 2016-11-11 17:07:46.png
@ushbot :'(
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 12:09
@tameen add a capital letter and a number
those are the requirements for the sql for a password
Ushbot
@ushbot
Nov 11 2016 12:10
[David Losada, Ushahidi] and you should connect to mysql as root to do that mysql -u root -p
tameen
@tameen
Nov 11 2016 12:11
capital letter & number, sorry i didn't get this??
Ushbot
@ushbot
Nov 11 2016 12:11
[David Losada, Ushahidi] I’ve got to run out now, sorry, I’ll be back later
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 12:11
@tameen i encountered the issue and couldnt change the requirements for a password for the user.
tameen
@tameen
Nov 11 2016 12:12
Screenshot from 2016-11-11 17:12:09.png
@d_samuraiNick_twitter it would be great if you tell me what am i doing wrong
@ushbot
?
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 12:18
seems okay now
@tameen
tameen
@tameen
Nov 11 2016 12:19
Screenshot from 2016-11-11 17:18:54.png
then why is this??
@d_samuraiNick_twitter
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 12:21
hmm
got the same error trying to find how i solved it @tameen
tameen
@tameen
Nov 11 2016 12:22
please i will be really grateful to you, i am doing all this staff from this monday ...
*stuff
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 12:24
cool me too man
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 12:31
on mysql try to run 'mysqld' @tameen
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 12:38
i have remembered problem is how things are being written to the db kindly follow this link for help on how to alter sql mode https://www.sitepoint.com/quick-tip-how-to-permanently-change-sql-mode-in-mysql/ @tameen
tameen
@tameen
Nov 11 2016 12:38
u mean like this mysql> mysqld
after logging in
?
@d_samuraiNick_twitter
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 12:39
yeah, you would ahve used that if password became an issue to save. now that its okay you may go to the tutorial link i posted and that will sort you @tameen
that is what is preventing the tables from being created
tameen
@tameen
Nov 11 2016 12:43
see i got nothing in @@sql_mode
Screenshot from 2016-11-11 17:42:49.png
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 12:45
then this is very new territory, or try edit the file and add the parameters shown
tameen
@tameen
Nov 11 2016 12:46

[mysqld]

... other stuff will probably be here

sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

this one ??
sudo service mysql restart
stop: Unknown instance:
start: Job failed to start
tameen
@tameen
Nov 11 2016 12:51
:(
@d_samuraiNick_twitter @ushbot
tameen
@tameen
Nov 11 2016 12:59
?
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 13:06
no you are meant to put it under [mysqld]
@tameen
tameen
@tameen
Nov 11 2016 13:10
yes i did this it results in
sudo service mysql restart
stop: Unknown instance:
start: Job failed to start
@d_samuraiNick_twitter
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 13:10
may you undo @tameen
then restart apache
and try see
tameen
@tameen
Nov 11 2016 13:12
same goes for this
i undo changes and it says the same thing?
*same thing?
same thing . .
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 13:13
its shown the job failed?
tameen
@tameen
Nov 11 2016 13:13
yes
Ah ..
what to do now?
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 13:16
@tameen you did nt edit any other part of the file?
tameen
@tameen
Nov 11 2016 13:16
i added this line and removed:
[mysqld]
sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
but results are same
sudo service mysql restart
stop: Unknown instance:
start: Job failed to start
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 13:17
foolish question, without the 'other stuff' line?
@tameen
tameen
@tameen
Nov 11 2016 13:18
sorry it was a comment mentioned
i have removed.
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 13:20
ensuring the [mysqld] appears only once?
tameen
@tameen
Nov 11 2016 13:20
see mysqId
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 13:25
which location didyou findthe file?
@tameen
tameen
@tameen
Nov 11 2016 13:25
@d_samuraiNick_twitter
/etc/mysql
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 13:26
there was none in etc folder?
the '.my.cnf' @tameen
tameen
@tameen
Nov 11 2016 13:27
no sir
no my.cnf file is present in etc folder. its present in /etc/mysql folder
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 13:29
youput it at the very end yeah? @tameen
tameen
@tameen
Nov 11 2016 13:30
no i put this under [mysqld]
@d_samuraiNick_twitter
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 13:34
undoing changes? try that
@tameen
tameen
@tameen
Nov 11 2016 13:38
@d_samuraiNick_twitter - after apply changes and after removing changes, results are the same.
*aaplying
*applying
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 13:39
do i send you my file you try?
tameen
@tameen
Nov 11 2016 13:39
yes sure sir .
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 13:41
save yur current one on another text file and test with this
tameen
@tameen
Nov 11 2016 13:42
ok let me do this, and i will reply you later sir. actually i am on my way to home.
tameen
@tameen
Nov 11 2016 14:59
same results:
service mysql restart
stop: Unknown instance:
start: Job failed to start
@d_samuraiNick_twitter
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 15:00
which version of apache do you have?
may you try to reinstall mysql?
purge then install
see if thst will clear all the errors
@tameen
tameen
@tameen
Nov 11 2016 15:01
Server version: Apache/2.4.7 (Ubuntu)
Server built: Jul 15 2016 15:34:04
Fragile masculinity
@d_samuraiNick_twitter
Nov 11 2016 15:02
so php -v is 7.0?
tameen
@tameen
Nov 11 2016 15:02
PHP 5.5.9
it works finally
mysql works finally
...
but i got "errors": [
{
"status": 2,
"title": "mysqli::mysqli(): (28000/1045): Access denied for user 'www-data'@'localhost' (using password: NO)",
"message": "mysqli::mysqli(): (28000/1045): Access denied for user 'www-data'@'localhost' (using password: NO)",
"class": "Database_Exception",
"file": "/platform/application/classes/Database/MySQLi.php",
"line": 59,
Nesp
@Nesp
Nov 11 2016 16:22

@ushbot I tried to use the developer tools and say add a new post. But I could not see any api operation in the console. Is there a trick I don't know?

Thanks!

tameen
@tameen
Nov 11 2016 16:53
@d_samuraiNick_twitter @ushbot
Ushbot
@ushbot
Nov 11 2016 19:51
[David Losada, Ushahidi] Nesp, there shouldn’t be any tricks. When you submit the post to be added, the operation should be reflected in chrome’s developer console (network tab)
[David Losada, Ushahidi] tameen, it’s not trying to use a password .. your .env file with the database connection details must be in the place where you unzipped the platform files.. and from there you invoke the bin/update , bin/phinx etc scripts