[Serusers] Error loading "trusted" table (permissions.so)

[Miklos Tirpak]

On 01/16/2009 04:25 PM, caio wrote:
> ser version 0.9.7
> but it does work on Gentoo linux.
> when implemented on Solaris it fails.

Do the two machines query the same database server?

There might be a problem with the field types, please check that they 
are strings, and not blobs. Please send me a "describe trusted" mysql 
output.

Regards,
Miklos

> 
> regards,
> caio
> 
> Miklos Tirpak escribió:
>> Hello,
>>
>> what is your SER version?
>> I works for me with 2.0, compiled from CVS.
>>
>> Miklos
>>
>> On 01/16/2009 01:00 PM, caio wrote:
>>> Hello all,
>>>
>>> Does anyone knows about this "permission.so" module error when try to 
>>> load "trusted" table (mysql)?
>>>
>>> If "trusted" table is empty, there is no error, but whan at least 
>>> there is 1 record, the error appears.
>>>
>>> for example:
>>>
>>> mysql> select * from trusted;
>>> +---------------+-------+--------------+
>>> | src_ip        | proto | from_pattern |
>>> +---------------+-------+--------------+
>>> | 10.124.35.253 | any   | ^sip:.*$     |
>>> +---------------+-------+--------------+
>>>
>>> and when I try lo restart ser:
>>>
>>> Jan 15 15:34:45 delcolimba /usr/local/sbin/ser[703]: [ID 966737 
>>> daemon.info] permissions - initializing
>>> Jan 15 15:34:45 delcolimba /usr/local/sbin/ser[703]: [ID 414293 
>>> daemon.warning] Default allow file 
>>> (/usr/local/etc/ser/permissions.allow) not found => empty rule set
>>> Jan 15 15:34:45 delcolimba /usr/local/sbin/ser[703]: [ID 844440 
>>> daemon.warning] Default deny file 
>>> (/usr/local/etc/ser/permissions.deny) not found => empty rule set
>>>
>>> Jan 15 15:34:45 delcolimba /usr/local/sbin/ser[703]: [ID 895822 
>>> daemon.error] ERROR: permissions: trusted_reload(): Database problem
>>> Jan 15 15:34:45 delcolimba /usr/local/sbin/ser[703]: [ID 650101 
>>> daemon.crit] init_trusted(): Reload of trusted table failed
>>> Jan 15 15:34:45 delcolimba /usr/local/sbin/ser[703]: [ID 345573 
>>> daemon.error] Error while initializing allow_trusted function
>>> Jan 15 15:34:45 delcolimba /usr/local/sbin/ser[703]: [ID 660978 
>>> daemon.error] init_mod(): Error while initializing module permissions
>>>
>>>
>>> or when executing serctl fifo cmd:
>>>
>>> root at delcolimba /usr/local # sbin/serctl fifo trusted_dump
>>> 200 OK
>>>
>>> root at delcolimba /usr/local # sbin/serctl fifo trusted_reload
>>> 400 Trusted table reload failed
>>>
>>> root at delcolimba /usr/local # tail /var/adm/messages
>>>
>>> Jan 15 15:45:37 delcolimba /usr/local/sbin/ser[717]: [ID 895822 
>>> daemon.error] ERROR: permissions: trusted_reload(): Database problem
>>> Jan 15 15:45:37 delcolimba /usr/local/sbin/ser[717]: [ID 450600 
>>> daemon.error] ERROR: fifo_server: command (trusted_reload) processing 
>>> failed
>>>
>>>
>>> Thank you,
>>>
>>> Caio
>>> _______________________________________________
>>> Serusers mailing list
>>> Serusers at lists.iptel.org
>>> http://lists.iptel.org/mailman/listinfo/serusers
> 
> _______________________________________________
> Serusers mailing list
> Serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers