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

[Barry O'Donovan]

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 wrote on 29/12/2020 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
> 
> 
> On Tue, Dec 29, 2020 at 10:44 AM Yann Robin 
> <yann at islandbridgenetworks.ie <mailto:yann at islandbridgenetworks.ie>> wrote:
> 
>     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:
>>     Dear support
>>
>>     After I finish the installation , I can't login to the ixpmanager
>>     web access, whey?
>>     so you can check the link to see the problem?
>>
>>     https://imgur.com/a/Rqf0bT5
>>
>>     thanks advanced,,,
>>
>>
>>     _______________________________________________
>>     INEX IXP Manager mailing list
>>     ixpmanager at inex.ie <mailto:ixpmanager at inex.ie>
>>     Unsubscribe or change options here:https://www.inex.ie/mailman/listinfo/ixpmanager
> 
>     -- 
>     Kind regards,
> 
>     Yann Robin
> 
>     +353 1 531 3334
> 
>     Island Bridge Networks Ltd.
> 
>     https://www.islandbridgenetworks.ie/
>     <http://www.islandbridgenetworks.ie/>
>     <https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach>
> 
> 
> 
> _______________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie
> Unsubscribe or change options here: https://www.inex.ie/mailman/listinfo/ixpmanager
> 


-- 

Kind regards,
Barry O'Donovan
INEX Operations

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