[ixpmanager] Cannot Log in

[Barry O'Donovan]

Anibe,

looks like you ran the fixtures.php script twice and both times with
incomplete information.

Can you drop the database:

DROP DATABASE ixp;

And recreate it:

CREATE DATABASE `ixp` CHARACTER SET = 'utf8mb4' COLLATE =
'utf8mb4_unicode_ci';


Privileges should be unaffected by the above. Then recreate the schema
(from IXP Manager installation directory):

./bin/doctrine2-cli.php orm:schema-tool:create
mysql -u username -ppassword ixp < tools/sql/views.sql

(replacing username and password as appropriate).

Then repeat fixtures using these instructions:

https://github.com/inex/IXP-Manager/wiki/Installation-07-Creating-Initial-Database-Objects

 - Barry




Anibe Onuche wrote:
> Hi Barry,
> 
> This is my output ( the name and password are dummy)
> 
> 
>  mysql> SELECT * FROM user;
> +----+--------+----------+----------+-------+------------------+------+-------+----------+-------------+---------------+--------
> -+---------+
> | id | custid | username | password | email | authorisedMobile | uid  |
> privs | disabled | lastupdated | lastupdatedby |
> creator                     | created |
> +----+--------+----------+----------+-------+------------------+------+-------+----------+-------------+---------------+--------
> -+---------+
> |  1 |   NULL | ixp   | NULL     | NULL  | NULL             | NULL | 
> NULL |     NULL | NULL        |          NULL |
> NULL                        | NULL    |
> |  2 |   NULL | NULL     | ixp   | NULL  | NULL             | NULL | 
> NULL |     NULL | NULL        |          NULL |
> NULL                        | NULL    |
> +----+--------+----------+----------+-------+------------------+------+-------+----------+-------------+---------------+--------
> -+---------+
> 2 rows in set (0.00 sec)
> 
> 
> Thanks.
> 
> Anibe Onuche
> 
> 
> On 9/27/2016 9:19 PM, Barry O'Donovan wrote:
>>
>> SELECT * FROM user;
> 
> _______________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie
> https://www.inex.ie/mailman/listinfo/ixpmanager

-- 

Kind regards,
Barry O'Donovan
INEX Operations

https://www.inex.ie/support/
+353 1 531 3339