Не совсем ясен этот момент.dAverk писал(а): запрос с биллинга дёргает у пользователя ip из услуги "Локальная сеть", свич и порт из его профиля и кладёт файл в виде: #свич порт ip_клиента
service_id = связка "Локальная сеть"
Подскажите плиз аналог mcookie для freebsd.dAverk писал(а):Код: Выделить всё
#!/bin/bash service=/sbin/service BASE_STR=`mcookie` # 32-символьный (128 бит) magic cookie. POS=11 # Произвольная позиция в строке magic cookie. LEN=5 # $LEN последовательных символов.
Код: Выделить всё
dd if=/dev/urandom bs=10 count=10 | tr -dc A-Za-z0-9_ | head -c8Код: Выделить всё
select
(
select
INET_NTOA(b.router_bin_ip & 0x00000000FFFFFFFF)
from
users a, routers_info b
where
b.id = a.remote_switch_id and a.id = c.user_id and a.is_deleted = 0
)
as
switch_ip,
(
select
a.port_number
from
users a
where
a.id = c.user_id and is_deleted = 0
)
as
switch_port,
(
select
INET_NTOA(a.ip & 0x00000000FFFFFFFF)
from
ip_groups a
where
a.ip_group_id =
(
select
a.ip_group_id
from
iptraffic_service_links a
where
a.id = c.id and is_deleted = 0
)
and is_deleted = 0
)
as
user_ip
from
service_links c, services_data
where
services_data.parent_service_id = 3 and services_data.is_deleted = 0 and c.service_id = services_data.id and c.is_deleted = 0 and services_data.tariff_id != 0
order by
switch_ip, switch_port
Спс. все работает.dAverk писал(а):честно говоря хз =)
вот те маджик жопа =)Код: Выделить всё
dd if=/dev/urandom bs=10 count=10 | tr -dc A-Za-z0-9_ | head -c8
Код: Выделить всё
select (select INET_NTOA(b.router_bin_ip & 0x00000000FFFFFFFF) from users a, routers_info b where b.id=a.remote_switch_id and a.id=c.user_id and a.is_deleted='0') as switch_ip, (select a.port_number from users a where a.id=c.user_id and is_deleted='0') as switch_port, (select INET_NTOA(a.ip & 0x00000000FFFFFFFF) from ip_groups a where a.ip_group_id=(select a.ip_group_id from iptraffic_service_links a where a.id=c.id and is_deleted='0') and is_deleted='0') as user_ip from service_links c, services_data where services_data.parent_service_id='3' and services_data.is_deleted='0' and c.service_id=services_data.id and c.is_deleted='0' and services_data.tariff_id!='0' order by switch_ip, switch_port;Код: Выделить всё
select * from (select (select INET_NTOA(b.router_bin_ip & 0xFFFFFFFF) from users a, routers_info b where b.id = a.remote_switch_id and a.id = c.user_id and a.is_deleted = '0') as switch_ip, (select a.port_number from users a where a.id = c.user_id and is_deleted = 0 and a.port_number > '0') as switch_port, (select INET_NTOA(a.ip & 0xFFFFFFFF) from ip_groups a where a.ip_group_id = (select a.ip_group_id from iptraffic_service_links a where a.id = c.id and is_deleted = '0') and is_deleted = '0') as user_ip from service_links c where c.service_id = '5' and is_deleted = '0' order by user_ip) u where u.switch_ip is not NULL and u.switch_port is not NULL;