hello guys,
i need help for setup opennetadmin.

I'm having trouble installing the "opennetadmin" no "suse 11.2" which is giving syntax error in the database. When installing a previous version is ok, but when I try to login as admin, he returns to the User "guest" thus permission denied when add host for example.

version php 5.3.8
apache 2.x
mysql Ver 5.5.16
Suse 12.1

Thank you.

I believe your issue is that your mysql version is 5.5.

The problem is that they finally removed the TYPE keyword in the create table syntax and my code still uses it. The next release will fix the installer so it should work with mysql 4.0 and newer (according to the docs I saw, thats when they added the ENGINE syntax)

you can do the following to fix the installer for now: cd /opt/ona/install; mv ona-table_schema.xml ona-table_schema.xml.bak; sed -s "s/TYPE=INNODB/ENGINE=INNODB/" ona-table_schema.xml.bak > ona-table_schema.xml

ok ok
and problem with autentication, when don't access account admin ?

thak you.

I'll need to have more information to help solve this issue.

show the output of /var/log/ona.log when you are logging in as admin. Is there any other errors or messages that you see in the GUI other than it just not logging in? Also to get some detail on the current user and permissions, click the little man icon just to the right of the login button at the top right of the screen.

hi matt,

simply changes a username in console when authentic.

follows the log:

Dec 26 23:43:12 UNKNOWN_SVR_NAME admin@::1: INFO => Authorization successful for admin
Dec 26 23:43:23 UNKNOWN_SVR_NAME guest@::1: INFO => Authorization successful for guest
Dec 26 23:43:23 UNKNOWN_SVR_NAME guest@::1: DEBUG => auth() User[guest] does not have the subnet_add permission
Dec 26 23:43:23 UNKNOWN_SVR_NAME guest@::1: DEBUG => auth() User[guest] does not have the host_modify permission
Dec 26 23:43:23 UNKNOWN_SVR_NAME guest@::1: DEBUG => auth() User[guest] does not have the host_modify permission
Dec 26 23:43:23 UNKNOWN_SVR_NAME guest@::1: DEBUG => auth() User[guest] does not have the dns_record_del permission
Dec 26 23:43:23 UNKNOWN_SVR_NAME guest@::1: DEBUG => auth() User[guest] does not have the vlan_add permission
Dec 26 23:43:23 UNKNOWN_SVR_NAME guest@::1: DEBUG => auth() User[guest] does not have the vlan_add permission
Dec 26 23:43:23 UNKNOWN_SVR_NAME guest@::1: DEBUG => auth() User[guest] does not have the subnet_add permission
Dec 26 23:43:23 UNKNOWN_SVR_NAME guest@::1: DEBUG => auth() User[guest] does not have the location_add permission
Dec 26 23:43:23 UNKNOWN_SVR_NAME guest@::1: DEBUG => auth() User[guest] does not have the host_del permission
Dec 26 23:43:23 UNKNOWN_SVR_NAME guest@::1: DEBUG => auth() User[guest] does not have the dns_record_add permission
Dec 26 23:43:23 UNKNOWN_SVR_NAME guest@::1: DEBUG => auth() User[guest] does not have the dns_record_add permission
Dec 26 23:43:23 UNKNOWN_SVR_NAME guest@::1: DEBUG => auth() User[guest] does not have the advanced permission
Dec 26 23:43:45 UNKNOWN_SVR_NAME guest@::1: INFO => Authorization successful for guest
Dec 26 23:43:49 UNKNOWN_SVR_NAME guest@::1: INFO => Authorization successful for guest
Dec 26 23:43:49 UNKNOWN_SVR_NAME guest@::1: INFO => Authorization successful for guest


thank you

hmm well I was hoping for more info than that

you can bump up the debug level to hopefully give us more to go off of. I've not seen this issue before and I dont have an easy/quick way to set up a similar environment to test with.

One way to bump the debug level will be to use the dcm.pl tool. Once you install that (if you have not already) you can run the following command:

/opt/ona/bin/dcm.pl -r ona_sql sql="update sys_config set value=6 where name like 'debug'" commit

you could also use some other tool to issue the SQL as well. Hopefully by bumping up the debug level we can see more detail on what is up. dont forget to set the debug level back down to 0 when done.

Thanks