EVE users manage mysql database

Before posting something, READ the changelog, WATCH the videos, howto and provide following:
Your install is: Bare metal, ESXi, what CPU model, RAM, HD, what EVE version you have, output of the uname -a and any other info that might help us faster.

Moderator: mike

Post Reply
anon123
Posts: 15
Joined: Mon Nov 20, 2017 9:03 am

EVE users manage mysql database

Post by anon123 » Tue Dec 12, 2017 2:17 pm

Hi everyone,

I would like to know if it would be possible to import users in the mysql database directly. So I managed to find the login root and password eve-ng to access the database and I also found the existing users :

Code: Select all


mysql> select * from users;
+----------+--------------------------------------+----------------+------------+----------------------+------------------------------------------------------------------+------------+---------------+-------+--------+-------+
| username | cookie                               | email          | expiration | name                 | password                                                         | session    | ip            | role  | folder | html5 |
+----------+--------------------------------------+----------------+------------+----------------------+------------------------------------------------------------------+------------+---------------+-------+--------+-------+
| admin    | 2fb33a36-da04-4761-8c6b-1b7de4b65683 | root@localhost |         -1 | Eve-NG Administrator | 85262adf74518bbb70c7cb94cd6159d91669e5a81edf1efebd543eadbda9fa2b | 1513084516 | 172.24.168.40 | admin | /      |     1 |
| test     | NULL                                 | test@local.com |         -1 | test                 | 9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08 |       NULL | NULL          | admin | NULL   |  NULL |
+----------+--------------------------------------+----------------+------------+----------------------+------------------------------------------------------------------+------------+---------------+-------+--------+-------+
2 rows in set (0.00 sec)
I would like to know what kind of hash you used for the passwords for exemple "9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08" is "test"
Can you help me to import some users so I can try the platform with my corporates. I am planning to buy the pro version and I want to try the platform and present it at my work.

Regards;

ramindia
Posts: 409
Joined: Sun Mar 19, 2017 10:27 pm

Re: EVE users manage mysql database

Post by ramindia » Sat Dec 16, 2017 3:15 pm

anon123 wrote:
Tue Dec 12, 2017 2:17 pm
Hi everyone,

I would like to know if it would be possible to import users in the mysql database directly. So I managed to find the login root and password eve-ng to access the database and I also found the existing users :

Code: Select all


mysql> select * from users;
+----------+--------------------------------------+----------------+------------+----------------------+------------------------------------------------------------------+------------+---------------+-------+--------+-------+
| username | cookie                               | email          | expiration | name                 | password                                                         | session    | ip            | role  | folder | html5 |
+----------+--------------------------------------+----------------+------------+----------------------+------------------------------------------------------------------+------------+---------------+-------+--------+-------+
| admin    | 2fb33a36-da04-4761-8c6b-1b7de4b65683 | root@localhost |         -1 | Eve-NG Administrator | 85262adf74518bbb70c7cb94cd6159d91669e5a81edf1efebd543eadbda9fa2b | 1513084516 | 172.24.168.40 | admin | /      |     1 |
| test     | NULL                                 | test@local.com |         -1 | test                 | 9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08 |       NULL | NULL          | admin | NULL   |  NULL |
+----------+--------------------------------------+----------------+------------+----------------------+------------------------------------------------------------------+------------+---------------+-------+--------+-------+
2 rows in set (0.00 sec)
I would like to know what kind of hash you used for the passwords for exemple "9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08" is "test"
Can you help me to import some users so I can try the platform with my corporates. I am planning to buy the pro version and I want to try the platform and present it at my work.

Regards;
you can import the users with default password of eve
but you breaking the system, But suggested method is use UI to create users

R!

anon123
Posts: 15
Joined: Mon Nov 20, 2017 9:03 am

Re: EVE users manage mysql database

Post by anon123 » Mon Dec 18, 2017 11:10 am

