mac_track_interfaces table doesn't exist

Support questions about the MAC Track plugin

Moderators: Developers, Moderators

Post Reply
peecee
Cacti User
Posts: 146
Joined: Tue Feb 26, 2008 7:26 am

mac_track_interfaces table doesn't exist

Post by peecee »

I just installed mactrack 2.4 and don't have the mac_track_interfaces table. Rather than try to create that table manually and hope that's all I'm missing, is there some other course of action? I've tried uninstalling and reinstalling with the same result.
shadowmanr6
Posts: 14
Joined: Fri Apr 16, 2010 11:19 am

Post by shadowmanr6 »

I just recently pulled from the svn and that same table wouldn't generate for me, i just grabbed the create table code from the setup.php for the mac_track_interfaces and jumped into mysql:

CREATE TABLE `mac_track_interfaces` (
`site_id` int(10) unsigned NOT NULL default '0',
`device_id` int(10) unsigned NOT NULL default '0',
`sysUptime` int(10) unsigned NOT NULL default '0',
`ifIndex` int(10) unsigned NOT NULL default '0',
`ifName` varchar(128) NOT NULL,
`ifAlias` varchar(255) NOT NULL,
`ifDescr` varchar(128) NOT NULL,
`ifType` int(10) unsigned NOT NULL default '0',
`ifMtu` int(10) unsigned NOT NULL default '0',
`ifSpeed` int(10) unsigned NOT NULL default '0',
`ifHighSpeed` int(10) unsigned NOT NULL default '0',
`ifDuplex` int(10) unsigned NOT NULL default '0',
`ifMauAutoNegAdminStatus` integer UNSIGNED NOT NULL default '0'
`ifMauAutoNegRemoteSignaling` integer UNSIGNED NOT NULL default '0'
`ifPhysAddress` varchar(20) NOT NULL,
`ifAdminStatus` int(10) unsigned NOT NULL default '0',
`ifOperStatus` int(10) unsigned NOT NULL default '0',
`ifLastChange` int(10) unsigned NOT NULL default '0',
`linkPort` tinyint(3) unsigned NOT NULL default '0',
`vlan_id` int(10) unsigned NOT NULL,
`vlan_name` varchar(128) NOT NULL,
`vlan_trunk` tinyint(3) unsigned NOT NULL,
`vlan_trunk_status` int(10) unsigned NOT NULL,
`ifInOctets` int(10) unsigned NOT NULL default '0',
`ifOutOctets` int(10) unsigned NOT NULL default '0',
`ifHCInOctets` bigint(20) unsigned NOT NULL default '0',
`ifHCOutOctets` bigint(20) unsigned NOT NULL default '0',
`ifInNUcastPkts` int(10) unsigned NOT NULL default '0',
`ifOutNUcastPkts` int(10) unsigned NOT NULL default '0',
`ifInUcastPkts` int(10) unsigned NOT NULL default '0',
`ifOutUcastPkts` int(10) unsigned NOT NULL default '0',
`ifInDiscards` int(10) unsigned NOT NULL default '0',
`ifInErrors` int(10) unsigned NOT NULL default '0',
`ifInUnknownProtos` int(10) unsigned NOT NULL default '0',
`ifOutDiscards` int(10) unsigned default '0',
`ifOutErrors` int(10) unsigned default '0',
`inBound` double NOT NULL default '0',
`outBound` double NOT NULL default '0',
`int_ifInOctets` int(10) unsigned NOT NULL default '0',
`int_ifOutOctets` int(10) unsigned NOT NULL default '0',
`int_ifHCInOctets` bigint(20) unsigned NOT NULL default '0',
`int_ifHCOutOctets` bigint(20) unsigned NOT NULL default '0',
`int_ifInNUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifOutNUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifInUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifOutUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifInDiscards` float unsigned NOT NULL default '0',
`int_ifInErrors` float unsigned NOT NULL default '0',
`int_ifInUnknownProtos` float unsigned NOT NULL default '0',
`int_ifOutDiscards` float unsigned NOT NULL default '0',
`int_ifOutErrors` float unsigned NOT NULL default '0',
`last_up_time` timestamp NOT NULL default '0000-00-00 00:00:00',
`last_down_time` timestamp NOT NULL default '0000-00-00 00:00:00',
`stateChanges` int(10) unsigned NOT NULL default '0',
`int_discards_present` tinyint(3) unsigned NOT NULL default '0',
`int_errors_present` tinyint(3) unsigned NOT NULL default '0',
`present` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`site_id`,`device_id`,`ifIndex`),
KEY `ifDescr` (`ifDescr`),
KEY `ifType` (`ifType`),
KEY `ifSpeed` (`ifSpeed`),
KEY `ifMTU` (`ifMtu`),
KEY `ifAdminStatus` (`ifAdminStatus`),
KEY `ifOperStatus` (`ifOperStatus`),
KEY `ifInDiscards` USING BTREE (`ifInUnknownProtos`),
KEY `ifInErrors` USING BTREE (`ifInUnknownProtos`))
ENGINE=MyISAM;
peecee
Cacti User
Posts: 146
Joined: Tue Feb 26, 2008 7:26 am

