<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-5107334831712116530</id><updated>2026-06-28T20:10:20.883-07:00</updated><title type='text'>Dev Blog</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://devblog.kudriavtsev.net/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5107334831712116530/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://devblog.kudriavtsev.net/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Alexei</name><uri>http://www.blogger.com/profile/07862172062832053589</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>4</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-5107334831712116530.post-5607910069377447485</id><published>2020-02-17T18:24:00.000-08:00</published><updated>2020-02-17T18:24:41.257-08:00</updated><title type='text'>Cisco 3702e in Autonomous Mode</title><content type='html'>The AIR-CAP3702E-A-K9 I purchased on eBay came configured in lightweight mode and with an unknown password. I reset it to factory setting by pressing and holding Mode button for 10 seconds or more.  It rebooted into the boot loader.  First thing to do was to set up a TFTP server on my Mac, which had IP address &lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;10.10.1.46&lt;/span&gt;, and put the new image into &lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;/private/tftpboot/&lt;/span&gt;.
&lt;br /&gt;
&lt;pre&gt;sudo launchctl load -F /System/Library/LaunchDaemons/tftp.plist
sudo launchctl start com.apple.tftpd
&lt;/pre&gt;
After all was done, stop it:
&lt;br /&gt;
&lt;pre&gt;sudo launchctl stop com.apple.tftpd
&lt;/pre&gt;
My USB to serial adapter was Prolific.  To install the drivers:
&lt;br /&gt;
&lt;pre&gt;brew tap homebrew/cask-drivers
brew cask install prolific-pl2303
&lt;/pre&gt;
Now, connect to the AP.
&lt;br /&gt;
&lt;pre&gt;screen /dev/cu.usbserial

ap: set DEFAULT_ROUTER 10.10.1.1
ap: set IP_ADDR 10.10.1.200
ap: set NETMASK 255.255.255.0
ap: tftp_init
ap: ether_init
ap: flash_init
ap: tar -xtract tftp://10.10.1.46/ap3g2-k9w7-tar.153-3.JC3.tar flash:
ap: set BOOT flash:/ap3g2-k9w7-mx.153-3.JC3/ap3g2-k9w7-xx.153-3.JC3
ap: boot
&lt;/pre&gt;
The AP rebooted into new image, I was able to ssh to it, but for some reason web interface did not work.  Didn&#39;t want to spend time troubleshooting this.  Just reloaded another image.  I also decided to save current software, just in case.  For that to work I had to touch &lt;span style=&quot;font-family: &amp;quot;courier new&amp;quot; , &amp;quot;courier&amp;quot; , monospace;&quot;&gt;/private/tftpboot/ap3g2-rcvk9w8-mx.tar&lt;/span&gt;.
&lt;br /&gt;
&lt;pre&gt;ap&amp;gt;en
ap#archive tar /create tftp://10.10.1.46/ap3g2-rcvk9w8-mx.tar flash:/ap3g2-rcvk9w8-mx
ap#archive download-sw /overwrite /reload tftp://10.10.1.46/ap3g2-k9w7-tar.153-3.JBB5.tar
&lt;/pre&gt;
To configure the access point, follow the instructions in &lt;a href=&quot;https://www.cisco.com/c/en/us/td/docs/wireless/access_point/15-3-3-JB/configuration/guide/cg_book.html&quot;&gt;Cisco IOS Configuration Guide for Autonomous Cisco Aironet Access Points&lt;/a&gt;.&lt;br /&gt;
</content><link rel='replies' type='application/atom+xml' href='http://devblog.kudriavtsev.net/feeds/5607910069377447485/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://devblog.kudriavtsev.net/2020/02/cisco-3702e-in-autonomous-mode.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5107334831712116530/posts/default/5607910069377447485'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5107334831712116530/posts/default/5607910069377447485'/><link rel='alternate' type='text/html' href='http://devblog.kudriavtsev.net/2020/02/cisco-3702e-in-autonomous-mode.html' title='Cisco 3702e in Autonomous Mode'/><author><name>Alexei</name><uri>http://www.blogger.com/profile/07862172062832053589</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5107334831712116530.post-5762472203211348085</id><published>2015-01-29T23:12:00.002-08:00</published><updated>2020-03-08T19:06:11.167-07:00</updated><title type='text'>How to Convert Quicken QFX files to QuickBooks QBO files for Import via Web Connect</title><content type='html'>The files actually have identical structure. There are only three things preventing the import:
&lt;ol&gt;
&lt;li&gt;Download the file as &quot;Quicken 2004 or Newer (QFX)&quot;
&lt;li&gt;Replace file extension from .qfx to .qbo
&lt;li&gt;In the file, replace &amp;lt;INTU.BID&amp;gt; number with 10308 for BofA. See the link below for other banks.
&lt;li&gt;(This may not be necessary) In the file header replace &amp;lt;FID&amp;gt; number with the same number
&lt;li&gt;Import the file into QuickBooks
&lt;/ol&gt;

