<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by rimsovankiry on Medium]]></title>
        <description><![CDATA[Stories by rimsovankiry on Medium]]></description>
        <link>https://medium.com/@rimsovankiry?source=rss-bfd21c2843dd------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*toSS9X1wzA1a2TFckLBKyg.png</url>
            <title>Stories by rimsovankiry on Medium</title>
            <link>https://medium.com/@rimsovankiry?source=rss-bfd21c2843dd------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 22 Nov 2026 16:52:55 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@rimsovankiry/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Maximize Your $HMSTR Token Rewards in Hamster Kombat: Top 10 Essential Tips]]></title>
            <link>https://rimsovankiry.medium.com/maximize-your-hmstr-token-rewards-in-hamster-kombat-top-10-essential-tips-b1f11cdf84d4?source=rss-bfd21c2843dd------2</link>
            <guid isPermaLink="false">https://medium.com/p/b1f11cdf84d4</guid>
            <category><![CDATA[crypto-gaming]]></category>
            <category><![CDATA[hamster-kombat]]></category>
            <category><![CDATA[hmstr]]></category>
            <category><![CDATA[playtoearn]]></category>
            <category><![CDATA[blockchain-gaming]]></category>
            <dc:creator><![CDATA[rimsovankiry]]></dc:creator>
            <pubDate>Tue, 17 Sep 2024 11:13:19 GMT</pubDate>
            <atom:updated>2024-09-18T11:07:10.619Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DjS-tWgXJaRIehjBc6wQ9Q.jpeg" /></figure><p>I joined <strong>Hamster Kombat</strong> in March 2024, and now it’s time to prepare for the closing of Season 1 on September 20, 2024. Get ready to receive your reward airdrop of $HMSTR tokens!</p><p>In this guide, I will walk you through the steps to ensure you maximize your airdrop rewards. As mentioned, all your in-game achievements will be converted into tokens based on the following allocation points:</p><ul><li>Passive Income</li><li>Earn Tasks</li><li>Friends</li><li>Achievements</li><li>Telegram Subscription</li><li>Keys</li></ul><h3>1. Passive income (Profit per hour)</h3><p>Your profit is broken down into five categories:</p><ul><li><strong>100K coins</strong></li><li><strong>500K coins</strong></li><li><strong>1M coins</strong></li><li><strong>2M coins</strong></li><li><strong>3M coins</strong></li></ul><p>We suggest upgrading your cards to achieve a minimum profit of 3M coins per hour to unlock this category.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*shROiSrJ6Fuz0Iw8ZkS-xg.png" /><figcaption>Profit per hour — Hamster kombat</figcaption></figure><h3>2. Collect coins or Hold coin balance</h3><p>You need to collect a minimum of 1M coins to unlock one achievement. We recommend trying to hold at least 1.5B coins to reach level 10 (Lord) and unlock four types in the coin collection.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bfzq2Gt5fVuwdmL3QX3WxA.png" /><figcaption>Hold 1.5B coins balance</figcaption></figure><h3>3. Upgrade card or buy 50 card in total</h3><p>To unlock two achievements in upgrading cards, you should aim to buy at least 25 cards. However, purchasing 50 cards will significantly boost your rewards. Remember, the more cards you own, the more profit you can generate per hour by upgrading them.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Sacxb3k_auDj2QQrasaZUQ.jpeg" /><figcaption>You need purchase 50 cards in total</figcaption></figure><h3>4. Upgrade cards to level 15</h3><p>Aim to upgrade each card to level 15, and try to upgrade a total of 50 cards to unlock all achievements related to this category but you should aim to buy at least 25 cards if you think enough for you.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*V7Nmr4blSVXuSHavM2-T6Q.jpeg" /><figcaption>Unlock all by upgrade card each at least lvl 15 in total of 50 cards.</figcaption></figure><h3><strong>5. Upgrade cards to level 25</strong></h3><p>This is one of the most challenging tasks. Upgrading cards to level 25 requires spending 1.83B coins from level 24 to 25. The best way to achieve this is by upgrading KYC cards, as they cost less than other cards. We recommend upgrading at least one card to level 25.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hSRkvmpzKkVWGCBjkKGyvQ.jpeg" /><figcaption>lvl 25 per cards</figcaption></figure><h4>Upgrading BTC Pairs</h4><p>Upgrading cards to level 25 requires spending 1.83B coins for BTC pairs.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*LsLdiard3yRwMUH5pZEP5g.jpeg" /><figcaption>BTC pairs card — lvl 24 with cost 1.83B coins</figcaption></figure><h4>Upgrading KYC cards</h4><p>Upgrading KYC cards in Legal section is the most saving cost.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*eb7CBxbnmfk9AVWGb6DQLw.png" /><figcaption>KYC card lvl 23</figcaption></figure><h3>6. Invite Friend</h3><p>Invite a minimum of three friends to become eligible for tasks in the Earn tab. This will also unlock many special cards for you.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*2faeojEdfBU-96RPAdqO-w.jpeg" /><figcaption>Invite 100 friends unlock all</figcaption></figure><h3>7. Unlock Skins</h3><p>You need to buy a minimum of 10 skins. Purchasing all skins will unlock three achievements for collecting 25 skins. To further enhance your achievements, open the daily hamster bot for seven days, and you will receive one free skin.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NT_M6cb6R-rFSzkJRKg_kA.jpeg" /><figcaption>Buy 25 skins unlock 4 achievement</figcaption></figure><p>Or you can get free skin by daily rewards on Earn tap</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OsZ9mBCQZ7pgW3PKhBVUsw.png" /><figcaption>Exclusive skin by open Hamster bot daily</figcaption></figure><h3>8. Watch Hamster youtube video</h3><p>Engaging with the Hamster YouTube channel will help you unlock achievements and gain more insights into the game.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1qjX2gD1UTGB8_AOOEOcBw.jpeg" /><figcaption>50 viedeos watched</figcaption></figure><p>Usually, there are two task for watch Hamster Youtube videos. You can find it on Tap Earn in the game.</p><h3>9. Subscribed to Hamster TG</h3><p>Subscribing to the Hamster Telegram channel will keep you updated and may provide additional rewards.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*beaZX53_-n3xBFnVK9cm9w.jpeg" /></figure><p>It is automate achievement based on date you joined Hamster.</p><h3>10. Collect Keys</h3><p>Collecting keys is essential. You can find them in the Playground, through mini-games, and daily rewards by opening the hamster. We suggest collecting as many keys as possible to gain more points.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*FQIg8h-nwoQmYOj9Oz6lTw.jpeg" /><figcaption>Total collect 544 keys</figcaption></figure><p><strong><em>Be aware using cheating tools or key generator from website because you will achievement Cheating and you will not eligible for airdrop.</em></strong></p><h3>Conclusion</h3><p>I hope my experience helps everyone earn more rewards. Don’t forget to click “Clap!” to share this article with millions of people who might need it on Medium.</p><h4>Feel free to find me on my Telegram channel for more updates:<br> <a href="https://t.me/airdrop_army_premium">t.me/airdrop_army_premium</a></h4><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b1f11cdf84d4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to get 12,000+ XP only completed 4 quests of HYBRID]]></title>
            <link>https://rimsovankiry.medium.com/how-to-get-12-000-xp-only-completed-4-quests-of-hybrid-a6acfa53a352?source=rss-bfd21c2843dd------2</link>
            <guid isPermaLink="false">https://medium.com/p/a6acfa53a352</guid>
            <category><![CDATA[hybrid]]></category>
            <category><![CDATA[how-to]]></category>
            <dc:creator><![CDATA[rimsovankiry]]></dc:creator>
            <pubDate>Wed, 03 Jul 2024 12:58:14 GMT</pubDate>
            <atom:updated>2024-07-04T11:28:28.533Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IaMCnvinURp7LgM-dEizxA.png" /></figure><h3>🔥<strong>12,000+ XP</strong> only completed 4 quests of HYBRID 🔄</h3><h3><strong>2500 XP</strong></h3><p>Use the Faucet to get HYB for free and claim your XP!</p><p>1. Go to -&gt; <a href="https://app.buildonhybrid.com/faucet">https://app.buildonhybrid.com/faucet</a></p><p>2. Input ETH address -&gt; Click Send Token</p><p>3. Go Quest To claim “<a href="https://quest.buildonhybrid.com/quest/HYBHoldings">HYBHoldings</a>”.</p><h3><strong>1750 XP</strong></h3><p>1- Post a screenshot of your best Atlas response on X.</p><p>2- Tag 5 friends to share their responses.</p><p>3- Use hashtags #HybridTestnet and #HybridAirdrop.</p><p>4- Share your referral link for this quest in the tweet</p><p>5- Submit link “<a href="https://quest.buildonhybrid.com/quest/ShareYourAtlasResponse">ShareYourAtlasResponse</a> “</p><p>You can find simple post -&gt; <a href="https://x.com/sudo_gang/status/1808114118928617840">click here</a></p><h3><strong>2000 XP</strong></h3><p>1. Writing some interest about Testnet and Post on X account</p><p>2. Copy link and sumbit in queusts</p><p>3. Waiting approve and claim</p><p>4. Submit link here “<a href="https://quest.buildonhybrid.com/quest/HybridTestnetWritingContest">HybridTestnetWritingContest</a>”</p><p>You can find simple post -&gt; <a href="https://x.com/sudo_gang/status/1806979475588120998">click here</a></p><h3><strong>6000 XP</strong></h3><p>1. Download extension <a href="https://wallet.magiceden.io/">Magic Eden Wallet</a> and install</p><p>2. Click I have wallet -&gt; Import secert key from ur wallet to Magic Eden (Remember use the wallet that u connected HYBRID)</p><p>3. Go to quests “<a href="https://quest.buildonhybrid.com/quest/MagicEdenWalletxHybrid">MagicEdenWalletxHybrid</a>”.</p><p>4. Disconnect Wallet in quests</p><p>5. Connect to Magic Eden Wallet</p><p>6. Click Check eligibility to claim reward</p><p>If you create new wallet the reward XP will claim different wallet account.</p><p>Follow my channel for more <a href="https://t.me/airdrop_army_premium">https://t.me/airdrop_army_premium</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a6acfa53a352" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Use Morse Code to Earn a Million Free Coins — Hamster Kombat]]></title>
            <link>https://rimsovankiry.medium.com/how-to-use-morse-code-to-earn-a-million-free-coins-hamster-kombat-f6ccff7e294a?source=rss-bfd21c2843dd------2</link>
            <guid isPermaLink="false">https://medium.com/p/f6ccff7e294a</guid>
            <category><![CDATA[games]]></category>
            <category><![CDATA[hamster-kombat]]></category>
            <category><![CDATA[how-to]]></category>
            <category><![CDATA[telegram]]></category>
            <category><![CDATA[crypto]]></category>
            <dc:creator><![CDATA[rimsovankiry]]></dc:creator>
            <pubDate>Thu, 06 Jun 2024 09:27:56 GMT</pubDate>
            <atom:updated>2024-06-06T15:42:18.839Z</atom:updated>
            <content:encoded><![CDATA[<h3>How to Use Morse Code to Earn a Million Free Hamster Kombat Coins</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*dpajkL4vSuR83v6c" /><figcaption>Photo by <a href="https://unsplash.com/@chriscurry92?utm_source=medium&amp;utm_medium=referral">Chris Curry</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Hey everyone,</p><p>I recently started playing <a href="https://t.me/hamSter_kombat_bot/start?startapp=kentId917868093"><strong>Hamster Kombat</strong> </a>on Telegram and stumbled upon an exciting new feature that I think you’ll find interesting: the <strong>Daily Cipher</strong>. This feature allows you to earn a million free coins every day, and it’s a great way to boost your in-game currency ahead of the token launch on The Open Network (TON) and the upcoming airdrop.</p><h3>What is the Daily Cipher?</h3><p>Introduced on June 5, the daily cipher allows players to earn 1 million free tokens daily. The game’s official Telegram channel teased this feature, and a string of Morse code was shown on the Telegram mini app’s loading screen .</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CY9WPcs4t6MxFpXnpOQRug.jpeg" /><figcaption>New Loading screen with Morse Code</figcaption></figure><h3>How to Enter the Daily Cipher Code</h3><p>To enter the daily cipher code and earn your free coins, follow these steps:</p><ol><li><strong>Tap the “Earn per tap” box three times</strong> on the main screen.</li></ol><ul><li>This will change the background of your hamster icon to red.</li><li>A “Daily Cipher” box will appear below your earnings meter.</li></ul><p><strong>2. Enter the Morse code for the daily term</strong>:</p><ul><li>The first term (June 5) was “BTC” (Bitcoin). Here’s how to input it:</li><li><strong>B</strong>: long hold and then three quick taps</li><li><strong>T</strong>: long hold</li><li><strong>C</strong>: long hold, tap, long hold, tap</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5KxaVbU3DH-Ds4-nBg_nvQ.png" /><figcaption>Screenshot from Video Hamster Kombat Youtube Channel</figcaption></figure><p>Each letter will be displayed on the screen after it’s accurately entered, so you’ll know if you’ve got it right. It might take a few tries to get the cadence correct, but once you do, you’ll earn the free coins.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-fQW5xYW4KmKtat_vtTx6g.jpeg" /><figcaption>Images show your reward</figcaption></figure><h3>How to Find the Daily Cipher</h3><p>The daily cipher resets at 7 PM UTC each day. This was confirmed in an official YouTube video where Hamster Kombat also revealed the first code was “BTC.”</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kQO4WBUSj0mBqlqgm1KJvQ.jpeg" /></figure><p>You might be able to find the new daily cipher by searching social media platforms like my telegram channel (<a href="https://t.me/airdrop_army_premium">@airdrop_army_premium</a>) or TikTok, similar to how the daily combo is often shared shortly after the morning changeover. If a more reliable way to discover the daily cipher becomes available, it will be added here in a future update.</p><h4>Clap! Clap! :)👏🏼 for Mark as you’re done.</h4><h4>If you enjoy my content, don’t forget to follow me and give me a Clap! :)👏🏼</h4><p>Find me on my telegram channel link below:</p><p><a href="https://t.me/+kYBpSchCCSxmNjg1">https://t.me/+kYBpSchCCSxmNjg1</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f6ccff7e294a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Unlocking the Secrets of Hamster Kombat: A Comprehensive Guide]]></title>
            <link>https://rimsovankiry.medium.com/unlocking-the-secrets-of-hamster-kombat-a-comprehensive-guide-817694cf8992?source=rss-bfd21c2843dd------2</link>
            <guid isPermaLink="false">https://medium.com/p/817694cf8992</guid>
            <category><![CDATA[games]]></category>
            <category><![CDATA[web3]]></category>
            <category><![CDATA[hamster-kombat]]></category>
            <category><![CDATA[comprehensive-guide]]></category>
            <category><![CDATA[how-to]]></category>
            <dc:creator><![CDATA[rimsovankiry]]></dc:creator>
            <pubDate>Mon, 27 May 2024 10:40:27 GMT</pubDate>
            <atom:updated>2024-05-27T10:40:27.897Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="https://x.com/hamster_kombat/status/1793535032419574099/photo/1" src="https://cdn-images-1.medium.com/max/1024/0*d-uwjQp_QoUTwbNX" /></figure><p>If you’re an avid gamer or a fan of earning virtual currency, you’ve probably heard about the latest sensation in the world of Telegram games — Hamster Kombat. This unique and engaging game has been gaining popularity among crypto enthusiasts and casual gamers alike, and for good reason.</p><p>In this comprehensive guide, I’ll dive deep into the world of Hamster Kombat, explore its core mechanics, and share valuable tips and strategies to help you maximize your earning potential and climb the leaderboards.</p><h3>What is Hamster Kombat?</h3><p>Hamster Kombat is a captivating click-to-earn game that allows you to earn virtual coins, known as NOTCoin, through various in-game activities. The game’s focus is on the concept of earning coins per hour, and as your balance accumulates, you’ll progress to higher levels, unlocking new challenges and rewards.</p><h3>Getting Started with Hamster Kombat</h3><p>To begin your Hamster Kombat journey, simply head over to Telegram and contact the official bot, <a href="https://t.me/hamSter_kombat_bot/start?startapp=kentId917868093">@hamSter_kombat_bot</a>. From there, you’ll be able to dive into the game and start your quest to become the ultimate Hamster Kombat champion.</p><h3>Mastering the Game: Tips and Strategies</h3><p>Based on my personal experience playing Hamster Kombat since April, I’ve collected a wealth of insights and strategies to share with you. Let’s dive in:</p><ul><li><strong>Mine Special Cards</strong>: Minting special NFT cards is a crucial aspect of the game. These cards can provide a variety of benefits, such as increased coin-per-hour earnings or other valuable boosts. Inviting your friends to the game can help you unlock more of these coveted cards.</li></ul><figure><img alt="Mine Speical Card — Hamster Kombat" src="https://cdn-images-1.medium.com/max/1024/1*UgjTC1Gcdgc7D_XlJa3egw.jpeg" /></figure><p><strong>Stay Active</strong>: Consistency is key in Hamster Kombat. Make sure to open the game every 3 hours to claim your earned coins. This will ensure that your balance is constantly growing, allowing you to progress through the levels and unlock new opportunities.</p><figure><img alt="Only Play 20 days to Unlock Grandmaster lvl" src="https://cdn-images-1.medium.com/max/1024/1*38oLNt4JHWBut35oauv1pg.jpeg" /><figcaption>Only play 20 days unlock grandmaster lvl</figcaption></figure><ul><li><strong>Upgrade Items</strong>: Investing in upgrading in-game items can significantly boost your coin-per-hour earnings. Focus on upgrading items to at least level 15 to see the best results.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*53BxPcojl-7BufsbYOaxzg.jpeg" /><figcaption>Every card mine lvl 15+</figcaption></figure><ul><li><strong>Invite Friends</strong>: Bringing your friends into the game can not only be a fun and social experience, but it can also unlock additional rewards and bonuses. Work together to challenge each other and climb the leaderboards.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VuOZfhuuREouWi5F6V41BA.jpeg" /></figure><ul><li><strong>Daily Combo: </strong>It had special moves you could perform by pressing the right sequence of buttons. Now, <strong>Hamster Kombat also has a Combo of the Day!</strong> You need to <strong>upgrade three particular</strong> <strong>cards</strong> in the <strong>Mine</strong> section during the day, and you will receive a prize of <strong>5,000,000</strong> coins! 💥 <strong>Every 24 hours</strong>, the set of cards in the combo changes! (<strong>Look for them together in local chats or through YouTube searches!)</strong></li></ul><figure><img alt="Daily Combo — Hamster Kombat" src="https://cdn-images-1.medium.com/max/1024/1*_CAA3UETqV_aIF_PbSpnrw.jpeg" /></figure><p>By following these tips and immersing yourself in the world of Hamster Kombat, you’ll be well on your way to becoming a master of this captivating click-to-earn game.</p><p>For more details and to get started, be sure to check out the official Hamster Kombat bot on Telegram: <a href="https://t.me/hamSter_kombat_bot/start?startapp=kentId917868093">@hamSter_kombat_bot.</a></p><h4>Happy Hamster Kombating!</h4><h3>If you enjoy my content, don’t forget to follow me and give me a Clap! :)👏🏼</h3><p>I usually post on Twitter before publishing on Medium, so if you want to stay updated, follow me on Twitter at <a href="https://x.com/rimsovankiry">https://x.com/rimsovankiry</a>.</p><p>Pls also join my telegram channel as well to support me.</p><h4><strong>My channel link below — Invite only</strong></h4><p><a href="https://t.me/+kYBpSchCCSxmNjg1">https://t.me/+kYBpSchCCSxmNjg1</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=817694cf8992" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SQLAlchemy query with common filters]]></title>
            <link>https://rimsovankiry.medium.com/sqlalchemy-query-with-common-filters-c7adbd3321a6?source=rss-bfd21c2843dd------2</link>
            <guid isPermaLink="false">https://medium.com/p/c7adbd3321a6</guid>
            <category><![CDATA[commons]]></category>
            <category><![CDATA[sqlalchemy]]></category>
            <category><![CDATA[query]]></category>
            <category><![CDATA[operators]]></category>
            <category><![CDATA[filters]]></category>
            <dc:creator><![CDATA[rimsovankiry]]></dc:creator>
            <pubDate>Wed, 28 Apr 2021 15:07:43 GMT</pubDate>
            <atom:updated>2024-05-10T03:46:44.717Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*rIKoLkQmsw9T_fQA" /><figcaption>Photo by <a href="https://unsplash.com/@markuswinkler?utm_source=medium&amp;utm_medium=referral">Markus Winkler</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h3>Usage filter</h3><p>Some of the most common operators used in filter() method SQLAlchemy Assume class model name Post as field below</p><pre>class <strong>Post</strong>(db.Model):<br>    id = db.Column(db.Integer, primary_key = True)<br>    title = db.Column(db.String(100))<br>    content = db.Column(db.Text)<br>    author = db.Column(db.Text)</pre><h3>all</h3><pre>Post.query.all()</pre><h3>equal</h3><pre>Post.query.filter(Post.author <strong>==</strong> &#39;Robert&#39;)</pre><h3>find exist record</h3><pre>Post.query.filter(Post.author <strong>==</strong> &#39;James&#39;).first()</pre><h3>not equals</h3><pre>Post.query.filter(Post.author <strong>!=</strong> &#39;James&#39;)</pre><h3>LIKE</h3><pre>Post.query.filter(Post.title.<strong>like</strong>(&#39;%Getting started%&#39;))</pre><h3>iLIKE</h3><p>The query that selects all posts, case insensitive, that have titles that match &#39;%&#39; + some_phrase + &#39;%&#39;. That is, select all rows that have titles that <em>contain</em> some phrase, case insensitive.</p><pre>Post.query.filter(Post.title.<strong>ilike</strong>(&#39;%<strong>Lesson</strong>%&#39;))</pre><h3>IN</h3><pre>Post.query.filter(Post.author.<strong>in_</strong>([&#39;<strong>John</strong>&#39;, &#39;<strong>James</strong>&#39;, &#39;<strong>Robert</strong>&#39;]))</pre><h3>NOT IN:</h3><pre>Post.query.filter(<strong>~</strong>Post.author.<strong>in_</strong>([&#39;<strong>Lee</strong>&#39;, &#39;<strong>James</strong>&#39;, &#39;<strong>Robert</strong>&#39;]))</pre><h3>IS NULL:</h3><pre>Post.query.filter(Post.author == <strong>None</strong>)</pre><h3>IS NOT NULL:</h3><pre>Post.query.filter(Post.author <strong>!=</strong> None)</pre><h3>AND:</h3><pre>from sqlalchemy import and_</pre><pre>Post.query.filter(and_(Post.author == &#39;James&#39;, Post.id == 1))</pre><p>You can write different style with comma separated</p><pre>Post.query.filter(Post.author == &#39;James&#39;, Post.id == 1)</pre><p>or call filter() multiple time</p><pre>Post.query.filter(Post.author == &#39;James&#39;).\<br>           filter(User.id.in_([1,2,3])</pre><h3>OR:</h3><pre>from sqlalchemy import or_<br>Post.query.filter(<br>      or_(Post.author == &#39;<strong>James</strong>&#39;, Post.author == &#39;<strong>Robert</strong>&#39;)<br>  )</pre><h3>match:</h3><pre>Post.query.filter(Post.title.match(&#39;python lesson&#39;))</pre><p>I’m sure, the information above will be useful for you. But there are hundreds of other creative people whom it might be useful for as well. So Clap! Clap! :)👏🏼</p><p>I usually post on Twitter before publishing on Medium, so if you want to stay updated, follow me on</p><p><strong>Twitter/X at </strong><a href="https://x.com/rimsovankiry"><strong>https://x.com/rimsovankiry</strong></a></p><p><strong>if you interested for free money (airdrop reward), passive income</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*vGO24WnLXQasI1eH" /><figcaption>Photo by <a href="https://unsplash.com/@kanchanara?utm_source=medium&amp;utm_medium=referral">Kanchanara</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h4>Pls also join my telegram channel about project update.</h4><h3>Airdrop Army Premium — Invite only</h3><p><a href="https://t.me/+kYBpSchCCSxmNjg1">https://t.me/+kYBpSchCCSxmNjg1</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c7adbd3321a6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Python 3 Migrating Process]]></title>
            <link>https://rimsovankiry.medium.com/python-3-migrating-process-8466765ba055?source=rss-bfd21c2843dd------2</link>
            <guid isPermaLink="false">https://medium.com/p/8466765ba055</guid>
            <category><![CDATA[python3]]></category>
            <category><![CDATA[migration]]></category>
            <category><![CDATA[automation-tools]]></category>
            <category><![CDATA[python27]]></category>
            <category><![CDATA[flask]]></category>
            <dc:creator><![CDATA[rimsovankiry]]></dc:creator>
            <pubDate>Wed, 10 Mar 2021 09:45:41 GMT</pubDate>
            <atom:updated>2025-10-20T04:47:52.490Z</atom:updated>
            <content:encoded><![CDATA[<h3>Simple Python 2 to Python 3 Project Upgrade Automation</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*g51J-D4lj9NcmzOkt1hUPg.png" /><figcaption>Upgrade Application Python 2 to Python 3 With Migration Process</figcaption></figure><h3><strong>Introduction</strong></h3><p>This article will briefly guide you through the process you need to know to migrate your application code from Python 2 to Python 3. Throughout this document I divide it into three parts: one is migration using tool here we will use <a href="https://python-modernize.readthedocs.io/en/latest/">Python-Modernize</a>, then part two we will manually fix some code where the existing code does not work well with python 3. Finally, part three we will update our existing dependencies version in order for it to work with Python 3.</p><p>After the end of this document, you will be able to understand and do the migration process to work with python 3 yourself.</p><h3><strong>Part I — Setup Development Environment</strong></h3><p>Before you begin, make sure you have set up the development environment already.</p><h4>Install Python version 3 — Mac</h4><p>Throughout the process we will be working with python 3. So make sure you have installed it ready.</p><pre>$ brew install pyenv</pre><pre>$ brew update &amp;&amp; brew upgrade pyenv</pre><pre>$ pyenv install 3.10</pre><pre>$ pyenv local 3.10</pre><h4>Clone your project and activate virtual environment with python 3</h4><ol><li>Clone the application project from git hub repository.</li><li>Outside Project Directory, Create virtual environment with python 3:</li></ol><pre>$ virtualenv -p python3 venv3<br><strong><em>or</em></strong><br>$ python3 -m venv venv</pre><p>3. Activate virtual environment and Pip install requirement.txt</p><pre>$ pip install -r requirements.txt</pre><h4>Running Migration with Python-Modernize</h4><p>Python-Modernize tool helps us to automate common most of Python 2 code to work compatible with Python 3 where we would manually do a lot of stuff without it, to understand more detail please refer to its <a href="https://python-modernize.readthedocs.io/en/latest/">document here</a>.</p><p>Following steps show you how to install python-modernize and use it to automate your code:</p><ol><li>Fire up the terminal and enter:</li></ol><pre>$ pip install modernize</pre><p>2. Now inside root of project folder, type command line</p><pre>$ <strong>python-modernize -w .</strong></pre><p>it will take a few moments to complete.</p><pre>$ python -m modernize -w app/example.py</pre><h3>Part II — Manual Fix code</h3><p>Tool helps us automate some of the common code issues in Python 2 to support with Python 3, however, there are some more we need to manually do.</p><h4>TabError: inconsistent use of tabs and spaces in indentation</h4><p>Using mix tabs and spaces is fine in Python 2 but not in Python 3. There are many files with this problem, to fix this we use autopep8</p><pre>$ pip install autopep8<br>$ autopep8 -i app/*.py</pre><p>More details about <a href="https://pypi.org/project/autopep8/">autopep8</a></p><h4>SyntaxError: from __future__ imports must occur at the beginning of the file</h4><p>To fix this issue, open file the error file in import statement block, move from __future__ import print_function to the top of every import statement.</p><h4>NameError: name ‘reload’ is not defined</h4><p>To fix this problem, navigate to file Python and change in import statement from</p><pre>reload(sys)<br>sys.setdefaultencoding(&#39;utf8&#39;)</pre><p>To</p><pre>if sys.version_info[0] == 2:<br>    reload(sys)<br>    sys.setdefaultencoding(&#39;utf8&#39;)<br><strong>else</strong>:<br>    <strong>import</strong> importlib<br>    importlib.reload(sys)</pre><h4>ModuleNotFoundError: No module named ‘StringIO’</h4><p>There are several files with this issue, to fix this issue, open a file and change from</p><pre>import StringIO</pre><p>To</p><pre>try:<br>    <strong>import</strong> StringIO ## for Python 2<br><strong>except</strong> ImportError:<br>    <strong>from</strong> io <strong>import</strong> StringIO ## for Python 3</pre><h4>AttributeError: ‘bytes’ object has no attribute ‘encode’</h4><p>This issue happen when variable of string call method encode of UTF-8, In the Python 3 string is Unicode by default. Let’s an error example</p><pre># Python 2 is work fine but it will error on Python 3</pre><pre><strong>generate_key_hex</strong>  = os.urandom(24).encode(&#39;hex&#39;)</pre><p>To</p><pre><strong>generate_key_hex</strong>  = os.urandom(24)</pre><h4>Fix try/except</h4><p>Open file Python in exception block of try/except, we need to convert exception variable to string like this</p><pre><strong>try:<br>....</strong><br><strong>except</strong> Exception <strong>as</strong> e:<br>    flash(e.message)</pre><p>To</p><pre><strong>try:<br>....</strong><br><strong>except</strong> Exception <strong>as</strong> e:<br>    flash(str(e))</pre><p>Do the same for every occurrence <strong>try</strong>/<strong>except</strong> instances and update them like above.</p><h4>AttributeError(“type object ‘_io.StringIO’ has no attribute ‘StringIO’”,</h4><p>Fix this by open file mkt/Upload/exportimport.py find and change like variable like this</p><pre>StrIO = StringIO.StringIO()</pre><p>To</p><pre>from io import StringIO ## for Python 3</pre><pre>StrIO = StringIO()</pre><h4>ImportError: cannot import name secure_filename from werkzeug</h4><p>This error happened after you process updating dependencies as below, so it is good to fix it before it occurs.</p><p>Change from</p><pre><strong>from</strong> werkzeug <strong>import</strong> secure_filename</pre><p>To</p><pre><strong>from</strong> werkzeug.utils <strong>import</strong> secure_filename</pre><h4>Division issue</h4><p>You will got the error as “TypeError: integer argument expected, got float”.</p><p>Explain: In Python 3, `/` return float so for it to return int, we use `//` instead. Fix: to fix this issue, open your file and update function <strong>or code to </strong>double // as following:</p><h3>Part III — Update Dependency</h3><p>In Python 3, you need to update some existing dependencies otherwise you will meet an error.</p><p>Following command line to update dependencies:</p><pre>$ pip install -U SQLAlchemy<br>$ pip install -U WTForms==2.2.1<br>$ pip install -U Flask<br>$ pip install -U Flask-SQLAlchemy</pre><p>After this update, you need to replace old style of sqlalchemy <strong>import</strong> <strong>from</strong> flask.ext.module to flask_module</p><p>For example:</p><pre><strong>from</strong> flask.ext.login <strong>import</strong> LoginManager, login_user, logout_user, current_user, login_required</pre><p>To</p><pre><strong>from</strong> flask_login <strong>import</strong> LoginManager, login_user, logout_user, current_user, login_required</pre><h4>Using pip-ugrader tool</h4><p>Instead of manually upgrading every package dependencies manually, you can use pip-upgrader tool to help you upgrade dependencies to the latest version. First you need to install pip-upgrader tool from github repository <a href="https://github.com/simion/pip-upgrader">here</a>.</p><p>After that, please these following steps to update our requirements dependencies:</p><pre>$ pip install pip-upgrader</pre><p>cd to directory that has file requirements.txt and run command:</p><pre>$ pip-upgrade</pre><p>Then, you should see output in terminal as this:</p><pre>requirements.txt<br>1/22: Flask ... upgrade available: 0.10.1 ==&gt; 1.1.2 (uploaded on 2020-04-03 17:17:53)<br>2/22: Flask-SQLAlchemy ... upgrade available: 2.0 ==&gt; 2.4.4 (uploaded on 2020-07-14 16:42:15)<br>3/22: Werkzeug ... upgrade available: 0.10.4 ==&gt; 1.0.1 (uploaded on 2020-03-31 18:03:34)<br>17/22: flask-json-multidict ... up to date: 1.0.0<br>18/22: beautifulsoup4 ... upgrade available: 4.6.0 ==&gt; 4.9.1 (uploaded on 2020-05-17 18:24:02)</pre><pre>....</pre><pre>20/22: flask-accept ... upgrade available: 0.0.5 ==&gt; 0.0.6 (uploaded on 2018-06-27 14:30:56)<br>21/22: twilio ... upgrade available: 6.16.4 ==&gt; 6.44.0 (uploaded on 2020-07-08 19:01:02)<br>22/22: Flask-Mail ... up to date: 0.9.1</pre><pre>Available upgrades:<br>+------+--------------------+-----------------+----------------+---------------------+<br>| No.  | Package            | Current version | Latest version | Release date        |<br>+------+--------------------+-----------------+----------------+---------------------+<br>|  1   |  Flask             | 0.10.1          | 1.1.2          | 2020-04-03 17:17:53 |<br>|  2   |  Flask-SQLAlchemy  | 2.0             | 2.4.4          | 2020-07-14 16:42:15 |<br>|  3   |  Werkzeug          | 0.10.4          | 1.0.1          | 2020-03-31 18:03:34 |<br>|  4   |  Flask-Login       | 0.2.11          | 0.5.0          | 2020-02-09 16:55:42 |<br>|  5   |  Jinja2            | 2.7.3           | 2.11.2         | 2020-04-13 16:16:44 |<br>|  6   |  Python-dateutil   | 2.4.2           | 2.8.1          | 2019-11-03 05:42:01 |<br>|  7   |  SQLAlchemy        | 0.9.9           | 1.3.18         | 2020-06-25 19:04:05 |<br>|  8   |  WTForms           | 2.0.2           | 2.3.1          | 2020-04-22 16:34:30 |</pre><pre>2020-07-09 19:25:33 |<br>|  18  |  flask-accept      | 0.0.5            | 0.0.6          | 2018-06-27 14:30:56 |<br>|  19  |  twilio            | 6.16.4          | 6.44.0         | 2020-07-08 19:01:02 |<br>+------+--------------------+-----------------+----------------+---------------------+<br><br>Please choose which packages should be upgraded. Choices: &quot;<strong>all</strong>&quot;, &quot;<strong>q</strong>&quot;</pre><pre>(quit), &quot;x&quot; (exit) or &quot;1 2 3&quot;</pre><p>Type “all” and press enter to start updating all dependencies in file requirements.txt.</p><p>Having completed all above steps, your project should be using the latest version of dependencies as well as in your project requirements.txt.</p><h3>IV. Conclusion</h3><p>If you followed all of the steps correctly, you should be able to run your Project in Python 3, here we use Python version 3.8.3. you might experience some other errors unexpectedly after upgraded.</p><p>Finally I’m sure, the information above will be useful for you. But there are hundreds of other creative people whom it might be useful for as well.</p><p>So Clap! Clap! :)👏🏼</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8466765ba055" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Install and Configure Apache as Reverse Proxy for Jenkins]]></title>
            <link>https://rimsovankiry.medium.com/install-and-configure-apache-as-reverse-proxy-for-jenkins-3fb860924a53?source=rss-bfd21c2843dd------2</link>
            <guid isPermaLink="false">https://medium.com/p/3fb860924a53</guid>
            <category><![CDATA[apache]]></category>
            <category><![CDATA[ssl-certificate]]></category>
            <category><![CDATA[jenkins]]></category>
            <category><![CDATA[reverse-proxy]]></category>
            <dc:creator><![CDATA[rimsovankiry]]></dc:creator>
            <pubDate>Sun, 07 Mar 2021 16:32:15 GMT</pubDate>
            <atom:updated>2021-03-07T16:37:21.608Z</atom:updated>
            <content:encoded><![CDATA[<p>My previous article is install Jenkins on Ubuntu server and running on default port 8080 , Now let’s upgrade it to HTTPS protocol or you say port 443 by using reverse proxy.</p><h3>Step 1: Install apache2 on server</h3><p>I am going install apache2 web server from Ubuntu repository.</p><pre><strong>$</strong> sudo apt-get install apache2</pre><p>When the installation is done, enable the proxy and proxy_http modules so we can configure Apache as fronted server/reverse proxy for Jenkins.</p><pre><strong>$</strong> a2enmod proxy<br><strong>$</strong> a2enmod proxy_http<br><strong>$</strong> a2enmod rewrite</pre><h3>Step 2: Create virtual host file conf</h3><p>Next, create a new virtual host file in the sites-available directory.</p><pre><strong>$</strong> nano /etc/apache2/sites-available/jenkins-ssl.conf</pre><p>Copy and Paste virtual host configuration below.</p><pre>&lt;IfModule mod_ssl.c&gt;<br>    &lt;VirtualHost *:443&gt;<br>        ServerAdmin webmaster@localhost<br><br>        ServerName        <strong>jenkins.mydomain.com</strong><br>        ProxyRequests     Off<br>        ProxyPreserveHost On<br>        AllowEncodedSlashes NoDecode<br><br>        &lt;Proxy *&gt;<br>              Order deny,allow<br>              Allow from all<br>        &lt;/Proxy&gt;<br><br>        ProxyPass         /  http://localhost:8081/ nocanon<br>        ProxyPassReverse  /  http://localhost:8081/<br>        ProxyPassReverse  /  http://<strong>jenkins.mydomain.com</strong>/<br>        RequestHeader set X-Forwarded-Proto &quot;https&quot;<br>        RequestHeader set X-Forwarded-Port &quot;443&quot;<br><br>        # Redirect http to https<br>        RewriteEngine On<br>        RewriteCond %{HTTPS} off [OR]<br>        RewriteCond %{HTTP_HOST} ^www\. [NC]<br>        RewriteCond %{HTTP_HOST} ^(?:www\.)?(.+)$ [NC]<br>        RewriteRule ^ https://%1%{REQUEST_URI} [L,NE,R=301]<br>    <br>        #LogLevel info ssl:warn<br><br>        ErrorLog ${APACHE_LOG_DIR}/error.log<br>        CustomLog ${APACHE_LOG_DIR}/access.log combined<br><br>        #   SSL Engine Switch:<br>        SSLEngine on<br><br>        #   A self-signed (snakeoil) certificate can be created by installing<br>        #   SSLCertificateFile directive is needed.<br>        <br>        <strong>SSLCertificateFile    /etc/ssl/certs/ssl-cert-snakeoil.pem<br>        SSLCertificateKeyFile /etc/ssl/private/ssl-cert-snakeoil.key<br>        </strong><br>       <br>        &lt;FilesMatch &quot;\.(cgi|shtml|phtml|php)$&quot;&gt;<br>                SSLOptions +StdEnvVars<br>        &lt;/FilesMatch&gt;<br>        &lt;Directory /usr/lib/cgi-bin&gt;<br>                SSLOptions +StdEnvVars<br>        &lt;/Directory&gt;<br><br>       <br>    &lt;/VirtualHost&gt;<br>&lt;/IfModule&gt;</pre><p>Save the file.</p><h3>Step 3: Enable sites-available</h3><p>Then activate the Jenkins virtual host with the a2ensite command.</p><pre><strong>$</strong> a2ensite jenkins</pre><h3>Final Step: Update configuration of Jekins</h3><p>change the JenkinshttpListenAddress from its default of 0.0.0.0 to 127.0.0.1</p><pre><strong>$</strong> nano /etc/default/jenkins</pre><p>add the following line somewhere:</p><pre>HTTP_HOST=127.0.0.1</pre><p>Scroll down to find JENKINS_ARGS to add --httpListenAddress=$HTTP_HOST</p><pre>JENKINS_ARGS=&quot;--webroot=/var/cache/$NAME/war --httpPort=$HTTP_PORT --httpListenAddress=$HTTP_HOST&quot;</pre><p>Restart Apache and Jenkins.</p><pre><strong>$</strong> systemctl restart apache2<br><strong>$</strong> systemctl restart jenkins</pre><h3>In conclusion</h3><p>I’m sure, the information above will be useful for you. But there are hundreds of other creative people whom it might be useful for as well. So Clap! Clap! :)👏🏼</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3fb860924a53" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to redirect http to https on Apache2]]></title>
            <link>https://rimsovankiry.medium.com/how-to-redirect-http-to-https-on-apache2-a7454b32b026?source=rss-bfd21c2843dd------2</link>
            <guid isPermaLink="false">https://medium.com/p/a7454b32b026</guid>
            <category><![CDATA[apache2]]></category>
            <category><![CDATA[redirect]]></category>
            <category><![CDATA[https]]></category>
            <dc:creator><![CDATA[rimsovankiry]]></dc:creator>
            <pubDate>Sun, 07 Mar 2021 16:07:47 GMT</pubDate>
            <atom:updated>2021-03-10T13:07:05.324Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NtqxpvomiStxJzDtuk-jyw.png" /><figcaption>Redirect HTTP To HTTPS</figcaption></figure><p>This is my favorite snippet code in Apche2 for redirect http protocol to https protocol. There are only two steps for completed this.</p><h3>Step 1: Enable a2enmod rewrite</h3><p>Assume, you are in terminal of server and logged as root permission</p><pre><strong>$</strong> a2enmod rewrite</pre><h3>Step 2: Update sites-available conf file</h3><p>Assume that my site conf file is default-ssl.conf, you can change to your actual conf file of sites-available.</p><pre><strong>$</strong> nano /etc/apache2/sites-available/default-ssl.conf</pre><p>Copy this code to the last of files</p><pre>     RewriteEngine On<br>     RewriteCond %{HTTPS} off [OR]<br>     RewriteCond %{HTTP_HOST} ^www\. [NC]<br>     RewriteCond %{HTTP_HOST} ^(?:www\.)?(.+)$ [NC]<br>     RewriteRule ^ https://%1%{REQUEST_URI} [L,NE,R=301]</pre><p>Than save files and restart service apache2.</p><pre>$ sudo service apache2 restart</pre><h3>Conclusion</h3><p>In this article, you’ve setup redirect http to https by using a2enmode rewrite.</p><blockquote>Don’t forget click Clap to help hundreds of other creative people whom it might be useful for as well. So Clap! Clap! :)👏🏼</blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a7454b32b026" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How To Install Jenkins on Ubuntu 16.04 LTS]]></title>
            <link>https://rimsovankiry.medium.com/how-to-install-jenkins-on-ubuntu-16-04-lts-90eb21484ba2?source=rss-bfd21c2843dd------2</link>
            <guid isPermaLink="false">https://medium.com/p/90eb21484ba2</guid>
            <category><![CDATA[administration]]></category>
            <category><![CDATA[ubuntu-18-04]]></category>
            <category><![CDATA[jenkins]]></category>
            <category><![CDATA[devops]]></category>
            <category><![CDATA[ubuntu]]></category>
            <dc:creator><![CDATA[rimsovankiry]]></dc:creator>
            <pubDate>Sun, 07 Mar 2021 15:46:20 GMT</pubDate>
            <atom:updated>2021-03-10T13:47:05.364Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1qP-71V5ler20mMQUeaHqg.png" /><figcaption>Install Jenkins on Ubuntu</figcaption></figure><p>As my assume you are System administrator or DevOps guy to read my article to install Jenkins on Ubuntu, I will summary step by step and straight to the point just copy and paste.</p><p><strong><em>Warning</em></strong>: Do not skip any step, you will get an error. To resolve it reset step again and follow one by one.</p><h3>Step 1: Installing Jenkins</h3><p>First, we’ll add the repository key to the system.</p><pre><strong>$</strong> wget -q -O - <a href="https://pkg.jenkins.io/debian/jenkins-ci.org.key">https://pkg.jenkins.io/debian/jenkins-ci.org.key</a> | sudo apt-key add -</pre><p>When the key is added, the system will return OK. Next, we’ll append the Debian package repository address to the server’s sources.list:</p><pre><strong>$</strong> echo deb <a href="http://pkg.jenkins.io/debian-stable">http://pkg.jenkins.io/debian-stable</a> binary/ | sudo tee /etc/apt/sources.list.d/jenkins.list</pre><p>When both of these are in place, we’ll run update so that apt-get will use the new repository:</p><pre><strong>$</strong> sudo apt-get update</pre><p>Finally, we’ll install Jenkins and its dependencies, including Java:</p><pre><strong>$</strong> sudo apt-get install jenkins</pre><p>Now that Jenkins and its dependencies are in place, we’ll start the Jenkins server.</p><h3>Step 2 : Starting Jenkins</h3><p>Using systemctl we’ll start Jenkins:</p><pre><strong>$</strong> sudo systemctl start jenkins</pre><p>Since systemctl doesn’t display output, we’ll use its status command to verify that it started successfully:</p><pre><strong>$</strong> sudo systemctl status jenkins</pre><p>If everything went well, the beginning of the output should show that the service is active and configured to start at boot:</p><pre>Output<br>● jenkins.service - LSB: Start Jenkins at boot time<br>  Loaded: loaded (/etc/init.d/jenkins; bad; vendor preset: enabled)<br>  Active:active (exited) since Thu 2021-02-20 16:51:13 UTC; 2min 7s ago<br>    Docs: man:systemd-sysv-generator(8)</pre><p>Now that Jenkins is running, we’ll adjust our firewall rules so that we can reach Jenkins from a web browser to complete the initial set up.</p><h3>Step 3 : Opening the Firewall</h3><p>By default, Jenkins runs on port 8080, so we’ll open that port using ufw:</p><pre><strong>$</strong> sudo ufw allow 8080</pre><p>We can see the new rules by checking UFW’s status.</p><pre><strong>$</strong> sudo ufw status</pre><p>We should see that traffic is allowed to port 8080 from anywhere:</p><pre>Output<br>Status: active</pre><pre>To                         Action      From<br>--                         ------      ----<br>OpenSSH                    ALLOW       Anywhere<br>8080                       ALLOW       Anywhere<br>OpenSSH (v6)               ALLOW       Anywhere (v6)<br>8080 (v6)                  ALLOW       Anywhere (v6)</pre><h3>Step 4 : Setting up Jenkins</h3><p>To set up our installation, we’ll visit Jenkins on its default port, 8080, using the server domain name or IP address: <a href="http://ip_address_or_domain_name:8080/">http://ip_address_or_domain_name:8080</a></p><p>We should see “Unlock Jenkins” screen, which displays the location of the initial password</p><p>You need to to copy admin password in file initialAdminPassword</p><pre>$ sudo cat /var/lib/jenkins/secrets/initialAdminPassword</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*vI7ZYHwvEluNzKso.png" /><figcaption>Getting Started Jenkins — Unlock Screen</figcaption></figure><p>Copy the 32-character alphanumeric password from the terminal and paste it into the “Administrator password” field, then click “Continue”. The next screen presents the option of installing suggested plugins or selecting specific plugins.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*p4HxRA3P3UypuHsV.png" /><figcaption>Customize Jenkins Plugin — Install suggested plugins</figcaption></figure><p>Click Install suggested plugins option, which will immediately begin the installation process:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*jdIMxfBVJoTxr01J.png" /><figcaption>Install Plugin Jenkins</figcaption></figure><p>When the installation is complete, we’ll be prompted to set up the first administrative user. It’s possible to skip this step and continue as admin using the initial password we used above, but we’ll take a moment to create the user.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*XEt-al6fhdl8zMO5.png" /><figcaption>Admin user setup of Jenkins</figcaption></figure><p>Once the first admin user is in place, you should see a “Jenkins is ready!” confirmation screen.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*UurhL-rqHHS4PJZs.png" /><figcaption>Jenkins is ready! — you can start using it.</figcaption></figure><p>Click Start using Jenkins to visit the main Jenkins dashboard:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*2U3uuzw7qzlh6zk4.png" /></figure><p>At this point, Jenkins has been successfully installed.</p><p>I’m sure, the information above will be useful for you. But there are hundreds of other creative people whom it might be useful for as well. So Clap! Clap! :)👏🏼</p><h3>Conclusion</h3><p>In this article, you’ve installed Jenkins using the project-provided packages, started the server, opened the firewall, and created an administrative user. At this point, you can start exploring Jenkins.</p><p>I recommended you to upgrade HTTP protocol to SSL for protect passwords, as well as any sensitive system or product information that will be sent between your machine and the server in plain text.</p><p>I will write two articles which one use Apache2 web server as reverse proxy for Jenkins and Using Nginx Reverse Proxy. you can choose which one is your familiar.</p><ul><li><a href="https://rimsovankiry.medium.com/install-and-configure-apache-as-reverse-proxy-for-jenkins-3fb860924a53?sk=23df33053ecf3103e6b3c99e9f8784f6">Install and Configure Apache as Reverse Proxy for Jenkins</a></li></ul><blockquote>Don’t forget click Clap to help hundreds of other creative people whom it might be useful for as well. So Clap! Clap! :)👏🏼</blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=90eb21484ba2" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The data directory contains an unreadable postmaster.pid file on PostgreSQL 12 | Mac OS]]></title>
            <link>https://rimsovankiry.medium.com/the-data-directory-contains-an-unreadable-postmaster-pid-file-on-postgresql-12-mac-os-54775a641160?source=rss-bfd21c2843dd------2</link>
            <guid isPermaLink="false">https://medium.com/p/54775a641160</guid>
            <category><![CDATA[postgresql12]]></category>
            <category><![CDATA[postmaster]]></category>
            <category><![CDATA[mac]]></category>
            <category><![CDATA[postgresql]]></category>
            <category><![CDATA[postgres-app]]></category>
            <dc:creator><![CDATA[rimsovankiry]]></dc:creator>
            <pubDate>Fri, 28 Aug 2020 04:26:56 GMT</pubDate>
            <atom:updated>2020-08-28T04:26:56.851Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/502/1*a8vazziKqAGfX1FGObH95Q.png" /><figcaption>Postgres.app icon</figcaption></figure><h3>Common errors on Postgres.app</h3><p>The data directory contains an old postmaster.pid file / The data directory contains an unreadable postmaster.pid file</p><h4>Reason</h4><p>PostgreSQL puts a file named postmaster.pid in the data directory to store the process id of the PostgreSQL server process. If PostgreSQL crashes, this file can contain an old pid that confuses PostgreSQL. You can fix this issue by deleting the postmaster.pid file. However, you must make sure that PostgreSQL is really not running. Open Activity Monitor and make sure that there are no processes named ‘postgres’ or ‘postmaster’.</p><p>If you delete the postmaster.pid file while PostgreSQL is running, bad things will happen. Let’s start fixes it by following step by step</p><h4>Step 1 : Find Postgres directory with your current version</h4><p>Open your terminal and make sure you’re in the home directory.</p><p><em>PostgreSQL version 12</em></p><pre>$ cd ~/Library/Application\ Support/Postgres/var-12</pre><p><em>or PostgreSQL version 11</em></p><pre>$ cd ~/Library/Application\ Support/Postgres/var-11</pre><h4>Step 2: Delete the postmater.pid file</h4><p>The last step is to remove the postmaster.pid file.If PostgreSQL crashes, this file can contain an old pid that confuses PostgreSQL. You can fix this issue by deleting the postmaster.pid file. However, you must make sure that PostgreSQL is really not running.</p><pre>$ rm -f postmaster.pid</pre><h4>Final step: Restart services the Postgres</h4><p>You can right click on icon Postgres.app on toolbar with quit or follow by command line</p><pre>$ pg_ctl -D /usr/local/var/postgres restart</pre><pre>waiting for server to shut down.... done<br>server stopped<br>waiting for server to start.....2020-08-28 11:21:42.654 +07 [21151] LOG:  starting PostgreSQL 12.2 on x86_64-apple-darwin18.7.0, compiled by Apple clang version 11.0.0 (clang-1100.0.33.17), 64-bit<br>2020-08-28 11:21:42.661 +07 [21151] LOG:  listening on IPv6 address &quot;::1&quot;, port 5432<br>2020-08-28 11:21:42.661 +07 [21151] LOG:  listening on IPv4 address &quot;127.0.0.1&quot;, port 5432<br>2020-08-28 11:21:42.662 +07 [21151] LOG:  listening on Unix socket &quot;/tmp/.s.PGSQL.5432&quot;<br>2020-08-28 11:21:42.809 +07 [21152] LOG:  database system was shut down at 2020-08-28 11:21:40 +07<br>2020-08-28 11:21:42.830 +07 [21151] LOG:  database system is ready to accept connections<br> done<br>server started</pre><h4>In conclusion</h4><p>I’m sure, the information above will be useful for you. But there are hundreds of other creative people whom it might be useful for as well. So Clap! Clap! :)👏🏼</p><h4>Reference</h4><p><a href="https://postgresapp.com/documentation/troubleshooting.html">https://postgresapp.com/documentation/troubleshooting.html</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=54775a641160" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>