Post by peecee »

Is that all that's missing? It doesn't seem like it's working, or I don't have the options set up right. I guess I'll just wait for the doc. Maybe a 2.5 version will fix the interfaces issue. Thanks for the structure though.
shadowmanr6
Posts: 14
Joined: Fri Apr 16, 2010 11:19 am

Post by shadowmanr6 »

CORRECTION! sorry i forgot when i ran it his code was missing 2 commas at the end of the ifMauAutoNegAdminStatus and ifMauAutoNegRemoteSignaling lines, so this is the corrected one:

CREATE TABLE `mac_track_interfaces` (
`site_id` int(10) unsigned NOT NULL default '0',
`device_id` int(10) unsigned NOT NULL default '0',
`sysUptime` int(10) unsigned NOT NULL default '0',
`ifIndex` int(10) unsigned NOT NULL default '0',
`ifName` varchar(128) NOT NULL,
`ifAlias` varchar(255) NOT NULL,
`ifDescr` varchar(128) NOT NULL,
`ifType` int(10) unsigned NOT NULL default '0',
`ifMtu` int(10) unsigned NOT NULL default '0',
`ifSpeed` int(10) unsigned NOT NULL default '0',
`ifHighSpeed` int(10) unsigned NOT NULL default '0',
`ifDuplex` int(10) unsigned NOT NULL default '0',
`ifMauAutoNegAdminStatus` integer UNSIGNED NOT NULL default '0',
`ifMauAutoNegRemoteSignaling` integer UNSIGNED NOT NULL default '0',
`ifPhysAddress` varchar(20) NOT NULL,
`ifAdminStatus` int(10) unsigned NOT NULL default '0',
`ifOperStatus` int(10) unsigned NOT NULL default '0',
`ifLastChange` int(10) unsigned NOT NULL default '0',
`linkPort` tinyint(3) unsigned NOT NULL default '0',
`vlan_id` int(10) unsigned NOT NULL,
`vlan_name` varchar(128) NOT NULL,
`vlan_trunk` tinyint(3) unsigned NOT NULL,
`vlan_trunk_status` int(10) unsigned NOT NULL,
`ifInOctets` int(10) unsigned NOT NULL default '0',
`ifOutOctets` int(10) unsigned NOT NULL default '0',
`ifHCInOctets` bigint(20) unsigned NOT NULL default '0',
`ifHCOutOctets` bigint(20) unsigned NOT NULL default '0',
`ifInNUcastPkts` int(10) unsigned NOT NULL default '0',
`ifOutNUcastPkts` int(10) unsigned NOT NULL default '0',
`ifInUcastPkts` int(10) unsigned NOT NULL default '0',
`ifOutUcastPkts` int(10) unsigned NOT NULL default '0',
`ifInDiscards` int(10) unsigned NOT NULL default '0',
`ifInErrors` int(10) unsigned NOT NULL default '0',
`ifInUnknownProtos` int(10) unsigned NOT NULL default '0',
`ifOutDiscards` int(10) unsigned default '0',
`ifOutErrors` int(10) unsigned default '0',
`inBound` double NOT NULL default '0',
`outBound` double NOT NULL default '0',
`int_ifInOctets` int(10) unsigned NOT NULL default '0',
`int_ifOutOctets` int(10) unsigned NOT NULL default '0',
`int_ifHCInOctets` bigint(20) unsigned NOT NULL default '0',
`int_ifHCOutOctets` bigint(20) unsigned NOT NULL default '0',
`int_ifInNUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifOutNUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifInUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifOutUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifInDiscards` float unsigned NOT NULL default '0',
`int_ifInErrors` float unsigned NOT NULL default '0',
`int_ifInUnknownProtos` float unsigned NOT NULL default '0',
`int_ifOutDiscards` float unsigned NOT NULL default '0',
`int_ifOutErrors` float unsigned NOT NULL default '0',
`last_up_time` timestamp NOT NULL default '0000-00-00 00:00:00',
`last_down_time` timestamp NOT NULL default '0000-00-00 00:00:00',
`stateChanges` int(10) unsigned NOT NULL default '0',
`int_discards_present` tinyint(3) unsigned NOT NULL default '0',
`int_errors_present` tinyint(3) unsigned NOT NULL default '0',
`present` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`site_id`,`device_id`,`ifIndex`),
KEY `ifDescr` (`ifDescr`),
KEY `ifType` (`ifType`),
KEY `ifSpeed` (`ifSpeed`),
KEY `ifMTU` (`ifMtu`),
KEY `ifAdminStatus` (`ifAdminStatus`),
KEY `ifOperStatus` (`ifOperStatus`),
KEY `ifInDiscards` USING BTREE (`ifInUnknownProtos`),
KEY `ifInErrors` USING BTREE (`ifInUnknownProtos`))
ENGINE=MyISAM;
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Oops. I did not test that. I'll be releasing a 2.5 next week. That'll be fixed in a few minutes though.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
terziyski
Cacti User
Posts: 93
Joined: Thu Nov 02, 2006 6:02 am
Location: Bulgaria
Contact:

