Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problems to add Networks #2

Open
enrutador opened this issue Sep 27, 2016 · 1 comment
Open

Problems to add Networks #2

enrutador opened this issue Sep 27, 2016 · 1 comment

Comments

@enrutador
Copy link

Hi Alpha
I have a problem when i create a network for use VpnServer mapping. When I make the settings, I always get the following error:

"execute query error: Column 'user_id' cannot be null
2016-09-27 15_21_59-vpnman - vpn management platform

2016-09-27 15_31_20-vpnman - vpn management platform

I have users,accounts, and VPNs tunels configured OK. What value need the var "mapped_to" ?

A lot of thanks

@federico-alphasi
Copy link
Contributor

Hi, i confirm the problem.
VPN networks have been designed to be connected to VPN nodes and not directly to VPN server.
To fix the problem you have to remove the 'fk_networks_user_id' foreign key from networks table.
You can use the following SQL script:

ALTER TABLE networks
DROP FOREIGN KEY fk_networks_user_id;
ALTER TABLE networks
CHANGE COLUMN user_id user_id INT(10) UNSIGNED NULL ;

PS: When you create a network, the "Mapped to" field can be left blank.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants