Microsoft Office 365 for Free Education

    Posted in Microsoft Office 365 on Jul 02, 2020

    Get started with Microsoft Office 365 for Free Education

    Microsoft office for Students and educators at eligible institutions can sign up for Office 365 in India Education for free, including Word, Excel, PowerPoint, OneNote, and now Microsoft Teams, plus additional classroom tools. Use your valid school email address to get started today. Free Microsoft Office 365 for Students & Schools .

    Powerful tools for students and educators

    Microsoft Office 365 works like you: everywhere. Familiar applications and always-accessible files update in real time to make building your curriculum seamless and...

    [Read more...]

    Buy cheap tally on cloud server with WAH application

    Posted in Windows Servers on May 29, 2020

    Buy cheap and fully managed tally on cloud server in india @ 3000/- Monthly Order Now

    Tally on cloud in India - Cloudtechtiq starts offering the new windows cloud servers as per the market research and demands in COVID situations. Now all the companies facing challenges in their regular work process from home with employees. We made a solution for the organization that wants to work from home with secured data and easy access called WAH.

    Wah- is known as Work at home small applications that we can deploy on windows cloud servers in India. Wah, provide the following features.

    User Management :...[Read more...]

    Installing and Configuring Pure-FTPD on RHEL / CentOS 7

    Posted in Linux Servers on Apr 08, 2020

    Step 1: When you are ready to begin, go ahead and install Pure-FTPD using yum on server.

    yum install pure-ftpd

    Step 2: after installation Edit the default configuration (/etc/pure-ftpd/pure-ftpd.conf) and uncommnet the following lines.

    PAMAuthentication yes
    
    PureDB /etc/pure-ftpd/pureftpd.pdb

    Save and close the file.

    Step 3: Configure Service pure-ftp service

    systemctl enable pure-ftpd
    
    systemctl start pure-ftpd

    Step 4: Create a new ftp user account for website account using pure-pw.

    pure-pw useradd $USERNAME -u $USER -g $GROUP -d /path/to/ftp/directory
    
    For Exmaple :  pure-pw useradd rajesh ...
    [Read more...]

    How to install Qemu-guest-agent on Proxmox Windows VM

    Posted in Windows Servers on Mar 18, 2020

    The Qemu-guest-agent is a helper daemon, which is installed in the guest. It is used to exchange information between the host and guest, and to execute command in the guest.

    In Proxmox VE, the Qemu-guest-agent is used for mainly two things:

    1. To properly shutdown the guest, instead of relying on ACPI commands or windows policies
    2. To check the server IP on console section (Public and private both IPs)

    Installation

    In installation of Qemu-Guest-agent we need to install Host and guest installer

    Install Host Installer

    Host insatller can be install via GUI or CLI both method

    Via GUI-

    You have to ena...

    [Read more...]

    How to install Mongo Db server in windows server

    Posted in Windows Servers on Feb 13, 2020

    First, download the mongo database MSI installer:

    https://www.cloudtechtiq.com/storage/app/media/mongodb-win32-x86_64-2008plus-3.4.24-signed.msi

    After download the msi installer, double click on it:

    rrr1.png

    Accept the user license agreement:

    rrr2.png

    Ready to install mongo ddb 3.4 with complete setup click on install now:

    rrr3.png

    To access mongo via GUI you can install the MongoDB Compass Community on server.

    You can create the custom configuration file while using the following methods:

    1. Create the data and log Directories via cmd method.

       mkdir c:\data\db
       mkdir c:\data\log
    2. Create the configuration file for ex...

    [Read more...]

    How to backup and restore the mongo database on server in windows server

    Posted in Windows Servers on Feb 13, 2020

    How to generate the Mongo DB Backup on windows server

    Go to the mongo executable file path and run the command for take dB dump:

    mongodump.exe --host localhost --port [dB authentication port]  --db [DB name] --username [user name]--password [Password] --out [backup path ]
    
    For example:  mongodump.exe --host localhost --port 35615  --db clt --username cloudtechtiq --password abcd@123 --out D:\Backup\clt13022020

    rrr7.png

    How to restore the Mongo db backup on windows server

    Go to the mongo executable file path and run the command for restore database:

    mongorestore --host localhost --port [authentication ...
    [Read more...]

    how to create user on Mongo Db in windows server

    Posted in Windows Servers on Feb 13, 2020

    Login on the power shell v with dB authentication or without

    For example: $ mongo superadmin -u [Username] -p [Password] --port=35615

    rrr4.png

    Run the following command for user creation:

    rrr5.png

    > use CloudTechtiq     (CloudTechtiq is the dB name on which you assigned the user)
    > db.createUser(
    {
    user: "appuser",
    pwd: "EwQDP4x",
    roles: [ "readWrite", "dbAdmin" ]
    }
    )

    Note: appuser (user name which one you want to define) EwQDP4x (password for user) dbAdmin (User role for database)

    If you want to give the full access of dB server, you can change the role to Root .

    [Read more...]

    Restoring deleted 'root' user and password for MySQL

    Posted in Linux Servers on Nov 08, 2019

    If you accidentally deleted the root user on my local setup MySQL running on OS linux. There are no other users created to get back into MySQL. I am sharing solution for the recover the root user. Get someone with SysAdmin rights and do the following:

    1. Add 'skip-grant-tables' to my.cnf under the [mysqld] section
    2. restart mysql
    3. type mysql with no password and hit enter
    4. Run This:
    DELETE FROM mysql.user 
    WHERE  user = 'root' 
          AND host = 'localhost'; 
    
    INSERT INTO mysql.user 
    SET user = 'root', 
        host = 'localhost', 
        password = Password('whatevernewpassword'), 
        Select_priv = 'y',
    ...
    [Read more...]

    How to Reset MySQL or MariaDB Root Password in Linux

    Posted in Linux Servers on Nov 08, 2019

    One of these settings is the password for the database root account – which you must keep private and use only when strictly required.

    If you forget the password or need to reset it (for example, when a database administrator changes roles – or is laid off!).

    This article will come in handy. We will explain how to reset or recover forgottent MySQL or MariaDB root password in Linux.

    Although we will use a MariaDB server in this article, the instructions should work for MySQL as well.

    To begin, stop the database service and check the service status, we should see the environment variable we set...

    [Read more...]