Post by terziyski »

I have similar errors in my log after installing 2.4:
This is when I try to enter device.

Code: Select all

04/19/2010 05:21:54 PM - MACTRACK: Poller[0] ERROR: Cacti Device: (0/875): 10.14.2.2, error on save: a:26:{s:9:"device_id";s:1:"0";s:7:"host_id";s:3:"875";s:7:"site_id";s:1:"0";s:8:"hostname";s:9:"10.14.2.2";s:11:"device_name";s:15:"Sofia-DLE65-MSR";s:5:"notes";s:0:"";s:9:"scan_type";s:1:"1";s:12:"snmp_options";s:1:"0";s:15:"snmp_readstring";s:13:"management!@#";s:12:"snmp_version";s:1:"2";s:13:"snmp_username";s:4:"root";s:13:"snmp_password";s:9:"XXkibik00";s:18:"snmp_auth_protocol";s:3:"MD5";s:20:"snmp_priv_passphrase";s:0:"";s:18:"snmp_priv_protocol";s:3:"DES";s:12:"snmp_context";s:0:"";s:9:"snmp_port";s:3:"161";s:12:"snmp_timeout";s:3:"500";s:12:"snmp_retries";s:1:"3";s:8:"max_oids";s:2:"50";s:9:"user_name";s:0:"";s:13:"user_password";s:0:"";s:11:"ignorePorts";s:0:"";s:9:"term_type";s:1:"1";s:16:"private_key_path";s:0:"";s:8:"disabled";s:0:"";}
This is when I browse devices.

Code: Select all

