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@delcolimba /usr/local # sbin/serctl fifo trusted_dump > 200 OK > > root@delcolimba /usr/local # sbin/serctl fifo trusted_reload > 400 Trusted table reload failed > > root@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(a)lists.iptel.org > http://lists.iptel.org/mailman/listinfo/serusers

On 01/16/2009 04:25 PM, caio wrote: 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@delcolimba /usr/local # sbin/serctl fifo trusted_dump >>> 200 OK >>> >>> root@delcolimba /usr/local # sbin/serctl fifo trusted_reload >>> 400 Trusted table reload failed >>> >>> root@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(a)lists.iptel.org >>> http://lists.iptel.org/mailman/listinfo/serusers > > _______________________________________________ > Serusers mailing list > Serusers(a)lists.iptel.org > http://lists.iptel.org/mailman/listinfo/serusers

Could you give a try to another DB server? For example query the linux mysql server from the Solaris machine, if it is accessible.

Thank you very much for the debug lines! I think SER simply uses the field types returned by the mysql server, so there might be a problem with the server or library. You can check what the field types are along with their names returned by the server in modules/mysql/res.c, search for the mysql_fetch_fields function. Miklos