[ixpmanager] Your user account is not associated with any members., Why?

[Nick Hilliard]

Hi Basil,

There are no normal situations where you need to execute SQL commands to 
get IXP manager to do something.

If you can't log in at the moment after executing raw SQL commands, 
there's a good chance that you've done some damage to the database, so 
you will need to restore from backups.

Once you've installed IXP Manager via the installer,  you should add all 
future usernames / organisations / etc via the web front-end.

Nick

> Basil Elbalaawi <mailto:saifbasilyazan at gmail.com>
> 30 December 2020 at 14:36
>
> Hi support
>
> the problem still as is, so you have nothing or misconfigured 
> configuration file attached  with manual configuration?
>
> regards,,,
>
>
>
> _______________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie
> Unsubscribe or change options here: 
> https://www.inex.ie/mailman/listinfo/ixpmanager
> Basil Elbalaawi <mailto:saifbasilyazan at gmail.com>
> 29 December 2020 at 11:22
> Hi Barry
>
> Ok , let me send the output file ixp-manager and the manual 
> configuration commands , used where arranged by txt file attached.
>
> https://imgur.com/a/tgg6sfk
>
> see attached file
>
> I am waiting your reply,,,
>
>
>
> _______________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie
> Unsubscribe or change options here: 
> https://www.inex.ie/mailman/listinfo/ixpmanager
> Barry O'Donovan <mailto:barry.odonovan at inex.ie>
> 29 December 2020 at 10:44
> Basil,
>
> what exact instructions are you following for the installation?
>
> How you used the automated installation script?
>
> Have you reviewed the videos?
>
> https://www.ixpmanager.org/download/install
>
>  - Barry
>
>
>
>
> Basil Elbalaawi <mailto:saifbasilyazan at gmail.com>
> 29 December 2020 at 10:12
>
> Hi Yann
>
> i am posed :
> systemctl restart memcached.service
> php ${IXPROOT}/artisan update:customer
>
> *root at ixpmanager:/srv/ixpmanager# php artisan update:customer*
>
>
> ONLY RUN ONCE AND ONLY WHEN UPGRADING TO IXP Manager v5.0.0 from v4.9.x
>
> THIS WILL TRUNCATE THE customer:user n:m TABLE - meaning any users 
> created after upgrading to v5.0.0 will be unlinked from their customers.
>
>
> This command will restructure the customer/user data from 1:m to n:m.
>
> Generally, this command should only ever be run once and only when 
> migrating to V5.0.0.
>
> Are you sure you wish to proceed?  (yes/no) [no]:
>  > yes
>
> The customer_to_users table has been truncated
> Migration in progress, please wait...
>  0/2 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   0%
> In AbstractMySQLDriver.php line 103:
>
>   An exception occurred while executing 'INSERT INTO customer_to_users 
> (privs, extra_attributes, last_login_date, last_login_from, 
> last_login_via, created_at, customer_id, user_id) V
>   ALUES (?, ?, ?, ?, ?, ?, ?, ?)' with params [3, 
> "{\"created_by\":{\"type\":\"migration-script\"}}", null, false, null, 
> "2020-12-29 11:44:47", null, 1]:
>
>   SQLSTATE[23000]: Integrity constraint violation: 1048 Column 
> 'customer_id' cannot be null
>
>
> In PDOStatement.php line 129:
>
>   SQLSTATE[23000]: Integrity constraint violation: 1048 Column 
> 'customer_id' cannot be null
>
>
> In PDOStatement.php line 127:
>
>   SQLSTATE[23000]: Integrity constraint violation: 1048 Column 
> 'customer_id' cannot be null
>
>
>
> *without any change ! What can I do now???*
>
> FYI, i am installed v5.5 before 5 months and upgrade to v5.6 without 
> any problem , now i created now VM with v5.7 and follow every 
> procedure in the manual installation , but after completed then puase 
> http://192.168.1.202/login , get the error as you see in the link: 
> https://imgur.com/a/Rqf0bT5
>
>
>
>
> _______________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie
> Unsubscribe or change options here: 
> https://www.inex.ie/mailman/listinfo/ixpmanager
> Yann Robin <mailto:yann at islandbridgenetworks.ie>
> 29 December 2020 at 08:44
> Hello,
>
> Did you run the following command line ?
>
> update:customer2users
>
> This command should solve your issue.
>
> Basil Elbalaawi wrote on 27/12/2020 10:19:
>
>
>
> _______________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie
> Unsubscribe or change options here: 
> https://www.inex.ie/mailman/listinfo/ixpmanager

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.inex.ie/pipermail/ixpmanager/attachments/20201230/ad37fb70/attachment.htm>