04/19/2010 05:38:19 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_device_types.description as device_type, mac_track_devices.site_id, mac_track_sites.site_name, mac_track_devices.device_id, mac_track_devices.host_id, mac_track_devices.device_name, mac_track_devices.notes, mac_track_devices.hostname, mac_track_devices.snmp_options, mac_track_devices.snmp_readstring, mac_track_devices.snmp_version, mac_track_devices.snmp_username, mac_track_devices.snmp_password, mac_track_devices.snmp_auth_protocol, mac_track_devices.snmp_priv_passphrase, mac_track_devices.snmp_priv_protocol, mac_track_devices.snmp_context, mac_track_devices.snmp_port, mac_track_devices.snmp_timeout, mac_track_devices.snmp_retries, mac_track_devices.max_oids, mac_track_devices.snmp_status, mac_track_devices.ignorePorts, mac_track_devices.disabled, mac_track_devices.scan_type, mac_track_devices.ips_total, mac_track_devices.ports_total, mac_track_devices.ports_active, mac_track_devices.ports_trunk, mac_track_devices.macs_active, mac_track_devices.last_rundate, mac_track_devices.last_runmessage, mac_track_devices.last_runduration FROM mac_track_sites RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id LEFT JOIN mac_track_device_types ON mac_track_devices.device_type_id=mac_track_device_types.device_type_id ORDER BY site_name ASC LIMIT 0,30"
Cacti user
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

v2.5 is in SVN. I will be releasing to the docs site in a bit.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
terziyski
Cacti User
Posts: 93
Joined: Thu Nov 02, 2006 6:02 am
Location: Bulgaria
Contact:

Post by terziyski »

I am writing in this topic, because of the my previous post, but it also relates to "update 1.x to 2.5 problems":
On another machine, which has not mactrack installed, after installing v2.5 and select mactrack tab I received in log:

Code: Select all

04/21/2010 02:38:02 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT COUNT(mac_track_devices.device_id) FROM mac_track_sites RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id LEFT JOIN mac_track_device_types ON (mac_track_device_types.device_type_id=mac_track_devices.device_type_id) WHERE (mac_track_devices.hostname LIKE '%%' OR mac_track_devices.notes LIKE '%%' OR mac_track_devices.device_name LIKE '%%' OR mac_track_sites.site_name LIKE '%%')"
04/21/2010 02:38:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_devices.*, mac_track_device_types.description AS device_type, mac_track_sites.site_name FROM mac_track_sites RIGHT JOIN mac_track_devices ON (mac_track_devices.site_id=mac_track_sites.site_id) LEFT JOIN mac_track_device_types ON (mac_track_device_types.device_type_id=mac_track_devices.device_type_id) WHERE (mac_track_devices.hostname LIKE '%%' OR mac_track_devices.notes LIKE '%%' OR mac_track_devices.device_name LIKE '%%' OR mac_track_sites.site_name LIKE '%%') ORDER BY site_name ASC LIMIT 0,30"
04/21/2010 02:38:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT device_id, device_name, hostname FROM mac_track_devices ORDER BY device_name"
After selecting devices in Console:

Code: Select all

04/21/2010 02:44:32 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_device_types.description as device_type, mac_track_devices.site_id, mac_track_sites.site_name, mac_track_devices.device_id, mac_track_devices.host_id, mac_track_devices.device_name, mac_track_devices.notes, mac_track_devices.hostname, mac_track_devices.snmp_options, mac_track_devices.snmp_readstring, mac_track_devices.snmp_version, mac_track_devices.snmp_username, mac_track_devices.snmp_password, mac_track_devices.snmp_auth_protocol, mac_track_devices.snmp_priv_passphrase, mac_track_devices.snmp_priv_protocol, mac_track_devices.snmp_context, mac_track_devices.snmp_port, mac_track_devices.snmp_timeout, mac_track_devices.snmp_retries, mac_track_devices.max_oids, mac_track_devices.snmp_status, mac_track_devices.ignorePorts, mac_track_devices.disabled, mac_track_devices.scan_type, mac_track_devices.ips_total, mac_track_devices.ports_total, mac_track_devices.ports_active, mac_track_devices.ports_trunk, mac_track_devices.macs_active, mac_track_devices.last_rundate, mac_track_devices.last_runmessage, mac_track_devices.last_runduration FROM mac_track_sites RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id LEFT JOIN mac_track_device_types ON mac_track_devices.device_type_id=mac_track_device_types.device_type_id ORDER BY site_name ASC LIMIT 0,30"
Any suggestions ?
Cacti user
shadowmanr6
Posts: 14
Joined: Fri Apr 16, 2010 11:19 am