QuickBooks tries to validate the financial intitution ID for web connect import and if it is QIF file it fails saying &quot;QuickBooks is unable to verify the Financial Institution information for this download.&quot; If you use a valid ID, most likely from a different financial institution, the import will succeed and the only annoyance is that QuickBooks will think the data came from The Bank of America, if you use 10308, or &amp;lt;FID&amp;gt;10898 &amp;lt;INTU.BID&amp;gt;2430 for Chase. You might not have to change FID. Find INTU.BID for you bank here: &lt;a href=&quot;https://ofx-prod-filist.intuit.com/qb2800/data/fidir.txt&quot;&gt;https://ofx-prod-filist.intuit.com/qb2800/data/fidir.txt&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://devblog.kudriavtsev.net/feeds/5762472203211348085/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://devblog.kudriavtsev.net/2015/01/how-to-convert-quicken-qfx-files-to.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5107334831712116530/posts/default/5762472203211348085'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5107334831712116530/posts/default/5762472203211348085'/><link rel='alternate' type='text/html' href='http://devblog.kudriavtsev.net/2015/01/how-to-convert-quicken-qfx-files-to.html' title='How to Convert Quicken QFX files to QuickBooks QBO files for Import via Web Connect'/><author><name>Alexei</name><uri>http://www.blogger.com/profile/07862172062832053589</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5107334831712116530.post-4151774692904661011</id><published>2015-01-04T23:45:00.000-08:00</published><updated>2015-01-04T23:45:08.949-08:00</updated><title type='text'>Cisco 3602i in Autonomous Mode</title><content type='html'>&lt;p&gt;Recently, I decided to upgrade my wireless access point. I considered CISCO AIR-CAP3602I-A-K9 and AIR-CAP3602E-A-K9. The 3602e looked a little fragile and I decided to go with 3602i with internal antennas.

&lt;p&gt;Bought the access point on ebay and it came configured in lightweight mode. The problem was that it kept searching for the controller (WLC) and since there was none it would get new IP address from DHCP every 10 seconds, which wouldn&#39;t let me upload new image. The error was something like &quot;could not discover wlc using dhcp ip. renewing dhcp ip&quot;. I set the access point to static IP, but after it was not able to find WLC it switched back to DHCP. Then I set address of the WLC so it would not search for it. It was still trying to connect to the non-existing WLC, but it did not interfere with uploading new image.

&lt;p&gt;I used local connection to the access point through the console port while the access point was also connected to LAN. After setting the IP addresses I saved installed image to my tftp server, just in case, and uploaded new image. The commands below are not the exact session I went through, rather a list of all the commands I used:

&lt;pre&gt;
en
lwapp ap ip address 10.10.10.1 255.255.255.0
debug capwap console cli
config terminal
interface BVI1
ip address 10.10.10.99 255.255.255.0
exit
archive tar /create tftp://10.10.10.119/ap3g2-k9w8-mx.124-25e.JA1.tar flash:/ap3g2-k9w8-mx.124-25e.JA1
archive tar /xtract tftp://10.10.10.119/ap3g2-k9w7-tar.153-3.JAB.tar flash:
config terminal
boot system flash:/ap3g2-k9w7-mx.153-3.JAB/ap3g2-k9w7-mx.153-3.JAB
exit
reload
&lt;/pre&gt;

