Open victor7costa opened 7 years ago
Hi Victor @victorseth
I tried upgrading to csm 3.4 from your build 01/25/2016, but I couldn't reproduce this error. (01/25/2016 is csm 3.2.1 - you can find that under Releases in github.) When you started the csmserver in csm 3.4, csm tried to create the new table 'host_inventory_history' for you, looks like that's when you got this error.
Did you update the default database.ini in csm 3.4 with your csm db info in your previous build?
Could you get me the following information?
$mysql -u
Hi, Here it is
mysql> select * from system_version;
+----+----------------+------------------+
| id | schema_version | software_version |
+----+----------------+------------------+
| 1 | 4 | 1.0 |
+----+----------------+------------------+
1 row in set (0,00 sec)
mysql> describe host_inventory;
ERROR 1146 (42S02): Table 'csmdb.host_inventory' doesn't exist
mysql> describe host_inventory_history;
ERROR 1146 (42S02): Table 'csmdb.host_inventory_history' doesn't exist
mysql> select * from information_schema.table_constraints where table_schema = schema() and table_name = 'host_inventory';
Empty set (0,00 sec)
mysql> select * from information_schema.table_constraints where table_schema = schema() and table_name = 'host_inventory_history';
Empty set (0,00 sec)
| InnoDB | |
=====================================
2017-10-10 17:27:51 0x7ff157fff700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 40 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 23 srv_active, 0 srv_shutdown, 24962 srv_idle
srv_master_thread log flush and writes: 24985
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 36
OS WAIT ARRAY INFO: signal count 28
RW-shared spins 0, rounds 10, OS waits 5
RW-excl spins 0, rounds 502, OS waits 10
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 10.00 RW-shared, 502.00 RW-excl, 0.00 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2017-10-10 10:50:24 0x7ff19a85b700 Error in foreign key constraint of table csmd b/udi:
FOREIGN KEY(host_id) REFERENCES host (id)
):
Cannot resolve table name close to:
(id)
)
------------
TRANSACTIONS
------------
Trx id counter 32420
Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 422150809070304, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422150809069392, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 0
412 OS file reads, 248 OS file writes, 129 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 34673, node heap has 0 buffer(s)
Hash table size 34673, node heap has 0 buffer(s)
Hash table size 34673, node heap has 0 buffer(s)
Hash table size 34673, node heap has 0 buffer(s)
Hash table size 34673, node heap has 0 buffer(s)
Hash table size 34673, node heap has 1 buffer(s)
Hash table size 34673, node heap has 0 buffer(s)
Hash table size 34673, node heap has 0 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 13120805
Log flushed up to 13120805
Pages flushed up to 13120805
Last checkpoint at 13120796
0 pending log flushes, 0 pending chkp writes
54 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 137428992
Dictionary memory allocated 410467
Buffer pool size 8191
Free buffers 7683
Database pages 507
Old database pages 0
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 380, created 127, written 112
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 507, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=25241, Main thread ID=140675502925568, state: sleeping
Number of rows inserted 6570, updated 0, deleted 0, read 8736
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
Thanks!
Hi Victor @victorseth
Thanks. I see this similar error from trying to create the 'udi' table in your mysql log:
2017-10-10 10:50:24 0x7ff19a85b700 Error in foreign key constraint of table csmdb/udi: FOREIGN KEY(host_id) REFERENCES host (id) ): Cannot resolve table name close to: (id) )
Your db is not able to resolve table name 'host' for creating the foreign key. That's the host table.
If you do
mysql> use csmdb;
mysql> describe host;
mysql> select * from information_schema.table_constraints where table_schema = schema() and table_name = 'host';
mysql> show table status from csmdb
like 'host';
What do you see?
A small experiment: mysql> create table test (id INTEGER NOT NULL AUTO_INCREMENT, host_id INTEGER, PRIMARY KEY (id), FOREIGN KEY(host_id) REFERENCES host (id)); mysql> select * from information_schema.table_constraints where table_schema = schema() and table_name = 'test'; mysql> describe test;
Then: mysql> drop table test;
The quick resolution, if you don't have too many hosts created in your existing database, is to define/create a new database in the database.ini, start csmserver and re-create the hosts in csm 3.4.
Best, Joy
Here are the results:
mysql> describe host;
+-------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| hostname | varchar(50) | NO | MUL | NULL | |
| platform | varchar(20) | NO | | NULL | |
| software_platform | varchar(20) | YES | | NULL | |
| software_version | varchar(20) | YES | | NULL | |
| roles | varchar(100) | YES | | NULL | |
| region_id | int(11) | YES | MUL | NULL | |
| proxy_agent | varchar(30) | YES | | NULL | |
| can_schedule | tinyint(1) | YES | | NULL | |
| can_install | tinyint(1) | YES | | NULL | |
| created_time | datetime | YES | | NULL | |
| created_by | varchar(50) | YES | | NULL | |
+-------------------+--------------+------+-----+---------+----------------+
12 rows in set (0,00 sec)
mysql> select * from information_schema.table_constraints where table_schema = schema() and table_name = 'host';
+--------------------+-------------------+-----------------+--------------+------------+-----------------+
| CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_SCHEMA | TABLE_NAME | CONSTRAINT_TYPE |
+--------------------+-------------------+-----------------+--------------+------------+-----------------+
| def | csmdb | PRIMARY | csmdb | host | PRIMARY KEY |
+--------------------+-------------------+-----------------+--------------+------------+-----------------+
1 row in set (0,01 sec)
mysql> show table status from csmdb like 'host';
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
| host | MyISAM | 10 | Dynamic | 15 | 77 | 1156 | 281474976710655 | 4096 | 0 | 17 | 2017-07-11 18:05:32 | 2017-08-14 16:11:52 | NULL | latin1_swedish_ci | NULL | | |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
1 row in set (0,00 sec)
The test:
mysql> create table test (id INTEGER NOT NULL AUTO_INCREMENT,host_id INTEGER,PRIMARY KEY (id),FOREIGN KEY(host_id) REFERENCES host(id));
ERROR 1215 (HY000): Cannot add foreign key constraint
Hi Victor @victorseth
The database engine for your table(s) somehow is now MyISAM, and MyISAM does not support foreign key. We need InnoDB as the engine. If you were using CSM before, the change of engine type very likely happened when you backed up and restored the database.
Since you have a MyISAM db, that means all the db indexes are already lost, so we won't be able to recover those even if we could convert the engines to InnoDB. You'll need to create a new database in database.ini and start csm 3.4 - define a new db name there. Additionally, make sure your mysql default engine is set to InnoDB.
Check the default storage engine of your mysql: mysql> show engines;
Check the engines of your tables:
mysql> show table status from csmdb
;
Best, Joy
Everything is using InnoDB, it's started, and it's running.
BUT now when I access the HOME:
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/local/lib/python2.7/site-packages/flask_login.py", line 758, in decorated_view
return func(*args, **kwargs)
File "/usr/local/csm/csmserver/csmserver.py", line 3467, in api_get_catalog
if preferences.excluded_platforms_and_releases is not None:
AttributeError: 'NoneType' object has no attribute 'excluded_platforms_and_releases'
[2017-10-11 16:08:47 +0000] [11267] [ERROR] Error handling request
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 129, in handle
self.handle_request(listener, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 170, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1836, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/werkzeug/contrib/fixers.py", line 148, in __call__
return self.app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1820, in wsgi_app
response = self.make_response(self.handle_exception(e))
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1566, in make_response
raise ValueError('View function did not return a response')
ValueError: View function did not return a response
When I try to registrer one of ours hosts and check it reachability:
Unable to reach the specified host via XXX.XXX.XXX.XXX
Or you may not be an authorized user.
I assume you have followed instructions from Joy to create a new db. Please provide us the backup.sql file.
mysqldump csmdb -u root -p > backup.sql <- this assumes your username is 'root' and database is 'csmdb'. If you renamed the database name in database.ini, use that name here.
Regarding the host reachability issue, please schedule a Pre-Upgrade and provide all the session logs (condoor.log, plugin.log, session.log). If you need help, refer to Help - Schedule Installation document. BTW, what is the display information next to Server Version (top-left on the Home page).
When I try to registrer one of ours hosts and check it reachability:
Unable to reach the specified host via XXX.XXX.XXX.XXX
Or you may not be an authorized user.
From: victorseth notifications@github.com<mailto:notifications@github.com> Reply-To: csm-aut/csm reply@reply.github.com<mailto:reply@reply.github.com> Date: Wednesday, October 11, 2017 at 12:12 PM To: csm-aut/csm csm@noreply.github.com<mailto:csm@noreply.github.com> Cc: Subscribed subscribed@noreply.github.com<mailto:subscribed@noreply.github.com> Subject: Re: [csm-aut/csm] Update to v3.4 failed (#100)
Everything is using InnoDB, it's started, and it's running.
BUT now when I access the HOME:
Traceback (most recent call last): File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app response = self.full_dispatch_request() File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request rv = self.handle_user_exception(e) File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception reraise(exc_type, exc_value, tb) File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request rv = self.dispatch_request() File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request return self.view_functionsrule.endpoint File "/usr/local/lib/python2.7/site-packages/flask_login.py", line 758, in decorated_view return func(*args, **kwargs) File "/usr/local/csm/csmserver/csmserver.py", line 3467, in api_get_catalog if preferences.excluded_platforms_and_releases is not None: AttributeError: 'NoneType' object has no attribute 'excluded_platforms_and_releases' [2017-10-11 16:08:47 +0000] [11267] [ERROR] Error handling request Traceback (most recent call last): File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 129, in handle self.handle_request(listener, req, client, addr) File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 170, in handle_request respiter = self.wsgi(environ, resp.start_response) File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1836, in call return self.wsgi_app(environ, start_response) File "/usr/local/lib/python2.7/site-packages/werkzeug/contrib/fixers.py", line 148, in call return self.app(environ, start_response) File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1820, in wsgi_app response = self.make_response(self.handle_exception(e)) File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1566, in make_response raise ValueError('View function did not return a response') ValueError: View function did not return a response
- You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/csm-aut/csm/issues/100#issuecomment-335917184, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKh3SOt80Lx81GpigGz7sEOGfEc4mqEKks5srRMxgaJpZM4Pz_Vp.
Uploaded. Here it is. backup.zip Some sensitive information was removed from the DB prior the backup.
I used 3.3 version from GitHub
Server Time | 10/11/2017 04:52 PM
Server Uptime | 57m 23s
Build Date | 10/25/2016
Login User | xxxxxx
Privilege | Admin
Hi Victor @victorseth
That's the new database you created right? (With information entered from CSM UI?) Like I explained, we can't recover from the MyISAM db.
I used your backup.sql with csm 3.3, I can't reproduce this error locally, and I checked the preferences table, every user_id has a preference. I tried creating a new user and still no error.
Are you using any special flavor of myql? Like MariaDB? What's the version/distribution number?
Best, Joy
We're using:
# mysql --version
mysql Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using EditLine wrapper
Upgraded to 3.5
Still `Unable to reach the specified host via XXX.XXX.XXX.XXX
Or you may not be an authorized user.`
From that machine, I can just telnet and login normally.
Please schedule a Pre-Upgrade on the host and provide us all the logs (session.log, condoor.log, plugin.log).
In addition, make sure you did not define IOS XE enable password for the host.
Alex
From: victorseth notifications@github.com<mailto:notifications@github.com> Reply-To: csm-aut/csm reply@reply.github.com<mailto:reply@reply.github.com> Date: Monday, October 23, 2017 at 11:13 AM To: csm-aut/csm csm@noreply.github.com<mailto:csm@noreply.github.com> Cc: Alex Tang alextang@cisco.com<mailto:alextang@cisco.com>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [csm-aut/csm] Update to v3.4 failed (#100)
Upgraded to 3.5
Still `Unable to reach the specified host via XXX.XXX.XXX.XXX
Or you may not be an authorized user.`
From that machine, I can just telnet and login normally.
- You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/csm-aut/csm/issues/100#issuecomment-338748745, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKh3SLSPsg16ctIHZPAFMK_4kMKfxQXXks5svNdGgaJpZM4Pz_Vp.
The last condoor.log and session.log was from Out 11th 2017. There is no plugin.log.
Probably these are from the old CSMServer (when it was active)
I can't find any log after Oct 11th.
Information: i'm using Python 2.7, so I edited csmserver file to use "python2.7"
Please follow the instructions I gave previously to run a Pre-Upgrade. It should generate some logs when the job fails. This will help us identify the issue whether it is on your side or on ours.
Alex
From: victorseth notifications@github.com<mailto:notifications@github.com> Reply-To: csm-aut/csm reply@reply.github.com<mailto:reply@reply.github.com> Date: Monday, October 23, 2017 at 11:45 AM To: csm-aut/csm csm@noreply.github.com<mailto:csm@noreply.github.com> Cc: Alex Tang alextang@cisco.com<mailto:alextang@cisco.com>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [csm-aut/csm] Update to v3.4 failed (#100)
The last condoor.log and session.log was from 11 Out 2017. There is no plugin.log.
Probably these are from the old CSMServer.
I can't find any log after 11th.
- You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/csm-aut/csm/issues/100#issuecomment-338758325, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKh3SK6gCKFt0HHdqcrLiXYmchEdeJ2Nks5svN7UgaJpZM4Pz_Vp.
The Pre-Upgrade failed with this debug trace:
Trace
Traceback (most recent call last):File "/usr/local/csm/csmserver/work_units/install_work_unit.py", line 95, in starthandler_class = get_install_handler_class(ctx)
File "/usr/local/csm/csmserver/handlers/loader.py", line 74, in get_install_handler_classdiscover_platform_info(ctx)File "/usr/local/csm/csmserver/handlers/loader.py", line 48, in discover_platform_infoconn.connect(force_discovery=True)
TypeError: connect() got an unexpected keyword argument 'force_discovery'
Both condoor and session logs from XXX_XXX_XXX_XXX-2017_10_24_18_30_15 folder are empty. There is no plugin.log inside. XXX_XXX_XXX_XXX-2017_10_24_18_30_15-2 folder is empty.
Looks like you have mismatched CSM components. Were you running an older CSM version before?
I would recommend you upgrade to v3.5 (released a week ago) using the link below so we can start from a better footing.
Please unzip the file and follow the upgrade_guide.pdf under the csm directory. Once you are done, please provide the outputs of the following command
pip freeze
After which, retry Pre-Upgrade again. If the issue persists, provide us all 3 logs.
Alex
From: victorseth notifications@github.com<mailto:notifications@github.com> Reply-To: csm-aut/csm reply@reply.github.com<mailto:reply@reply.github.com> Date: Tuesday, October 24, 2017 at 11:40 AM To: csm-aut/csm csm@noreply.github.com<mailto:csm@noreply.github.com> Cc: Alex Tang alextang@cisco.com<mailto:alextang@cisco.com>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [csm-aut/csm] Update to v3.4 failed (#100)
The Pre-Upgrade failed with this debug trace: Trace
Traceback (most recent call last):File "/usr/local/csm/csmserver/work_units/install_work_unit.py", line 95, in starthandler_class = get_install_handler_class(ctx)File "/usr/local/csm/csmserver/handlers/loader.py", line 74, in get_install_handler_classdiscover_platform_info(ctx)File "/usr/local/csm/csmserver/handlers/loader.py", line 48, in discover_platform_infoconn.connect(force_discovery=True)TypeError: connect() got an unexpected keyword argument 'force_discovery'
Both condoor and session logs from XXX_XXX_XXX_XXX-2017_10_24_18_30_15 folder are empty. XXX_XXX_XXX_XXX-2017_10_24_18_30_15-2 folder is empty.
- You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/csm-aut/csm/issues/100#issuecomment-339090313, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKh3SHRSj9qg4qqwWDGqYgogPj5HzJUlks5svi8VgaJpZM4Pz_Vp.
Server Time | 10/24/201704:49 PM |
---|---|
Server Uptime | 1d 1h 35m |
Server Version | 3.5 10.16.2017 |
I'm using 3.5. I just upgraded yesterday to 3.5
Did you install components as described in the upgrade_guide.pdf?
Please provide outputs using 'pip freeze'.
Alex
From: victorseth notifications@github.com<mailto:notifications@github.com> Reply-To: csm-aut/csm reply@reply.github.com<mailto:reply@reply.github.com> Date: Tuesday, October 24, 2017 at 11:49 AM To: csm-aut/csm csm@noreply.github.com<mailto:csm@noreply.github.com> Cc: Alex Tang alextang@cisco.com<mailto:alextang@cisco.com>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [csm-aut/csm] Update to v3.4 failed (#100)
Server Time 10/24/201704:49 PM Server Uptime 1d 1h 35m Server Version 3.5 10.16.2017
I'm using 3.5
- You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/csm-aut/csm/issues/100#issuecomment-339093077, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKh3SKTS2I_LHAVCGNkM4pcLlCF21E-Gks5svjFAgaJpZM4Pz_Vp.
condoor==0.0.8 ecdsa==0.13 enum34==1.1.6 Flask==0.10.1 Flask-HTTPAuth==2.5.0 Flask-Login==0.2.11 gunicorn==19.2.1 idna==2.1 importlib==1.0.3 ipaddress==1.0.16 itsdangerous==0.24 Jinja2==2.7.3 MarkupSafe==0.23 ordereddict==1.1 paramiko==1.15.1 pexpect==4.0.1 ptyprocess==0.5.1 pyasn1==0.1.9 pycparser==2.14 pycrypto==2.6.1 PyMySQL==0.6.3 pysftp==0.2.8 PyYAML==3.12 requests==2.5.1 six==1.10.0 SQLAlchemy==0.9.8 Werkzeug==0.10.1 WTForms==2.0.2 xlrd==0.9.4 xlutils==1.7.1 xlwt==1.0.0
You are running very old components. Have you followed the upgrade_guide to install components? Please answer the question I posted as it will help troubleshoot.
Please execute the two commands and capture all the outputs. After that, provide the output for 'pip freeze' again.
pip install csmpe==1.0.8 pip install scp==0.10.2
From: victorseth notifications@github.com<mailto:notifications@github.com> Reply-To: csm-aut/csm reply@reply.github.com<mailto:reply@reply.github.com> Date: Tuesday, October 24, 2017 at 11:58 AM To: csm-aut/csm csm@noreply.github.com<mailto:csm@noreply.github.com> Cc: Alex Tang alextang@cisco.com<mailto:alextang@cisco.com>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [csm-aut/csm] Update to v3.4 failed (#100)
condoor==0.0.8 ecdsa==0.13 enum34==1.1.6 Flask==0.10.1 Flask-HTTPAuth==2.5.0 Flask-Login==0.2.11 gunicorn==19.2.1 idna==2.1 importlib==1.0.3 ipaddress==1.0.16 itsdangerous==0.24 Jinja2==2.7.3 MarkupSafe==0.23 ordereddict==1.1 paramiko==1.15.1 pexpect==4.0.1 ptyprocess==0.5.1 pyasn1==0.1.9 pycparser==2.14 pycrypto==2.6.1 PyMySQL==0.6.3 pysftp==0.2.8 PyYAML==3.12 requests==2.5.1 six==1.10.0 SQLAlchemy==0.9.8 Werkzeug==0.10.1 WTForms==2.0.2 xlrd==0.9.4 xlutils==1.7.1 xlwt==1.0.0
- You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/csm-aut/csm/issues/100#issuecomment-339095536, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKh3SKLEsDgOPijK3_g26Fjp0t4lDZL_ks5svjM6gaJpZM4Pz_Vp.
I folllowed the guide I downloaded from 3.4. upgrade_guide.pdf
but pip itself was old. I upgraded it and executed this two commands. They're updated now.
csmpe:
Collecting csmpe==1.0.8
/usr/local/lib/python2.7/site-packages/pip/_vendor/requests/packages/urllib3/uti l/ssl_.py:318: SNIMissingWarning: An HTTPS request has been made, but the SNI (S ubject Name Indication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can cause v alidation failures. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.io/en/latest/security.html #snimissingwarning.
SNIMissingWarning
/usr/local/lib/python2.7/site-packages/pip/_vendor/requests/packages/urllib3/uti l/ssl_.py:122: InsecurePlatformWarning: A true SSLContext object is not availabl e. This prevents urllib3 from configuring SSL appropriately and may cause certai n SSL connections to fail. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.io/en/latest/securi ty.html#insecureplatformwarning.
InsecurePlatformWarning
Downloading csmpe-1.0.8.tar.gz (85kB)
100% |████████████████████████████████| 92kB 3.2MB/s
Collecting stevedore (from csmpe==1.0.8)
Downloading stevedore-1.27.1-py2.py3-none-any.whl
Collecting pkginfo==1.4.1 (from csmpe==1.0.8)
Downloading pkginfo-1.4.1-py2.py3-none-any.whl
Collecting click (from csmpe==1.0.8)
Downloading click-6.7-py2.py3-none-any.whl (71kB)
100% |████████████████████████████████| 71kB 4.6MB/s
Collecting condoor>=1.0.9 (from csmpe==1.0.8)
Downloading condoor-1.0.9.tar.gz (46kB)
100% |████████████████████████████████| 51kB 5.3MB/s
Collecting pbr!=2.1.0,>=2.0.0 (from stevedore->csmpe==1.0.8)
Downloading pbr-3.1.1-py2.py3-none-any.whl (99kB)
100% |████████████████████████████████| 102kB 5.0MB/s
Requirement already satisfied: six>=1.9.0 in /usr/local/lib/python2.7/site-packages (from stevedore->csmpe==1.0.8)
Collecting pexpect>=4.2.1 (from condoor>=1.0.9->csmpe==1.0.8)
Downloading pexpect-4.2.1-py2.py3-none-any.whl (55kB)
100% |████████████████████████████████| 61kB 5.0MB/s
Requirement already satisfied: pyyaml in /usr/local/lib/python2.7/site-packages (from condoor>=1.0.9->csmpe==1.0.8)
Requirement already satisfied: ptyprocess>=0.5 in /usr/local/lib/python2.7/site-packages (from pexpect>=4.2.1->condoor>=1.0.9->csmpe==1.0.8)
Installing collected packages: pbr, stevedore, pkginfo, click, pexpect, condoor, csmpe
Found existing installation: pexpect 4.0.1
Uninstalling pexpect-4.0.1:
Successfully uninstalled pexpect-4.0.1
Found existing installation: condoor 0.0.8
Uninstalling condoor-0.0.8:
Successfully uninstalled condoor-0.0.8
Running setup.py install for condoor ... done
Running setup.py install for csmpe ... done
Successfully installed click-6.7 condoor-1.0.9 csmpe-1.0.8 pbr-3.1.1 pexpect-4.2.1 pkginfo-1.4.1 stevedore-1.27.1
scp:
/usr/local/lib/python2.7/site-packages/pip/_vendor/requests/packages/urllib3/uti l/ssl_.py:318: SNIMissingWarning: An HTTPS request has been made, but the SNI (S ubject Name Indication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can cause v alidation failures. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.io/en/latest/security.html #snimissingwarning.
SNIMissingWarning
/usr/local/lib/python2.7/site-packages/pip/_vendor/requests/packages/urllib3/uti l/ssl_.py:122: InsecurePlatformWarning: A true SSLContext object is not availabl e. This prevents urllib3 from configuring SSL appropriately and may cause certai n SSL connections to fail. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.io/en/latest/securi ty.html#insecureplatformwarning.
InsecurePlatformWarning
Downloading scp-0.10.2-py2.py3-none-any.whl
Requirement already satisfied: paramiko in /usr/local/lib/python2.7/site-package s (from scp==0.10.2)
Requirement already satisfied: pycrypto!=2.4,>=2.1 in /usr/local/lib/python2.7/s ite-packages (from paramiko->scp==0.10.2)
Requirement already satisfied: ecdsa>=0.11 in /usr/local/lib/python2.7/site-pack ages (from paramiko->scp==0.10.2)
Installing collected packages: scp
Successfully installed scp-0.10.2
pip freeze:
click==6.7
condoor==1.0.9
csmpe==1.0.8
ecdsa==0.13
enum34==1.1.6
Flask==0.10.1
Flask-HTTPAuth==2.5.0
Flask-Login==0.2.11
gunicorn==19.2.1
idna==2.1
importlib==1.0.3
ipaddress==1.0.16
itsdangerous==0.24
Jinja2==2.7.3
MarkupSafe==0.23
ordereddict==1.1
paramiko==1.15.1
pbr==3.1.1
pexpect==4.2.1
pkginfo==1.4.1
ptyprocess==0.5.1
pyasn1==0.1.9
pycparser==2.14
pycrypto==2.6.1
PyMySQL==0.6.3
pysftp==0.2.8
PyYAML==3.12
requests==2.5.1
scp==0.10.2
six==1.10.0
SQLAlchemy==0.9.8
stevedore==1.27.1
Werkzeug==0.10.1
WTForms==2.0.2
xlrd==0.9.4
xlutils==1.7.1
xlwt==1.0.0
To upgrade to v3.5, you need to use the upgrade guide for the release.
Please run Pre-Upgrade again and provide logs if you see issue.
From: victorseth notifications@github.com<mailto:notifications@github.com> Reply-To: csm-aut/csm reply@reply.github.com<mailto:reply@reply.github.com> Date: Tuesday, October 24, 2017 at 12:17 PM To: csm-aut/csm csm@noreply.github.com<mailto:csm@noreply.github.com> Cc: Alex Tang alextang@cisco.com<mailto:alextang@cisco.com>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [csm-aut/csm] Update to v3.4 failed (#100)
I folllowed the guide I downloaded from 3.4. upgrade_guide.pdfhttps://github.com/csm-aut/csm/files/1412181/upgrade_guide.pdf
but pip itself was old. I upgraded it and executed this two commands. They're updated now.
csmpe Collecting csmpe==1.0.8 /usr/local/lib/python2.7/site-packages/pip/vendor/requests/packages/urllib3/uti l/ssl.py:318: SNIMissingWarning: An HTTPS request has been made, but the SNI (S ubject Name Indication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can cause v alidation failures. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.io/en/latest/security.html #snimissingwarning. SNIMissingWarning /usr/local/lib/python2.7/site-packages/pip/vendor/requests/packages/urllib3/uti l/ssl.py:122: InsecurePlatformWarning: A true SSLContext object is not availabl e. This prevents urllib3 from configuring SSL appropriately and may cause certai n SSL connections to fail. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.io/en/latest/securi ty.html#insecureplatformwarning. InsecurePlatformWarning Downloading csmpe-1.0.8.tar.gz (85kB) 100% |████████████████████████████████| 92kB 3.2MB/s Collecting stevedore (from csmpe==1.0.8) Downloading stevedore-1.27.1-py2.py3-none-any.whl Collecting pkginfo==1.4.1 (from csmpe==1.0.8) Downloading pkginfo-1.4.1-py2.py3-none-any.whl Collecting click (from csmpe==1.0.8) Downloading click-6.7-py2.py3-none-any.whl (71kB) 100% |████████████████████████████████| 71kB 4.6MB/s Collecting condoor>=1.0.9 (from csmpe==1.0.8) Downloading condoor-1.0.9.tar.gz (46kB) 100% |████████████████████████████████| 51kB 5.3MB/s Collecting pbr!=2.1.0,>=2.0.0 (from stevedore->csmpe==1.0.8) Downloading pbr-3.1.1-py2.py3-none-any.whl (99kB) 100% |████████████████████████████████| 102kB 5.0MB/s Requirement already satisfied: six>=1.9.0 in /usr/local/lib/python2.7/site-packages (from stevedore->csmpe==1.0.8) Collecting pexpect>=4.2.1 (from condoor>=1.0.9->csmpe==1.0.8) Downloading pexpect-4.2.1-py2.py3-none-any.whl (55kB) 100% |████████████████████████████████| 61kB 5.0MB/s Requirement already satisfied: pyyaml in /usr/local/lib/python2.7/site-packages (from condoor>=1.0.9->csmpe==1.0.8) Requirement already satisfied: ptyprocess>=0.5 in /usr/local/lib/python2.7/site-packages (from pexpect>=4.2.1->condoor>=1.0.9->csmpe==1.0.8) Installing collected packages: pbr, stevedore, pkginfo, click, pexpect, condoor, csmpe Found existing installation: pexpect 4.0.1 Uninstalling pexpect-4.0.1: Successfully uninstalled pexpect-4.0.1 Found existing installation: condoor 0.0.8 Uninstalling condoor-0.0.8: Successfully uninstalled condoor-0.0.8 Running setup.py install for condoor ... done Running setup.py install for csmpe ... done Successfully installed click-6.7 condoor-1.0.9 csmpe-1.0.8 pbr-3.1.1 pexpect-4.2.1 pkginfo-1.4.1 stevedore-1.27.1
scp: Collecting scp==0.10.2 /usr/local/lib/python2.7/site-packages/pip/vendor/requests/packages/urllib3/uti l/ssl.py:318: SNIMissingWarning: An HTTPS request has been made, but the SNI (S ubject Name Indication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can cause v alidation failures. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.io/en/latest/security.html #snimissingwarning. SNIMissingWarning /usr/local/lib/python2.7/site-packages/pip/vendor/requests/packages/urllib3/uti l/ssl.py:122: InsecurePlatformWarning: A true SSLContext object is not availabl e. This prevents urllib3 from configuring SSL appropriately and may cause certai n SSL connections to fail. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.io/en/latest/securi ty.html#insecureplatformwarning. InsecurePlatformWarning Downloading scp-0.10.2-py2.py3-none-any.whl Requirement already satisfied: paramiko in /usr/local/lib/python2.7/site-package s (from scp==0.10.2) Requirement already satisfied: pycrypto!=2.4,>=2.1 in /usr/local/lib/python2.7/s ite-packages (from paramiko->scp==0.10.2) Requirement already satisfied: ecdsa>=0.11 in /usr/local/lib/python2.7/site-pack ages (from paramiko->scp==0.10.2) Installing collected packages: scp Successfully installed scp-0.10.2
pip freeze: click==6.7 condoor==1.0.9 csmpe==1.0.8 ecdsa==0.13 enum34==1.1.6 Flask==0.10.1 Flask-HTTPAuth==2.5.0 Flask-Login==0.2.11 gunicorn==19.2.1 idna==2.1 importlib==1.0.3 ipaddress==1.0.16 itsdangerous==0.24 Jinja2==2.7.3 MarkupSafe==0.23 ordereddict==1.1 paramiko==1.15.1 pbr==3.1.1 pexpect==4.2.1 pkginfo==1.4.1 ptyprocess==0.5.1 pyasn1==0.1.9 pycparser==2.14 pycrypto==2.6.1 PyMySQL==0.6.3 pysftp==0.2.8 PyYAML==3.12 requests==2.5.1 scp==0.10.2 six==1.10.0 SQLAlchemy==0.9.8 stevedore==1.27.1 Werkzeug==0.10.1 WTForms==2.0.2 xlrd==0.9.4 xlutils==1.7.1 xlwt==1.0.0
— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/csm-aut/csm/issues/100#issuecomment-339101209, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKh3SL6UjZSf6GCEGxIG3DDuaMRF0K2lks5svjfTgaJpZM4Pz_Vp.
Folder XXX_XXX_XXX-XXX-2017_10_24_19_25_00 total 0 -rw-r--r-- 1 root root 0 Out 24 17:25 condoor.log -rw-r--r-- 1 root root 0 Out 24 17:25 session.log
Both are empty.
Pre-Upgrade failed, with:
Traceback (most recent call last):
File "/usr/local/csm/csmserver/work_units/install_work_unit.py", line 95, in start
handler_class = get_install_handler_class(ctx)
File "/usr/local/csm/csmserver/handlers/loader.py", line 74, in get_install_handler_class
discover_platform_info(ctx)
File "/usr/local/csm/csmserver/handlers/loader.py", line 48, in discover_platform_info
conn.connect(force_discovery=True)
TypeError: connect() got an unexpected keyword argument 'force_discovery'
Did you restart CSM Server? It is still calling the old condoor component.
If it still does not work. Please capture the files under /usr/local/lib/python2.7/site-packages by executing 'ls'
Then, go to this directory and delete anything resembles condoor (directory or file).
/usr/local/lib/python2.7/site-packages
The, re-install condoor by typing the command below
pip install condoor==1.0.9
And try again. Make sure you stop and restart csm server.
From: victorseth notifications@github.com<mailto:notifications@github.com> Reply-To: csm-aut/csm reply@reply.github.com<mailto:reply@reply.github.com> Date: Tuesday, October 24, 2017 at 12:31 PM To: csm-aut/csm csm@noreply.github.com<mailto:csm@noreply.github.com> Cc: Alex Tang alextang@cisco.com<mailto:alextang@cisco.com>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [csm-aut/csm] Update to v3.4 failed (#100)
Folder XXX_XXX_XXX-XXX-2017_10_24_19_25_00 total 0 -rw-r--r-- 1 root root 0 Out 24 17:25 condoor.log -rw-r--r-- 1 root root 0 Out 24 17:25 session.log
Both are empty.
Pre-Upgrade failed, with:
Traceback (most recent call last): File "/usr/local/csm/csmserver/work_units/install_work_unit.py", line 95, in start handler_class = get_install_handler_class(ctx) File "/usr/local/csm/csmserver/handlers/loader.py", line 74, in get_install_handler_class discover_platform_info(ctx) File "/usr/local/csm/csmserver/handlers/loader.py", line 48, in discover_platform_info conn.connect(force_discovery=True) TypeError: connect() got an unexpected keyword argument 'force_discovery'
- You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/csm-aut/csm/issues/100#issuecomment-339104966, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKh3SBx5TNXClzaHaR7w0OFeQwcK_eYsks5svjr4gaJpZM4Pz_Vp.
Ok, now it changed:
Traceback (most recent call last):
File "/usr/local/csm/csmserver/work_units/install_work_unit.py", line 95, in start
handler_class = get_install_handler_class(ctx)
File "/usr/local/csm/csmserver/handlers/loader.py", line 74, in get_install_handler_class
discover_platform_info(ctx)
File "/usr/local/csm/csmserver/handlers/loader.py", line 48, in discover_platform_info
conn.connect(force_discovery=True)
File "/usr/local/lib/python2.7/site-packages/condoor/connection.py", line 253, in connect
retry=False)
File "/usr/local/lib/python2.7/site-packages/condoor/connection.py", line 361, in reconnect
raise excpt
ConnectionAuthenticationError: 192.168.121.225:23: Authentication failed
condor.log:
2017-10-24 17:42:50,603 condoor.connection:reconnect(291): --------------------
2017-10-24 17:42:50,604 condoor.connection:reconnect(292): Condoor Version 1.0.9
2017-10-24 17:42:50,604 condoor.connection:reconnect(293): Cache filename: /tmp/condoor.1.0.9.shelve
2017-10-24 17:42:50,606 condoor.device:driver_name(308): Driver generic
2017-10-24 17:42:50,606 condoor.connection:reconnect(296): Connecting
2017-10-24 17:42:50,606 condoor.connection:_clear_cache(221): Clearing connection cache
2017-10-24 17:42:50,606 condoor.connection:_get_key(188): Cache key: [telnet://olduser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:42:50,642 condoor.connection:_cache_open(195): Unable to open a cache file for read.
2017-10-24 17:42:50,642 condoor.connection:description_record(834): Connection information cleared
2017-10-24 17:42:50,642 condoor.connection:_clear_cache(224): Description record: {'connections': [{'chain': [{'platform': None, 'driver_name': 'generic', 'is_console': None, 'mode': None, 'family': None, 'os_version': None, 'os_type': None, 'udi': None, 'hostname': 'XXX.XXX.XXX.XXX:23', 'is_target': True}]}], 'last_chain': 0}
2017-10-24 17:42:50,642 condoor.connection:_get_key(188): Cache key: [telnet://olduser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:42:50,643 condoor.connection:_write_cache(205): Connection information cached: c6e0d5abd1bc093b1d07a18df2010c94
2017-10-24 17:42:50,643 condoor.connection:emit_message(582): Connection chain 1/1: telnet://olduser@XXX.XXX.XXX.XXX:23
2017-10-24 17:42:50,643 condoor.connection:emit_message(582): Trying to (re)connect within 120 seconds
2017-10-24 17:42:50,643 condoor.connection:emit_message(582): Connection chain/attempt [1/1]
2017-10-24 17:42:50,643 condoor.connection:emit_message(582): Connecting telnet://olduser@XXX.XXX.XXX.XXX:23
2017-10-24 17:42:50,643 condoor.controller:spawn_session(49): Spawning command: 'telnet XXX.XXX.XXX.XXX 23'
2017-10-24 17:42:50,658 condoor.controller:spawn_session(59): Child process FD: 11
2017-10-24 17:42:50,658 condoor.controller:spawn_session(65): Terminal window size changed from 24x80 to 512x160
2017-10-24 17:42:50,658 condoor.controller:set_session_log(79): Setting the session log
2017-10-24 17:42:50,658 protocols.telnet:connect(66): EXPECTED_PROMPT='(?P<hostname>.*?(?<!\\(standby\\)))(?<!unknown)[#>\\$]'
2017-10-24 17:42:50,658 condoor.fsm:run(162): TELNET-CONNECT Start
2017-10-24 17:42:50,661 condoor.fsm:run(186): E=0,S=0,T=180,RT=0.00
2017-10-24 17:42:50,661 condoor.fsm:run(195): A=None
2017-10-24 17:42:50,661 condoor.fsm:run(203): NS=1,NT=20
2017-10-24 17:42:51,370 condoor.fsm:run(186): E=3,S=1,T=20,RT=0.71
2017-10-24 17:42:51,370 condoor.fsm:call_action(31): A=Save last pattern in the context.
2017-10-24 17:42:51,370 condoor.fsm:run(203): NS=-1,NT=20
2017-10-24 17:42:51,370 condoor.fsm:run(213): TELNET-CONNECT Stop at E=3,S=-1
2017-10-24 17:42:51,370 protocols.telnet:authenticate(94): EXPECTED_PROMPT='(?P<hostname>.*?(?<!\\(standby\\)))(?<!unknown)[#>\\$]'
2017-10-24 17:42:51,370 condoor.fsm:run(162): TELNET-AUTH Start
2017-10-24 17:42:51,370 condoor.fsm:run(170): INIT_PATTERN='[U|u]sername:\\s|login:\\s?|BRIDGETON NOC:\\s?'
2017-10-24 17:42:51,371 condoor.fsm:run(186): E=0,S=0,T=180,RT=0.00
2017-10-24 17:42:51,371 condoor.fsm:call_action(31): A=Sent the username text.
2017-10-24 17:42:51,671 condoor.fsm:run(203): NS=1,NT=10
2017-10-24 17:42:51,760 condoor.fsm:run(186): E=1,S=1,T=10,RT=0.09
2017-10-24 17:42:51,760 condoor.fsm:call_action(31): A=Send the password text.
2017-10-24 17:42:51,760 condoor.controller:send_command(88): Waiting for ECHO OFF
2017-10-24 17:42:51,760 condoor.controller:send_command(90): Password ECHO OFF received
2017-10-24 17:42:52,060 condoor.fsm:run(203): NS=2,NT=20
2017-10-24 17:42:52,702 condoor.fsm:run(186): E=0,S=2,T=20,RT=0.64
2017-10-24 17:42:52,702 condoor.fsm:call_action(31): A=Raise ConnectionAuthenticationError exception and disconnect.
2017-10-24 17:42:52,702 condoor.controller:disconnect(105): Disconnecting the sessions
2017-10-24 17:42:52,802 condoor.controller:disconnect(108): Disconnected
2017-10-24 17:42:52,803 condoor.connection:emit_message(582): Connection error: XXX.XXX.XXX.XXX:23: Authentication failed
2017-10-24 17:42:52,803 condoor.connection:emit_message(582): Time elapsed 2s/120s
2017-10-24 17:42:52,803 condoor.connection:emit_message(582): Unable to (re)connect within 2s
2017-10-24 17:42:52,803 condoor.connection:_clear_cache(221): Clearing connection cache
2017-10-24 17:42:52,803 condoor.connection:_get_key(188): Cache key: [telnet://olduser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:42:52,803 condoor.device:device_info(85): Update: [telnet://olduser@XXX.XXX.XXX.XXX:23] is_target<-True
2017-10-24 17:42:52,804 condoor.device:device_info(85): Update: [telnet://olduser@XXX.XXX.XXX.XXX:23] family<-None
2017-10-24 17:42:52,804 condoor.device:device_info(85): Update: [telnet://olduser@XXX.XXX.XXX.XXX:23] os_version<-None
2017-10-24 17:42:52,804 condoor.device:device_info(85): Update: [telnet://olduser@XXX.XXX.XXX.XXX:23] hostname<-XXX.XXX.XXX.XXX:23
2017-10-24 17:42:52,804 condoor.device:device_info(85): Update: [telnet://olduser@XXX.XXX.XXX.XXX:23] platform<-None
2017-10-24 17:42:52,804 condoor.device:device_info(85): Update: [telnet://olduser@XXX.XXX.XXX.XXX:23] driver_name<-generic
2017-10-24 17:42:52,804 condoor.device:driver_name(308): Driver generic
2017-10-24 17:42:52,804 condoor.device:device_info(85): Update: [telnet://olduser@XXX.XXX.XXX.XXX:23] is_console<-None
2017-10-24 17:42:52,804 condoor.device:device_info(85): Update: [telnet://olduser@XXX.XXX.XXX.XXX:23] mode<-None
2017-10-24 17:42:52,804 condoor.device:device_info(85): Update: [telnet://olduser@XXX.XXX.XXX.XXX:23] os_type<-None
2017-10-24 17:42:52,804 condoor.device:device_info(85): Update: [telnet://olduser@XXX.XXX.XXX.XXX:23] udi<-None
2017-10-24 17:42:52,804 condoor.chain:update(148): Device information updated -> [telnet://olduser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:42:52,804 condoor.connection:description_record(844): Connection information updated from cache.
2017-10-24 17:42:52,804 condoor.connection:_read_cache(213): Read cached information.
2017-10-24 17:42:52,804 condoor.connection:description_record(834): Connection information cleared
2017-10-24 17:42:52,805 condoor.connection:_clear_cache(224): Description record: {'connections': [{'chain': [{'platform': None, 'driver_name': 'generic', 'is_console': None, 'mode': None, 'family': None, 'os_version': None, 'os_type': None, 'udi': None, 'hostname': 'XXX.XXX.XXX.XXX:23', 'is_target': True}]}], 'last_chain': 0}
2017-10-24 17:42:52,805 condoor.connection:_get_key(188): Cache key: [telnet://olduser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:42:52,805 condoor.connection:_write_cache(205): Connection information cached: c6e0d5abd1bc093b1d07a18df2010c94
2017-10-24 17:42:52,805 condoor.connection:_disable_logging(168): Closing logs
session.log
Trying XXX.XXX.XXX.XXX...
Connected to XXX.XXX.XXX.XXX
Escape character is '^]'.
User Access Verification
Username: olduser
Password:
User Access Verification
Username:
olduser it's a old username. I already changed. Still giving the same error.
session.log(After correction)
User Access Verification
Username: newuser
Password:
User Access Verification
Username:
condoor.log (After correction):
2017-10-24 17:59:12,042 condoor.connection:reconnect(291): --------------------
2017-10-24 17:59:12,042 condoor.connection:reconnect(292): Condoor Version 1.0.9
2017-10-24 17:59:12,042 condoor.connection:reconnect(293): Cache filename: /tmp/condoor.1.0.9.shelve
2017-10-24 17:59:12,044 condoor.device:driver_name(308): Driver generic
2017-10-24 17:59:12,044 condoor.connection:reconnect(296): Connecting
2017-10-24 17:59:12,044 condoor.connection:_clear_cache(221): Clearing connection cache
2017-10-24 17:59:12,045 condoor.connection:_get_key(188): Cache key: [telnet://newuser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] is_target<-True
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] family<-None
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] os_version<-None
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] hostname<-XXX.XXX.XXX.XXX:23
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] platform<-None
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] driver_name<-generic
2017-10-24 17:59:12,048 condoor.device:driver_name(308): Driver generic
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] is_console<-None
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] mode<-None
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] os_type<-None
2017-10-24 17:59:12,049 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] udi<-None
2017-10-24 17:59:12,049 condoor.chain:update(148): Device information updated -> [telnet://newuser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:59:12,049 condoor.connection:description_record(844): Connection information updated from cache.
2017-10-24 17:59:12,049 condoor.connection:_read_cache(213): Read cached information.
2017-10-24 17:59:12,049 condoor.connection:description_record(834): Connection information cleared
2017-10-24 17:59:12,049 condoor.connection:_clear_cache(224): Description record: {'connections': [{'chain': [{'platform': None, 'driver_name': 'generic', 'is_console': None, 'mode': None, 'family': None, 'os_version': None, 'os_type': None, 'udi': None, 'hostname': 'XXX.XXX.XXX.XXX:23', 'is_target': True}]}], 'last_chain': 0}
2017-10-24 17:59:12,049 condoor.connection:_get_key(188): Cache key: [telnet://newuser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:59:12,050 condoor.connection:_write_cache(205): Connection information cached: 27b51cce1d7603bfbea511b6b2bb7633
2017-10-24 17:59:12,050 condoor.connection:emit_message(582): Connection chain 1/1: telnet://newuser@XXX.XXX.XXX.XXX:23
2017-10-24 17:59:12,050 condoor.connection:emit_message(582): Trying to (re)connect within 120 seconds
2017-10-24 17:59:12,050 condoor.connection:emit_message(582): Connection chain/attempt [1/1]
2017-10-24 17:59:12,050 condoor.connection:emit_message(582): Connecting telnet://newuser@XXX.XXX.XXX.XXX:23
2017-10-24 17:59:12,051 condoor.controller:spawn_session(49): Spawning command: 'telnet XXX.XXX.XXX.XXX 23'
2017-10-24 17:59:12,058 condoor.controller:spawn_session(59): Child process FD: 11
2017-10-24 17:59:12,058 condoor.controller:spawn_session(65): Terminal window size changed from 24x80 to 512x160
2017-10-24 17:59:12,058 condoor.controller:set_session_log(79): Setting the session log
2017-10-24 17:59:12,059 protocols.telnet:connect(66): EXPECTED_PROMPT='(?P<hostname>.*?(?<!\\(standby\\)))(?<!unknown)[#>\\$]'
2017-10-24 17:59:12,059 condoor.fsm:run(162): TELNET-CONNECT Start
2017-10-24 17:59:12,061 condoor.fsm:run(186): E=0,S=0,T=180,RT=0.00
2017-10-24 17:59:12,061 condoor.fsm:run(195): A=None
2017-10-24 17:59:12,061 condoor.fsm:run(203): NS=1,NT=20
2017-10-24 17:59:12,716 condoor.fsm:run(186): E=3,S=1,T=20,RT=0.65
2017-10-24 17:59:12,716 condoor.fsm:call_action(31): A=Save last pattern in the context.
2017-10-24 17:59:12,716 condoor.fsm:run(203): NS=-1,NT=20
2017-10-24 17:59:12,716 condoor.fsm:run(213): TELNET-CONNECT Stop at E=3,S=-1
2017-10-24 17:59:12,716 protocols.telnet:authenticate(94): EXPECTED_PROMPT='(?P<hostname>.*?(?<!\\(standby\\)))(?<!unknown)[#>\\$]'
2017-10-24 17:59:12,716 condoor.fsm:run(162): TELNET-AUTH Start
2017-10-24 17:59:12,716 condoor.fsm:run(170): INIT_PATTERN='[U|u]sername:\\s|login:\\s?|BRIDGETON NOC:\\s?'
2017-10-24 17:59:12,716 condoor.fsm:run(186): E=0,S=0,T=180,RT=0.00
2017-10-24 17:59:12,717 condoor.fsm:call_action(31): A=Sent the username text.
2017-10-24 17:59:13,017 condoor.fsm:run(203): NS=1,NT=10
2017-10-24 17:59:13,107 condoor.fsm:run(186): E=1,S=1,T=10,RT=0.09
2017-10-24 17:59:13,107 condoor.fsm:call_action(31): A=Send the password text.
2017-10-24 17:59:13,107 condoor.controller:send_command(88): Waiting for ECHO OFF
2017-10-24 17:59:13,107 condoor.controller:send_command(90): Password ECHO OFF received
2017-10-24 17:59:13,407 condoor.fsm:run(203): NS=2,NT=20
2017-10-24 17:59:13,531 condoor.fsm:run(186): E=5,S=2,T=20,RT=0.12
2017-10-24 17:59:13,531 condoor.fsm:call_action(31): A=Raise ConnectionAuthenticationError exception and disconnect.
2017-10-24 17:59:13,531 condoor.controller:disconnect(105): Disconnecting the sessions
2017-10-24 17:59:13,632 condoor.controller:disconnect(108): Disconnected
2017-10-24 17:59:13,632 condoor.connection:emit_message(582): Connection error: XXX.XXX.XXX.XXX:23: Authentication failed
2017-10-24 17:59:13,632 condoor.connection:emit_message(582): Time elapsed 2s/120s
2017-10-24 17:59:13,632 condoor.connection:emit_message(582): Unable to (re)connect within 2s
2017-10-24 17:59:13,632 condoor.connection:_clear_cache(221): Clearing connection cache
2017-10-24 17:59:13,632 condoor.connection:_get_key(188): Cache key: [telnet://newuser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:59:13,633 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] is_target<-True
2017-10-24 17:59:13,633 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] family<-None
2017-10-24 17:59:13,633 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] os_version<-None
2017-10-24 17:59:13,633 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] hostname<-XXX.XXX.XXX.XXX:23
2017-10-24 17:59:13,633 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] platform<-None
2017-10-24 17:59:13,633 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] driver_name<-generic
2017-10-24 17:59:13,633 condoor.device:driver_name(308): Driver generic
2017-10-24 17:59:13,633 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] is_console<-None
2017-10-24 17:59:13,633 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] mode<-None
2017-10-24 17:59:13,633 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] os_type<-None
2017-10-24 17:59:13,633 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] udi<-None
2017-10-24 17:59:13,633 condoor.chain:update(148): Device information updated -> [telnet://newuser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:59:13,633 condoor.connection:description_record(844): Connection information updated from cache.
2017-10-24 17:59:13,633 condoor.connection:_read_cache(213): Read cached information.
2017-10-24 17:59:13,634 condoor.connection:description_record(834): Connection information cleared
2017-10-24 17:59:13,634 condoor.connection:_clear_cache(224): Description record: {'connections': [{'chain': [{'platform': None, 'driver_name': 'generic', 'is_console': None, 'mode': None, 'family': None, 'os_version': None, 'os_type': None, 'udi': None, 'hostname': 'XXX.XXX.XXX.XXX:23', 'is_target': True}]}], 'last_chain': 0}
2017-10-24 17:59:13,634 condoor.connection:_get_key(188): Cache key: [telnet://newuser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:59:13,634 condoor.connection:_write_cache(205): Connection information cached: 27b51cce1d7603bfbea511b6b2bb7633
2017-10-24 17:59:13,635 condoor.connection:_disable_logging(168): Closing logs
Can you try telnet to the host from where CSM is and use telnet port 23 as indicated in the log? Please also make sure the password is entered correctly. It looks like authentication issue.
Alex
From: victorseth notifications@github.com<mailto:notifications@github.com> Reply-To: csm-aut/csm reply@reply.github.com<mailto:reply@reply.github.com> Date: Tuesday, October 24, 2017 at 1:03 PM To: csm-aut/csm csm@noreply.github.com<mailto:csm@noreply.github.com> Cc: Alex Tang alextang@cisco.com<mailto:alextang@cisco.com>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [csm-aut/csm] Update to v3.4 failed (#100)
Ok, now it changed:
Traceback (most recent call last): File "/usr/local/csm/csmserver/work_units/install_work_unit.py", line 95, in start handler_class = get_install_handler_class(ctx) File "/usr/local/csm/csmserver/handlers/loader.py", line 74, in get_install_handler_class discover_platform_info(ctx) File "/usr/local/csm/csmserver/handlers/loader.py", line 48, in discover_platform_info conn.connect(force_discovery=True) File "/usr/local/lib/python2.7/site-packages/condoor/connection.py", line 253, in connect retry=False) File "/usr/local/lib/python2.7/site-packages/condoor/connection.py", line 361, in reconnect raise excpt ConnectionAuthenticationError: 192.168.121.225:23: Authentication failed
condor.log:
2017-10-24 17:42:50,603 condoor.connection:reconnect(291): --------------------
2017-10-24 17:42:50,604 condoor.connection:reconnect(292): Condoor Version 1.0.9
2017-10-24 17:42:50,604 condoor.connection:reconnect(293): Cache filename: /tmp/condoor.1.0.9.shelve
2017-10-24 17:42:50,606 condoor.device:driver_name(308): Driver generic
2017-10-24 17:42:50,606 condoor.connection:reconnect(296): Connecting
2017-10-24 17:42:50,606 condoor.connection:_clear_cache(221): Clearing connection cache
2017-10-24 17:42:50,606 condoor.connection:_get_key(188): Cache key: [telnet://csmserver@XXX.XXX.XXX.XXX:23]
2017-10-24 17:42:50,642 condoor.connection:_cache_open(195): Unable to open a cache file for read.
2017-10-24 17:42:50,642 condoor.connection:description_record(834): Connection information cleared
2017-10-24 17:42:50,642 condoor.connection:_clear_cache(224): Description record: {'connections': [{'chain': [{'platform': None, 'driver_name': 'generic', 'is_console': None, 'mode': None, 'family': None, 'os_version': None, 'os_type': None, 'udi': None, 'hostname': 'XXX.XXX.XXX.XXX:23', 'is_target': True}]}], 'last_chain': 0}
2017-10-24 17:42:50,642 condoor.connection:_get_key(188): Cache key: [telnet://csmserver@XXX.XXX.XXX.XXX:23]
2017-10-24 17:42:50,643 condoor.connection:_write_cache(205): Connection information cached: c6e0d5abd1bc093b1d07a18df2010c94
2017-10-24 17:42:50,643 condoor.connection:emit_message(582): Connection chain 1/1: telnet://csmserver@XXX.XXX.XXX.XXX:23
2017-10-24 17:42:50,643 condoor.connection:emit_message(582): Trying to (re)connect within 120 seconds
2017-10-24 17:42:50,643 condoor.connection:emit_message(582): Connection chain/attempt [1/1]
2017-10-24 17:42:50,643 condoor.connection:emit_message(582): Connecting telnet://csmserver@XXX.XXX.XXX.XXX:23
2017-10-24 17:42:50,643 condoor.controller:spawn_session(49): Spawning command: 'telnet XXX.XXX.XXX.XXX 23'
2017-10-24 17:42:50,658 condoor.controller:spawn_session(59): Child process FD: 11
2017-10-24 17:42:50,658 condoor.controller:spawn_session(65): Terminal window size changed from 24x80 to 512x160
2017-10-24 17:42:50,658 condoor.controller:set_session_log(79): Setting the session log
2017-10-24 17:42:50,658 protocols.telnet:connect(66): EXPECTED_PROMPT='(?P
session.log
Trying XXX.XXX.XXX.XXX... Connected to XXX.XXX.XXX.XXX Escape character is '^]'.
User Access Verification
Username: YYYYYY Password:
User Access Verification
Username:
YYYYYY it's a old username. I already changed. Still giving the same error.
session.log(After correction)
User Access Verification
Username: newuser Password:
User Access Verification Username:
condoor.log (After correction):
2017-10-24 17:59:12,042 condoor.connection:reconnect(291): --------------------
2017-10-24 17:59:12,042 condoor.connection:reconnect(292): Condoor Version 1.0.9
2017-10-24 17:59:12,042 condoor.connection:reconnect(293): Cache filename: /tmp/condoor.1.0.9.shelve
2017-10-24 17:59:12,044 condoor.device:driver_name(308): Driver generic
2017-10-24 17:59:12,044 condoor.connection:reconnect(296): Connecting
2017-10-24 17:59:12,044 condoor.connection:_clear_cache(221): Clearing connection cache
2017-10-24 17:59:12,045 condoor.connection:_get_key(188): Cache key: [telnet://newuser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] is_target<-True
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] family<-None
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] os_version<-None
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] hostname<-XXX.XXX.XXX.XXX:23
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] platform<-None
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] driver_name<-generic
2017-10-24 17:59:12,048 condoor.device:driver_name(308): Driver generic
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] is_console<-None
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] mode<-None
2017-10-24 17:59:12,048 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] os_type<-None
2017-10-24 17:59:12,049 condoor.device:device_info(85): Update: [telnet://newuser@XXX.XXX.XXX.XXX:23] udi<-None
2017-10-24 17:59:12,049 condoor.chain:update(148): Device information updated -> [telnet://newuser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:59:12,049 condoor.connection:description_record(844): Connection information updated from cache.
2017-10-24 17:59:12,049 condoor.connection:_read_cache(213): Read cached information.
2017-10-24 17:59:12,049 condoor.connection:description_record(834): Connection information cleared
2017-10-24 17:59:12,049 condoor.connection:_clear_cache(224): Description record: {'connections': [{'chain': [{'platform': None, 'driver_name': 'generic', 'is_console': None, 'mode': None, 'family': None, 'os_version': None, 'os_type': None, 'udi': None, 'hostname': 'XXX.XXX.XXX.XXX:23', 'is_target': True}]}], 'last_chain': 0}
2017-10-24 17:59:12,049 condoor.connection:_get_key(188): Cache key: [telnet://newuser@XXX.XXX.XXX.XXX:23]
2017-10-24 17:59:12,050 condoor.connection:_write_cache(205): Connection information cached: 27b51cce1d7603bfbea511b6b2bb7633
2017-10-24 17:59:12,050 condoor.connection:emit_message(582): Connection chain 1/1: telnet://newuser@XXX.XXX.XXX.XXX:23
2017-10-24 17:59:12,050 condoor.connection:emit_message(582): Trying to (re)connect within 120 seconds
2017-10-24 17:59:12,050 condoor.connection:emit_message(582): Connection chain/attempt [1/1]
2017-10-24 17:59:12,050 condoor.connection:emit_message(582): Connecting telnet://newuser@XXX.XXX.XXX.XXX:23
2017-10-24 17:59:12,051 condoor.controller:spawn_session(49): Spawning command: 'telnet XXX.XXX.XXX.XXX 23'
2017-10-24 17:59:12,058 condoor.controller:spawn_session(59): Child process FD: 11
2017-10-24 17:59:12,058 condoor.controller:spawn_session(65): Terminal window size changed from 24x80 to 512x160
2017-10-24 17:59:12,058 condoor.controller:set_session_log(79): Setting the session log
2017-10-24 17:59:12,059 protocols.telnet:connect(66): EXPECTED_PROMPT='(?P
- You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/csm-aut/csm/issues/100#issuecomment-339114118, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKh3SAGPtx8pYJfFrh8qN2H6kH40_pq4ks5svkKsgaJpZM4Pz_Vp.
Yes, I logged on before pre-update and after pre-update. Even after changing username and password information, using "telnet xxx.xxx.xxx.xxx 23"
We're not using global user/pass
Please provide the info I asked in my previous email.
From: victorseth notifications@github.com<mailto:notifications@github.com> Reply-To: csm-aut/csm reply@reply.github.com<mailto:reply@reply.github.com> Date: Tuesday, October 24, 2017 at 1:19 PM To: csm-aut/csm csm@noreply.github.com<mailto:csm@noreply.github.com> Cc: Alex Tang alextang@cisco.com<mailto:alextang@cisco.com>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [csm-aut/csm] Update to v3.4 failed (#100)
Yes, I logged on before pre-update and after pre-update. Even after changing username and password information.
- You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/csm-aut/csm/issues/100#issuecomment-339118256, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKh3SLU9lCUwa-UHHtxWnaQwOpusKHb2ks5svkY7gaJpZM4Pz_Vp.
And, does the password contain any strange characters?
From: victorseth notifications@github.com<mailto:notifications@github.com> Reply-To: csm-aut/csm reply@reply.github.com<mailto:reply@reply.github.com> Date: Tuesday, October 24, 2017 at 1:19 PM To: csm-aut/csm csm@noreply.github.com<mailto:csm@noreply.github.com> Cc: Alex Tang alextang@cisco.com<mailto:alextang@cisco.com>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [csm-aut/csm] Update to v3.4 failed (#100)
Yes, I logged on before pre-update and after pre-update. Even after changing username and password information.
- You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/csm-aut/csm/issues/100#issuecomment-339118256, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKh3SLU9lCUwa-UHHtxWnaQwOpusKHb2ks5svkY7gaJpZM4Pz_Vp.
No, the password does not contain any.
Please capture the manual telnet interaction between the device and the server which hosts CSM.
Please email me directly, alextang@cisco.com, so I can send you some debug code.
From: victorseth notifications@github.com<mailto:notifications@github.com> Reply-To: csm-aut/csm reply@reply.github.com<mailto:reply@reply.github.com> Date: Wednesday, October 25, 2017 at 2:36 AM To: csm-aut/csm csm@noreply.github.com<mailto:csm@noreply.github.com> Cc: Alex Tang alextang@cisco.com<mailto:alextang@cisco.com>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [csm-aut/csm] Update to v3.4 failed (#100)
No, the password does not.
- You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/csm-aut/csm/issues/100#issuecomment-339273136, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKh3SEZa6_LjOAVTqeUt7swNGdoa3v6kks5svwEXgaJpZM4Pz_Vp.
I think I found the problem/quick-fix and another kind of problem.
Some devices may have an post-login banner. Most of our devices have it.
If this post-login banner is big enough(number of characters), the CSMServer will not identify the prompt (hostname#) even if the login is completed.
I removed the post-login banner from the logs because they contain sensitve information. We noted it because the logs from session.log did matched the capture when we manually log on BUT they ended abruptly (after the password, almost 770 characters were printed before the end). Our entire banner, counting linebreaks(up and down the banner), have at least 890 characters.
When we removed (just temporarily) the banners, the Check worked and the pre-update run smoothly. Maybe I can change the number of characters to parse before giving "Authentication Failed". Is there a solution for that? We use and need these banners.
Now the second problem, I think it's unrelated.
[2017-10-25 15:53:32 +0000] [25887] [ERROR] Error handling request
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 129, in handle
self.handle_request(listener, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 170, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1836, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/werkzeug/contrib/fixers.py", line 148, in __call__
return self.app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1820, in wsgi_app
response = self.make_response(self.handle_exception(e))
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1566, in make_response
raise ValueError('View function did not return a response')
ValueError: View function did not return a response
Exception on /cco/api/get_catalog [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/local/lib/python2.7/site-packages/flask_login.py", line 758, in decorated_view
return func(*args, **kwargs)
File "/usr/local/csm/csmserver/views/cco.py", line 389, in api_get_catalog
if preferences.excluded_platforms_and_releases is not None:
AttributeError: 'NoneType' object has no attribute 'excluded_platforms_and_releases'
[2017-10-25 15:53:36 +0000] [25891] [ERROR] Error handling request
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 129, in handle
self.handle_request(listener, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 170, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1836, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/werkzeug/contrib/fixers.py", line 148, in __call__
return self.app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1820, in wsgi_app
response = self.make_response(self.handle_exception(e))
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1566, in make_response
raise ValueError('View function did not return a response')
ValueError: View function did not return a response
I'm still receiving this on the machine prompt everytime I enter on the home menu. And i noted that CCO menu is empty.
Do I need to open a new issue regarding this?
Yes, the banner can confuse CSM prompt detection. Currently, it does have logic to skip a specific number of # characters.
Please send me the login sequence with banner so we can take a look. As mentioned, you can directly email me.
Regarding the CCO menu, do you have Internet access? Can you try create a new database (edit database.ini and restart CSM) and see if the issue still there?
From: victorseth notifications@github.com<mailto:notifications@github.com> Reply-To: csm-aut/csm reply@reply.github.com<mailto:reply@reply.github.com> Date: Wednesday, October 25, 2017 at 11:00 AM To: csm-aut/csm csm@noreply.github.com<mailto:csm@noreply.github.com> Cc: Alex Tang alextang@cisco.com<mailto:alextang@cisco.com>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [csm-aut/csm] Update to v3.4 failed (#100)
I think I found the problem/quick-fix and another kind of problem.
Some devices may have an post-login banner. Most of our devices have it.
If this post-login banner is big enough(number of characters), the CSMServer will not identify the prompt (hostname#) even if the login is completed.
I removed the post-login banner from the logs because they contain sensitve information. We noted it because the logs from session.log did matched the capture when we manually log on BUT they ended abruptly (after the password, almost 770 characters were printed before the end). Our entire banner, counting linebreaks(up and down the banner), have at least 890 characters.
When we removed (just temporarily) the banners, the Check worked and the pre-update run smoothly. Maybe I can change the number of characters to parse before giving "Authentication Failed". Is there a solution to that? We can't remove our banners.
Now the second problem, I think it's unrelated.
[2017-10-25 15:53:32 +0000] [25887] [ERROR] Error handling request Traceback (most recent call last): File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 129, in handle self.handle_request(listener, req, client, addr) File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 170, in handle_request respiter = self.wsgi(environ, resp.start_response) File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1836, in call return self.wsgi_app(environ, start_response) File "/usr/local/lib/python2.7/site-packages/werkzeug/contrib/fixers.py", line 148, in call return self.app(environ, start_response) File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1820, in wsgi_app response = self.make_response(self.handle_exception(e)) File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1566, in make_response raise ValueError('View function did not return a response') ValueError: View function did not return a response Exception on /cco/api/get_catalog [GET] Traceback (most recent call last): File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app response = self.full_dispatch_request() File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request rv = self.handle_user_exception(e) File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception reraise(exc_type, exc_value, tb) File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request rv = self.dispatch_request() File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request return self.view_functionsrule.endpoint File "/usr/local/lib/python2.7/site-packages/flask_login.py", line 758, in decorated_view return func(*args, **kwargs) File "/usr/local/csm/csmserver/views/cco.py", line 389, in api_get_catalog if preferences.excluded_platforms_and_releases is not None: AttributeError: 'NoneType' object has no attribute 'excluded_platforms_and_releases' [2017-10-25 15:53:36 +0000] [25891] [ERROR] Error handling request Traceback (most recent call last): File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 129, in handle self.handle_request(listener, req, client, addr) File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 170, in handle_request respiter = self.wsgi(environ, resp.start_response) File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1836, in call return self.wsgi_app(environ, start_response) File "/usr/local/lib/python2.7/site-packages/werkzeug/contrib/fixers.py", line 148, in call return self.app(environ, start_response) File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1820, in wsgi_app response = self.make_response(self.handle_exception(e)) File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1566, in make_response raise ValueError('View function did not return a response') ValueError: View function did not return a response
I'm still receiving this on the machine prompt everytime I enter on the home menu. And i noted that CCO menu is empty. [bugcsm1]https://user-images.githubusercontent.com/17484197/32014612-4f1ea872-b99d-11e7-985b-aac5f77eb3db.png
Do I need to open a new issue regarding this?
- You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/csm-aut/csm/issues/100#issuecomment-339417261, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKh3SIgaF3aTBh9nECFeVsijY4wBwECzks5sv3c0gaJpZM4Pz_Vp.
[username@csmhostname]# telnet XXX.XXX.XXX.XXX 23
Trying XXX.XXX.XXX.XXX...
Connected to XXX.XXX.XXX.XXX.
Escape character is '^]'.
+-----------------------------------------------------------------------+
| WARNING -- XXXXXXXX |
| =================== |
| |
| The programs and data held on this system are the property of, or |
| licensed by, a company in the XXXXXXXX. |
| |
| If the company has not authorized your access to this system you |
| will commit a criminal offence if you do not immediately disconnect. |
| |
| Unauthorized access is strictly forbidden and a disciplinary offence. |
+-----------------------------------------------------------------------+
User Access Verification
Username: username
Password:
+-----------------------------------------------------------------------+
| WARNING -- XXXXXXXX |
| =================== |
| |
| The programs and data held on this system are the property of, or |
| licensed by, a company in the XXXXXXXX. |
| |
| If the company has not authorized your access to this system you |
| will commit a criminal offence if you do not immediately disconnect. |
| |
| Unauthorized access is strictly forbidden and a disciplinary offence. |
+-----------------------------------------------------------------------+
RP/0/RSP0/CPU0:XXXXXXXX#
Maintaining the number of characters and formatation.
I'll try the new database test now.
The new database solved the CCO menu and the exceptions on the terminal.
There is only the issue with the prompt detection now.
Hi @victorseth,
the problem with the banner is that 'not authorized' text is recognised by CSM as an error.
To overcome this issue please add
---
generic:
authentication_error:
pattern: '% Authentication failed|Login incorrect'
description: 'Authentication error'
There is no ".condoor" folder in the home directory. Only on /usr/local/condoor/patterns.yaml /usr/local/lib/python2.7/site-packages/condoor/patterns.yaml
Just create it, please
@victorseth, does it do the job, pls?
Yes it solved. I'm getting inventories now. No more errors.
Hello,
We're trying to update our CSM to 3.4 but it failed with the following error:
IntegrityError: (IntegrityError) (1215, u'Cannot add foreign key constraint') '\nCREATE TABLE host_inventory_history (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\thost_id INTEGER, \n\tnotes TEXT, \n\tchanged_time DATETIME, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(host_id) REFERENCES host (id)\n)\n\n' () [2017-10-10 10:36:49 +0000] [25422] [INFO] Worker exiting (pid: 25422)
Tried to update to 3.3, same error.
Our version was built 01/25/2016. We never updated it before.
Questions: 1º Where can we see the csmserver version? 2º Is this a integrity check? If we create the missing tables will it work?
Thanks, Victor