ramindia wrote:
Sat Dec 16, 2017 3:15 pm
anon123 wrote:
Tue Dec 12, 2017 2:17 pm
Hi everyone,

I would like to know if it would be possible to import users in the mysql database directly. So I managed to find the login root and password eve-ng to access the database and I also found the existing users :

Code: Select all


mysql> select * from users;
+----------+--------------------------------------+----------------+------------+----------------------+------------------------------------------------------------------+------------+---------------+-------+--------+-------+
| username | cookie                               | email          | expiration | name                 | password                                                         | session    | ip            | role  | folder | html5 |
+----------+--------------------------------------+----------------+------------+----------------------+------------------------------------------------------------------+------------+---------------+-------+--------+-------+
| admin    | 2fb33a36-da04-4761-8c6b-1b7de4b65683 | root@localhost |         -1 | Eve-NG Administrator | 85262adf74518bbb70c7cb94cd6159d91669e5a81edf1efebd543eadbda9fa2b | 1513084516 | 172.24.168.40 | admin | /      |     1 |
| test     | NULL                                 | test@local.com |         -1 | test                 | 9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08 |       NULL | NULL          | admin | NULL   |  NULL |
+----------+--------------------------------------+----------------+------------+----------------------+------------------------------------------------------------------+------------+---------------+-------+--------+-------+
2 rows in set (0.00 sec)
I would like to know what kind of hash you used for the passwords for exemple "9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08" is "test"
Can you help me to import some users so I can try the platform with my corporates. I am planning to buy the pro version and I want to try the platform and present it at my work.

Regards;
you can import the users with default password of eve
but you breaking the system, But suggested method is use UI to create users

R!
Can you imagine importing 250 users one by one from the webui? Do you think in the pro version we will be able to import users with the webui from a file CSV for example?
Thanks;

ramindia
Posts: 409
Joined: Sun Mar 19, 2017 10:27 pm

Re: EVE users manage mysql database

Post by ramindia » Thu Dec 21, 2017 4:27 pm

anon123 wrote:
Mon Dec 18, 2017 11:10 am
ramindia wrote:
Sat Dec 16, 2017 3:15 pm
anon123 wrote:
Tue Dec 12, 2017 2:17 pm
Hi everyone,

I would like to know if it would be possible to import users in the mysql database directly. So I managed to find the login root and password eve-ng to access the database and I also found the existing users :

Code: Select all


mysql> select * from users;
+----------+--------------------------------------+----------------+------------+----------------------+------------------------------------------------------------------+------------+---------------+-------+--------+-------+
| username | cookie                               | email          | expiration | name                 | password                                                         | session    | ip            | role  | folder | html5 |
+----------+--------------------------------------+----------------+------------+----------------------+------------------------------------------------------------------+------------+---------------+-------+--------+-------+
| admin    | 2fb33a36-da04-4761-8c6b-1b7de4b65683 | root@localhost |         -1 | Eve-NG Administrator | 85262adf74518bbb70c7cb94cd6159d91669e5a81edf1efebd543eadbda9fa2b | 1513084516 | 172.24.168.40 | admin | /      |     1 |
| test     | NULL                                 | test@local.com |         -1 | test                 | 9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08 |       NULL | NULL          | admin | NULL   |  NULL |
+----------+--------------------------------------+----------------+------------+----------------------+------------------------------------------------------------------+------------+---------------+-------+--------+-------+
2 rows in set (0.00 sec)
I would like to know what kind of hash you used for the passwords for exemple "9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08" is "test"
Can you help me to import some users so I can try the platform with my corporates. I am planning to buy the pro version and I want to try the platform and present it at my work.

Regards;
you can import the users with default password of eve
but you breaking the system, But suggested method is use UI to create users

R!
Can you imagine importing 250 users one by one from the webui? Do you think in the pro version we will be able to import users with the webui from a file CSV for example?
Thanks;

EVE-NG com edition not meant to use for commercial use, if you looking 250 users you should contact EVE-NG team for further support.

R!

Post Reply