&lt;p&gt;The access point rebooted in autonomous mode and I followed the instructions in &quot;&lt;a href=&quot;http://www.cisco.com/c/dam/en/us/td/docs/wireless/access_point/15_2_4_JB/configuration/guide/scg15_2_4_JB3a.pdf?mdfid=284006700&quot;&gt;Cisco Aironet Access Points Configuration
Guide for Cisco IOS Software&lt;/a&gt;&quot; to configure the desired settings.

&lt;p&gt;Tested WiFi speed and it was good, but this access point seems to loose signal strength quickly: my iPhone cannot see the network just a couple of walls away, where I was still getting signal with my old access point. Perhaps I should have used the version with external antennas...
</content><link rel='replies' type='application/atom+xml' href='http://devblog.kudriavtsev.net/feeds/4151774692904661011/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://devblog.kudriavtsev.net/2015/01/cisco-3602i-in-autonomous-mode.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5107334831712116530/posts/default/4151774692904661011'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5107334831712116530/posts/default/4151774692904661011'/><link rel='alternate' type='text/html' href='http://devblog.kudriavtsev.net/2015/01/cisco-3602i-in-autonomous-mode.html' title='Cisco 3602i in Autonomous Mode'/><author><name>Alexei</name><uri>http://www.blogger.com/profile/07862172062832053589</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5107334831712116530.post-9132987755393785917</id><published>2011-03-22T22:18:00.000-07:00</published><updated>2011-03-31T00:04:04.993-07:00</updated><title type='text'>How to spool data from Oracle database using SQL*Plus</title><content type='html'>If you need to dump data into a file, the basic commands to redirect output are:&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;spool &amp;lt;filename&amp;gt;&lt;br /&gt;
...&lt;br /&gt;
spool off&lt;br /&gt;
&lt;/div&gt;&lt;br /&gt;
However, this will have the headers, pagination, and probably lots of other stuff. To disable all of that and leave just the data use the following:&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;set heading off&lt;br /&gt;
set echo off&lt;br /&gt;
set termout off&lt;br /&gt;
set feedback off&lt;br /&gt;
set pagesize 0&lt;br /&gt;
set timing off&lt;br /&gt;
spool on&lt;br /&gt;
spool &amp;lt;filename&amp;gt;&lt;br /&gt;
...&lt;br /&gt;
spool off&lt;br /&gt;
&lt;/div&gt;&lt;br /&gt;
Now, you try that and you still see extra stuff in the output file, how come? Well, some of these only work from a script. Just create a file, let&#39;s say get-data.sql, and run it as&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;SQL&amp;gt; @get-data&lt;br /&gt;
&lt;/div&gt;&lt;br /&gt;
Another tip, for Excel you may want to produce a CSV file. You can join columns with a comma. Below is a complete example:&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&amp;gt; cat get-data.sql&lt;br /&gt;
&lt;br /&gt;
set heading off&lt;br /&gt;
set echo off&lt;br /&gt;
set termout off&lt;br /&gt;
set feedback off&lt;br /&gt;
set pagesize 0&lt;br /&gt;
set timing off&lt;br /&gt;
spool on&lt;br /&gt;
spool all-sales.csv&lt;br /&gt;
&amp;nbsp;select date || &#39;,&#39; || sum(amount)&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;from sales&lt;br /&gt;
&amp;nbsp;&amp;nbsp;group by date&lt;br /&gt;
&amp;nbsp;&amp;nbsp;order by date&lt;br /&gt;
spool off&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://devblog.kudriavtsev.net/feeds/9132987755393785917/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://devblog.kudriavtsev.net/2011/03/how-to-spool-data-from-oracle-database.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5107334831712116530/posts/default/9132987755393785917'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5107334831712116530/posts/default/9132987755393785917'/><link rel='alternate' type='text/html' href='http://devblog.kudriavtsev.net/2011/03/how-to-spool-data-from-oracle-database.html' title='How to spool data from Oracle database using SQL*Plus'/><author><name>Alexei</name><uri>http://www.blogger.com/profile/07862172062832053589</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry></feed>