Post by shadowmanr6 »

1054 means the table is missing a column, may want to delete the mactrack_interfaces table and recreate with the full 'create table' lines up above, assuming you dont have anything important in it right now.
terziyski
Cacti User
Posts: 93
Joined: Thu Nov 02, 2006 6:02 am
Location: Bulgaria
Contact:

Post by terziyski »

I recreated mac_track_interfaces table as you suggest, but result is the same as before.
1.When I select Devices from Device Tracking section:

Code: Select all

04/23/2010 02:17:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_device_types.description as device_type, mac_track_devices.site_id, mac_track_sites.site_name, mac_track_devices.device_id, mac_track_devices.host_id, mac_track_devices.device_name, mac_track_devices.notes, mac_track_devices.hostname, mac_track_devices.snmp_options, mac_track_devices.snmp_readstring, mac_track_devices.snmp_version, mac_track_devices.snmp_username, mac_track_devices.snmp_password, mac_track_devices.snmp_auth_protocol, mac_track_devices.snmp_priv_passphrase, mac_track_devices.snmp_priv_protocol, mac_track_devices.snmp_context, mac_track_devices.snmp_port, mac_track_devices.snmp_timeout, mac_track_devices.snmp_retries, mac_track_devices.max_oids, mac_track_devices.snmp_status, mac_track_devices.ignorePorts, mac_track_devices.disabled, mac_track_devices.scan_type, mac_track_devices.ips_total, mac_track_devices.ports_total, mac_track_devices.ports_active, mac_track_devices.ports_trunk, mac_track_devices.macs_active, mac_track_devices.last_rundate, mac_track_devices.last_runmessage, mac_track_devices.last_runduration FROM mac_track_sites RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id LEFT JOIN mac_track_device_types ON mac_track_devices.device_type_id=mac_track_device_types.device_type_id ORDER BY site_name ASC LIMIT 0,30"
2.When I select mactrack Tab:

Code: Select all

04/23/2010 02:18:43 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT COUNT(mac_track_devices.device_id) FROM mac_track_sites RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id LEFT JOIN mac_track_device_types ON (mac_track_device_types.device_type_id=mac_track_devices.device_type_id) WHERE (mac_track_devices.hostname LIKE '%%' OR mac_track_devices.notes LIKE '%%' OR mac_track_devices.device_name LIKE '%%' OR mac_track_sites.site_name LIKE '%%')"
04/23/2010 02:18:43 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_devices.*, mac_track_device_types.description AS device_type, mac_track_sites.site_name FROM mac_track_sites RIGHT JOIN mac_track_devices ON (mac_track_devices.site_id=mac_track_sites.site_id) LEFT JOIN mac_track_device_types ON (mac_track_device_types.device_type_id=mac_track_devices.device_type_id) WHERE (mac_track_devices.hostname LIKE '%%' OR mac_track_devices.notes LIKE '%%' OR mac_track_devices.device_name LIKE '%%' OR mac_track_sites.site_name LIKE '%%') ORDER BY site_name ASC LIMIT 0,30"
04/23/2010 02:18:43 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT device_id, device_name, hostname FROM mac_track_devices ORDER BY device_name"
[/code]
Cacti user
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Yes, you database upgrade was not complete. If you were doing point upgrades from 2.x, you may have encountered the problem. If you take the lib/database.php from SVN, you will get more informative errors so you can fix the problem.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
terziyski
Cacti User
Posts: 93
Joined: Thu Nov 02, 2006 6:02 am
Location: Bulgaria
Contact:

Post by terziyski »

I've deleted the folder mactrack and installed plugin from scratch - version 2.5-2.
There is no more errors in log file. Is this all, do I have to make any changes to the database ?
Cacti user
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Well, if there are no more errors ;)

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest