Ubuntu 22.04 – My Projects & Live

Install Ollama and DeepSeek On Ubuntu 22.04

Ref: https://ollama.com/download

Select the linux then Install on your terminal with this command:
curl -fsSL https://ollama.com/install.sh | sh

[codesyntax lang=”bash”]

~$ curl -fsSL https://ollama.com/install.sh | sh
&gt;&gt;&gt; Installing ollama to /usr/local
[sudo] password for satria: 
&gt;&gt;&gt; Downloading Linux amd64 bundle
######################################################################## 100,0%
&gt;&gt;&gt; Creating ollama user...
&gt;&gt;&gt; Adding ollama user to render group...
&gt;&gt;&gt; Adding ollama user to video group...
&gt;&gt;&gt; Adding current user to ollama group...
&gt;&gt;&gt; Creating ollama systemd service...
&gt;&gt;&gt; Enabling and starting ollama service...
Created symlink /etc/systemd/system/default.target.wants/ollama.service → /etc/systemd/system/ollama.service.
&gt;&gt;&gt; The Ollama API is now available at 127.0.0.1:11434.
&gt;&gt;&gt; Install complete. Run "ollama" from the command line.
WARNING: No NVIDIA/AMD GPU detected. Ollama will run in CPU-only mode.

~$ curl -fsSL https://ollama.com/install.sh | sh

>>> Installing ollama to /usr/local

[sudo] password for satria:

>>> Downloading Linux amd64 bundle

######################################################################## 100,0%

>>> Creating ollama user...

>>> Adding ollama user to render group...

>>> Adding ollama user to video group...

>>> Adding current user to ollama group...

>>> Creating ollama systemd service...

>>> Enabling and starting ollama service...

Created symlink /etc/systemd/system/default.target.wants/ollama.service → /etc/systemd/system/ollama.service.

>>> The Ollama API is now available at 127.0.0.1:11434.

>>> Install complete. Run "ollama" from the command line.

WARNING: No NVIDIA/AMD GPU detected. Ollama will run in CPU-only mode.

[/codesyntax]

on the search model text box, select ‘deepseek-r1’ or go to https://ollama.com/library/deepseek-r1
Okay. I just choose ‘1.5b’ model as a test. then install it on your terminal with this command:
ollama run deepseek-r1:1.5b

[codesyntax lang=”bash”]

satria@teddy:~$ ollama run deepseek-r1:1.5b
pulling manifest 
pulling aabd4debf0c8... 100% ▕████████████████▏ 1.1 GB                         
pulling 369ca498f347... 100% ▕████████████████▏  387 B                         
pulling 6e4c38e1172f... 100% ▕████████████████▏ 1.1 KB                         
pulling f4d24e9138dd... 100% ▕████████████████▏  148 B                         
pulling a85fe2a2e58e... 100% ▕████████████████▏  487 B                         
verifying sha256 digest 
writing manifest 
success 
&gt;&gt;&gt; hello
&lt;think&gt;

&lt;/think&gt;

Hello! How can I assist you today? 😊

satria@teddy:~$ ollama run deepseek-r1:1.5b

pulling manifest

pulling aabd4debf0c8... 100% ▕████████████████▏ 1.1 GB

pulling 369ca498f347... 100% ▕████████████████▏ 387 B

pulling 6e4c38e1172f... 100% ▕████████████████▏ 1.1 KB

pulling f4d24e9138dd... 100% ▕████████████████▏ 148 B

pulling a85fe2a2e58e... 100% ▕████████████████▏ 487 B

verifying sha256 digest

writing manifest

success

>>> hello

<think>

</think>

Hello! How can I assist you today? 😊

[/codesyntax]

Integrate it with VSCode:
Watch : https://www.youtube.com/watch?v=cqFRE9c8048&ab_channel=ChaooCharles

the problem:
1. it’ll take your disk space. For just 1.5b model, it’ll take 1.1 GB disk space
2. If you don’t have GPU, it’ll use your CPU resource and it took 100% CPU resources on my Ubuntu machine
You can stop and disable the ollama services on your machine
[codesyntax lang=”bash”]

# stop it
sudo systemctl stop ollama.service

# disable it if you want
sudo systemctl disable ollama.service

# confirm its status
sudo systemctl status ollama.service

# stop it

sudo systemctl stop ollama.service

# disable it if you want

sudo systemctl disable ollama.service

# confirm its status

sudo systemctl status ollama.service

[/codesyntax]

Create a Login App with ASP.NET on Ubuntu 22.04

Here’s a step-by-step guide to create a simple login form using ASP.NET Core (C#) and MS SQL Server with VS Code and Linux:

Install .NET SDK If you haven’t already, install the .NET SDK for your Linux distribution. You can find instructions on the official Microsoft website.check your dotnet version
[codesyntax lang=”bash”]

dotnet --version 8.0.405

1
2

dotnet --version
8.0.405

[/codesyntax]

Create a new ASP.NET Core project Open a terminal and run:

dotnet new mvc -n LoginApp

1	dotnet new mvc -n LoginApp

[codesyntax lang=”bash”]

satria@teddy:~/Documents/projects/aspnet$ dotnet new mvc -n LoginApp
The template "ASP.NET Core Web App (Model-View-Controller)" was created successfully.
This template contains technologies from parties other than Microsoft, see https://aka.ms/aspnetcore/8.0-third-party-notices for details.

Processing post-creation actions...
Restoring /home/satria/Documents/projects/aspnet/LoginApp/LoginApp.csproj:
  Determining projects to restore...
  Restored /home/satria/Documents/projects/aspnet/LoginApp/LoginApp.csproj (in 83 ms).
Restore succeeded.

satria@teddy:~/Documents/projects/aspnet$ dotnet new mvc -n LoginApp

The template "ASP.NET Core Web App (Model-View-Controller)" was created successfully.

This template contains technologies from parties other than Microsoft, see https://aka.ms/aspnetcore/8.0-third-party-notices for details.

Processing post-creation actions...

Restoring /home/satria/Documents/projects/aspnet/LoginApp/LoginApp.csproj:

Determining projects to restore...

Restored /home/satria/Documents/projects/aspnet/LoginApp/LoginApp.csproj (in 83 ms).

Restore succeeded.

[/codesyntax]

Go to the project directory ‘LoginApp’ with ‘cd LoginApp’

Install required NuGet packages Run the following commands:
[codesyntax lang=”bash”]

dotnet add package Microsoft.EntityFrameworkCore.SqlServer
dotnet add package Microsoft.EntityFrameworkCore.Design
dotnet add package Microsoft.AspNetCore.Identity.EntityFrameworkCore

dotnet add package Microsoft.EntityFrameworkCore.SqlServer

dotnet add package Microsoft.EntityFrameworkCore.Design

dotnet add package Microsoft.AspNetCore.Identity.EntityFrameworkCore

[/codesyntax]

Make sure the version is match in LoginApp.csproj
[codesyntax lang=”csharp”]

&lt;ItemGroup&gt;
    &lt;PackageReference Include="Microsoft.AspNetCore.Identity.EntityFrameworkCore" Version="8.0.0" /&gt;
    &lt;PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="8.0.0" /&gt;
    &lt;PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="8.0.0"&gt;
      &lt;IncludeAssets&gt;runtime; build; native; contentfiles; analyzers; buildtransitive&lt;/IncludeAssets&gt;
      &lt;PrivateAssets&gt;all&lt;/PrivateAssets&gt;
    &lt;/PackageReference&gt;
  &lt;/ItemGroup&gt;

<IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>

</PackageReference>

</ItemGroup>

[/codesyntax]

Set up the database connection Open appsettings.json and add the connection string:
[codesyntax lang=”text”]

"ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Database=LoginApp;User Id=your_username;Password=your_password;TrustServerCertificate=True;"
  },

"ConnectionStrings": {

"DefaultConnection": "Server=localhost;Database=LoginApp;User Id=your_username;Password=your_password;TrustServerCertificate=True;"

[/codesyntax]
Note: I need to add ‘TrustServerCertificate=True;’

Create ApplicationDbContext Create a new file ApplicationDbContext.cs
[codesyntax lang=”csharp”]

using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore;

namespace LoginApp
{
    public class ApplicationDbContext : IdentityDbContext
    {
        public ApplicationDbContext(DbContextOptions&lt;ApplicationDbContext&gt; options)
            : base(options)
        {
        }
    }
}

using Microsoft.AspNetCore.Identity.EntityFrameworkCore;

using Microsoft.EntityFrameworkCore;

namespace LoginApp

{

public class ApplicationDbContext : IdentityDbContext

{

public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)

: base(options)

{

}

[/codesyntax]

Update Program.cs Replace the content of Program.cs:
[codesyntax lang=”csharp”]

using LoginApp;
using Microsoft.AspNetCore.Identity;
using Microsoft.EntityFrameworkCore;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.
builder.Services.AddControllersWithViews();

builder.Services.AddDbContext&lt;ApplicationDbContext&gt;(options =&gt;
    options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));

builder.Services.AddIdentity&lt;IdentityUser, IdentityRole&gt;()
    .AddEntityFrameworkStores&lt;ApplicationDbContext&gt;();

var app = builder.Build();

// Configure the HTTP request pipeline.
if (!app.Environment.IsDevelopment())
{
    app.UseExceptionHandler("/Home/Error");
    app.UseHsts();
}

app.UseHttpsRedirection();
app.UseStaticFiles();

app.UseRouting();

app.UseAuthentication();
app.UseAuthorization();

app.MapControllerRoute(
    name: "default",
    pattern: "{controller=Home}/{action=Index}/{id?}");

// Initialize the database
using (var scope = app.Services.CreateScope())
{
    var services = scope.ServiceProvider;
    try
    {
        var context = services.GetRequiredService&lt;ApplicationDbContext&gt;();
        context.Database.EnsureCreated();
        await DbInitializer.Initialize(services);
    }
    catch (Exception ex)
    {
        var logger = services.GetRequiredService&lt;ILogger&lt;Program&gt;&gt;();
        logger.LogError(ex, "An error occurred while seeding the database.");
    }
}

app.Run();

using LoginApp;

using Microsoft.AspNetCore.Identity;

using Microsoft.EntityFrameworkCore;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.

builder.Services.AddControllersWithViews();

builder.Services.AddDbContext<ApplicationDbContext>(options =>

options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));

builder.Services.AddIdentity<IdentityUser, IdentityRole>()

.AddEntityFrameworkStores<ApplicationDbContext>();

var app = builder.Build();

// Configure the HTTP request pipeline.

if (!app.Environment.IsDevelopment())

{

app.UseExceptionHandler("/Home/Error");

app.UseHsts();

}

app.UseHttpsRedirection();

app.UseStaticFiles();

app.UseRouting();

app.UseAuthentication();

app.UseAuthorization();

app.MapControllerRoute(

name: "default",

pattern: "{controller=Home}/{action=Index}/{id?}");

// Initialize the database

using (var scope = app.Services.CreateScope())

{

var services = scope.ServiceProvider;

try

{

var context = services.GetRequiredService<ApplicationDbContext>();

context.Database.EnsureCreated();

await DbInitializer.Initialize(services);

}

catch (Exception ex)

{

var logger = services.GetRequiredService<ILogger<Program>>();

logger.LogError(ex, "An error occurred while seeding the database.");

}

app.Run();

[/codesyntax]

Create Login Model Create Models/LoginModel.cs:
[codesyntax lang=”csharp”]

using System.ComponentModel.DataAnnotations;

namespace LoginApp.Models
{
    public class LoginModel
    {
        [Required]
        [EmailAddress]
        public string Email { get; set; } = string.Empty;

        [Required]
        [DataType(DataType.Password)]
        public string Password { get; set; } = string.Empty;

        [Display(Name = "Remember me?")]
        public bool RememberMe { get; set; }
    }
}

using System.ComponentModel.DataAnnotations;

namespace LoginApp.Models

{

public class LoginModel

{

[Required]

[EmailAddress]

public string Email { get; set; } = string.Empty;

[Required]

[DataType(DataType.Password)]

public string Password { get; set; } = string.Empty;

[Display(Name = "Remember me?")]

public bool RememberMe { get; set; }

}

[/codesyntax]

Create Account Controller Create Controllers/AccountController.cs:
[codesyntax lang=”csharp”]

using LoginApp.Models;
using Microsoft.AspNetCore.Identity;
using Microsoft.AspNetCore.Mvc;

namespace LoginApp.Controllers
{
    public class AccountController : Controller
    {
        private readonly SignInManager&lt;IdentityUser&gt; _signInManager;

        public AccountController(SignInManager&lt;IdentityUser&gt; signInManager)
        {
            _signInManager = signInManager;
        }

        [HttpGet]
        public IActionResult Login()
        {
            return View();
        }

        [HttpPost]
        public async Task&lt;IActionResult&gt; Login(LoginModel model)
        {
            if (ModelState.IsValid)
            {
                var result = await _signInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, lockoutOnFailure: false);
                if (result.Succeeded)
                {
                    return RedirectToAction("Index", "Home");
                }
                ModelState.AddModelError(string.Empty, "Invalid login attempt.");
            }
            return View(model);
        }
    }
}

using LoginApp.Models;

using Microsoft.AspNetCore.Identity;

using Microsoft.AspNetCore.Mvc;

namespace LoginApp.Controllers

{

public class AccountController : Controller

{

private readonly SignInManager<IdentityUser> _signInManager;

public AccountController(SignInManager<IdentityUser> signInManager)

{

_signInManager = signInManager;

}

[HttpGet]

public IActionResult Login()

{

return View();

}

[HttpPost]

public async Task<IActionResult> Login(LoginModel model)

{

if (ModelState.IsValid)

{

var result = await _signInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, lockoutOnFailure: false);

if (result.Succeeded)

{

return RedirectToAction("Index", "Home");

}

ModelState.AddModelError(string.Empty, "Invalid login attempt.");

}

return View(model);

}

[/codesyntax]

Create Login View Create Views/Account/Login.cshtml:
[codesyntax lang=”html4strict”]

@model LoginApp.Models.LoginModel

&lt;h2&gt;Login&lt;/h2&gt;

&lt;form asp-action="Login" method="post"&gt;
    &lt;div asp-validation-summary="ModelOnly" class="text-danger"&gt;&lt;/div&gt;
    &lt;div class="form-group"&gt;
        &lt;label asp-for="Email"&gt;&lt;/label&gt;
        &lt;input asp-for="Email" class="form-control" /&gt;
        &lt;span asp-validation-for="Email" class="text-danger"&gt;&lt;/span&gt;
    &lt;/div&gt;
    &lt;div class="form-group"&gt;
        &lt;label asp-for="Password"&gt;&lt;/label&gt;
        &lt;input asp-for="Password" class="form-control" /&gt;
        &lt;span asp-validation-for="Password" class="text-danger"&gt;&lt;/span&gt;
    &lt;/div&gt;
    &lt;div class="form-group"&gt;
        &lt;div class="checkbox"&gt;
            &lt;label&gt;
                &lt;input asp-for="RememberMe" /&gt; @Html.DisplayNameFor(m =&gt; m.RememberMe)
            &lt;/label&gt;
        &lt;/div&gt;
    &lt;/div&gt;
    &lt;button type="submit" class="btn btn-primary"&gt;Log in&lt;/button&gt;
&lt;/form&gt;

@model LoginApp.Models.LoginModel

<h2>Login</h2>

</div>

</div>

<label>

<input asp-for="RememberMe" /> @Html.DisplayNameFor(m => m.RememberMe)

</label>

</div>

</form>

[/codesyntax]

Set up the database. Create a new database ‘LoginApp’

Add a test user Create DbInitializer.cs:
[codesyntax lang=”csharp”]

using Microsoft.AspNetCore.Identity;

namespace LoginApp
{
    public static class DbInitializer
    {
        public static async Task Initialize(IServiceProvider serviceProvider)
        {
            var userManager = serviceProvider.GetRequiredService&lt;UserManager&lt;IdentityUser&gt;&gt;();

            string email = "admin@example.com";
            string password = "Admin123!";

            if (await userManager.FindByEmailAsync(email) == null)
            {
                var user = new IdentityUser { UserName = email, Email = email };
                await userManager.CreateAsync(user, password);
            }
        }
    }
}

using Microsoft.AspNetCore.Identity;

namespace LoginApp

{

public static class DbInitializer

{

public static async Task Initialize(IServiceProvider serviceProvider)

{

var userManager = serviceProvider.GetRequiredService<UserManager<IdentityUser>>();

string email = "admin@example.com";

string password = "Admin123!";

if (await userManager.FindByEmailAsync(email) == null)

{

var user = new IdentityUser { UserName = email, Email = email };

await userManager.CreateAsync(user, password);

}

[/codesyntax]
Note: it’ll create a new dummy user with
email: admin@example.com
password: Admin123!

Run the application Execute:

dotnet run

1

dotnet run
Navigate to http://localhost:5000/Account/Login in your browser.

create some navigation menus (login, logout, etc) on the homepage
Create a new file called _NavBar.cshtml in the Views/Shared folder with the following content:
[codesyntax lang=”html4strict”]

@using Microsoft.AspNetCore.Identity
@inject SignInManager&lt;IdentityUser&gt; SignInManager
@inject UserManager&lt;IdentityUser&gt; UserManager

&lt;nav class="navbar navbar-expand-sm navbar-toggleable-sm navbar-light bg-white border-bottom box-shadow mb-3"&gt;
    &lt;div class="container"&gt;
        &lt;a class="navbar-brand" asp-area="" asp-controller="Home" asp-action="Index"&gt;LoginApp&lt;/a&gt;
        &lt;button class="navbar-toggler" type="button" data-toggle="collapse" data-target=".navbar-collapse" aria-controls="navbarSupportedContent"
                aria-expanded="false" aria-label="Toggle navigation"&gt;
            &lt;span class="navbar-toggler-icon"&gt;&lt;/span&gt;
        &lt;/button&gt;
        &lt;div class="navbar-collapse collapse d-sm-inline-flex justify-content-between"&gt;
            &lt;ul class="navbar-nav flex-grow-1"&gt;
                &lt;li class="nav-item"&gt;
                    &lt;a class="nav-link text-dark" asp-area="" asp-controller="Home" asp-action="Index"&gt;Home&lt;/a&gt;
                &lt;/li&gt;
                @if (SignInManager.IsSignedIn(User))
                {
                    &lt;li class="nav-item"&gt;
                        &lt;a class="nav-link text-dark" asp-area="" asp-controller="Account" asp-action="Logout"&gt;Logout&lt;/a&gt;
                    &lt;/li&gt;
                }
                else
                {
                    &lt;li class="nav-item"&gt;
                        &lt;a class="nav-link text-dark" asp-area="" asp-controller="Account" asp-action="Login"&gt;Login&lt;/a&gt;
                    &lt;/li&gt;
                    &lt;li class="nav-item"&gt;
                        &lt;a class="nav-link text-dark" asp-area="" asp-controller="Account" asp-action="Register"&gt;Register&lt;/a&gt;
                    &lt;/li&gt;
                }
            &lt;/ul&gt;
        &lt;/div&gt;
    &lt;/div&gt;
&lt;/nav&gt;

@using Microsoft.AspNetCore.Identity

@inject SignInManager<IdentityUser> SignInManager

@inject UserManager<IdentityUser> UserManager

<a class="navbar-brand" asp-area="" asp-controller="Home" asp-action="Index">LoginApp</a>

<button class="navbar-toggler" type="button" data-toggle="collapse" data-target=".navbar-collapse" aria-controls="navbarSupportedContent"

aria-expanded="false" aria-label="Toggle navigation">

</button>

</li>

@if (SignInManager.IsSignedIn(User))

{

<a class="nav-link text-dark" asp-area="" asp-controller="Account" asp-action="Logout">Logout</a>

</li>

}

else

{

<a class="nav-link text-dark" asp-area="" asp-controller="Account" asp-action="Login">Login</a>

</li>

<a class="nav-link text-dark" asp-area="" asp-controller="Account" asp-action="Register">Register</a>

</li>

}

</ul>

</div>

</nav>

[/codesyntax]

Now, let’s include this partial view in your layout file. Open the Views/Shared/_Layout.cshtml file and add the following line just after the opening <body> tag:
[codesyntax lang=”html4strict”]

&lt;body&gt;
    &lt;partial name="_NavBar" /&gt;
    &lt;!--header&gt;
        &lt;nav class="navbar navbar-expand-sm navbar-toggleable-sm navbar-light bg-white border-bottom box-shadow mb-3"&gt;
            &lt;div class="container-fluid"&gt;
                &lt;a class="navbar-brand" asp-area="" asp-controller="Home" asp-action="Index"&gt;LoginApp&lt;/a&gt;
                &lt;button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target=".navbar-collapse" aria-controls="navbarSupportedContent"
                        aria-expanded="false" aria-label="Toggle navigation"&gt;
                    &lt;span class="navbar-toggler-icon"&gt;&lt;/span&gt;
                &lt;/button&gt;
                &lt;div class="navbar-collapse collapse d-sm-inline-flex justify-content-between"&gt;
                    &lt;ul class="navbar-nav flex-grow-1"&gt;
                        &lt;li class="nav-item"&gt;
                            &lt;a class="nav-link text-dark" asp-area="" asp-controller="Home" asp-action="Index"&gt;Home&lt;/a&gt;
                        &lt;/li&gt;
                        &lt;li class="nav-item"&gt;
                            &lt;a class="nav-link text-dark" asp-area="" asp-controller="Home" asp-action="Privacy"&gt;Privacy&lt;/a&gt;
                        &lt;/li&gt;
                    &lt;/ul&gt;
                &lt;/div&gt;
            &lt;/div&gt;
        &lt;/nav&gt;
    &lt;/header--&gt;
    &lt;!-- ... existing content ... --&gt;
&lt;/body&gt;

<body>

<!--header>

<a class="navbar-brand" asp-area="" asp-controller="Home" asp-action="Index">LoginApp</a>

<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target=".navbar-collapse" aria-controls="navbarSupportedContent"

aria-expanded="false" aria-label="Toggle navigation">

</button>

</li>

<a class="nav-link text-dark" asp-area="" asp-controller="Home" asp-action="Privacy">Privacy</a>

</li>

</ul>

</div>

</nav>

</header-->

</body>

[/codesyntax]
Note: I need to remove the default <header> tag to use the new partial navbar

create controller for account logout
modify Controllers/AccountController.cs
[codesyntax lang=”csharp”]

using LoginApp.Models;
using Microsoft.AspNetCore.Identity;
using Microsoft.AspNetCore.Mvc;

namespace LoginApp.Controllers
{
    public class AccountController : Controller
    {
        ...

        [HttpPost]
        public async Task&lt;IActionResult&gt; Login(LoginModel model)
        {
           ...
        }

        [HttpPost]
        [ValidateAntiForgeryToken]
        public async Task&lt;IActionResult&gt; Logout()
        {
            await _signInManager.SignOutAsync();
            return RedirectToAction("Index", "Home");
        }
    }
}

using LoginApp.Models;

using Microsoft.AspNetCore.Identity;

using Microsoft.AspNetCore.Mvc;

namespace LoginApp.Controllers

{

public class AccountController : Controller

{

...

[HttpPost]

public async Task<IActionResult> Login(LoginModel model)

{

...

}

[HttpPost]

[ValidateAntiForgeryToken]

public async Task<IActionResult> Logout()

{

await _signInManager.SignOutAsync();

return RedirectToAction("Index", "Home");

}

[/codesyntax]

Now, let’s update the _NavBar.cshtml partial view to use a form for the logout action, as it should be a POST request. Update the logout link in the _NavBar.cshtml file like this:
[codesyntax lang=”html4strict”]

// ... existing code ...
@if (SignInManager.IsSignedIn(User))
{
    &lt;li class="nav-item"&gt;
        &lt;form asp-area="" asp-controller="Account" asp-action="Logout" method="post" id="logoutForm" class="navbar-right"&gt;
            &lt;button type="submit" class="btn btn-link navbar-btn navbar-link"&gt;Logout&lt;/button&gt;
        &lt;/form&gt;
    &lt;/li&gt;
}
// ... existing code ...

// ... existing code ...

@if (SignInManager.IsSignedIn(User))

{

<button type="submit" class="btn btn-link navbar-btn navbar-link">Logout</button>

</form>

</li>

}

// ... existing code ...

[/codesyntax]
at the end of this file, add this javascript
[codesyntax lang=”html4strict”]

&lt;script&gt;
    $(function() {
        $('#logoutForm').on('click', function(e) {
            e.preventDefault();
            $(this).submit();
        });
    });
&lt;/script&gt;

$(function() {

$('#logoutForm').on('click', function(e) {

e.preventDefault();

$(this).submit();

});

</script>

[/codesyntax]

Add controller for registration and forgot password?

Install Microsoft SQL Server 2022 On Ubuntu 22.04

Ref: https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver16&tabs=ubuntu2204

1. Update and upgrade the packages on ubuntu 22.04
[codesyntax lang=”bash”]

sudo apt update
sudo apt upgrade -y

1 2	sudo apt update sudo apt upgrade -y

[/codesyntax]

2. Download the public key, convert from ASCII to GPG format, and write it to the required location:
[codesyntax lang=”bash”]

curl -fsSL https://packages.microsoft.com/keys/microsoft.asc | sudo gpg --dearmor -o /usr/share/keyrings/microsoft-prod.gpg

1	curl -fsSL https://packages.microsoft.com/keys/microsoft.asc \| sudo gpg --dearmor -o /usr/share/keyrings/microsoft-prod.gpg

[/codesyntax]

3. Manually download and register the SQL Server Ubuntu repository:
[codesyntax lang=”bash”]

curl -fsSL https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list | sudo tee /etc/apt/sources.list.d/mssql-server-2022.list

1	curl -fsSL https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list \| sudo tee /etc/apt/sources.list.d/mssql-server-2022.list

[/codesyntax]

4. Run the following commands to install SQL Server:
[codesyntax lang=”bash”]

sudo apt-get update
sudo apt-get install -y mssql-server
...
Setting up libc++abi1-14:amd64 (1:14.0.0-1ubuntu1.1) ...
Setting up libc++1-14:amd64 (1:14.0.0-1ubuntu1.1) ...
Setting up libc++1:amd64 (1:14.0-55~exp2) ...
Setting up mssql-server (16.0.4175.1-3) ...

+--------------------------------------------------------------+
Please run 'sudo /opt/mssql/bin/mssql-conf setup'
to complete the setup of Microsoft SQL Server
+--------------------------------------------------------------+

Processing triggers for man-db (2.10.2-1) ...
Processing triggers for libc-bin (2.35-0ubuntu3.8) ...

sudo apt-get update

sudo apt-get install -y mssql-server

...

Setting up libc++abi1-14:amd64 (1:14.0.0-1ubuntu1.1) ...

Setting up libc++1-14:amd64 (1:14.0.0-1ubuntu1.1) ...

Setting up libc++1:amd64 (1:14.0-55~exp2) ...

Setting up mssql-server (16.0.4175.1-3) ...

+--------------------------------------------------------------+

Please run 'sudo /opt/mssql/bin/mssql-conf setup'

to complete the setup of Microsoft SQL Server

+--------------------------------------------------------------+

Processing triggers for man-db (2.10.2-1) ...

Processing triggers for libc-bin (2.35-0ubuntu3.8) ...

[/codesyntax]

5. After the package installation finishes, run mssql-conf setup and follow the prompts to set the sa password and choose your edition.
Just choose ‘Developer’ version. type 2. My local sa password is {my-nick-name-first-uppercase}@123
[codesyntax lang=”bash”]

satria@teddy:~$ sudo /opt/mssql/bin/mssql-conf setup
Choose an edition of SQL Server:
  1) Evaluation (free, no production use rights, 180-day limit)
  2) Developer (free, no production use rights)
  3) Express (free)
  4) Web (PAID)
  5) Standard (PAID)
  6) Enterprise (PAID) - CPU core utilization restricted to 20 physical/40 hyperthreaded
  7) Enterprise Core (PAID) - CPU core utilization up to Operating System Maximum
  8) I bought a license through a retail sales channel and have a product key to enter.
  9) Standard (Billed through Azure) - Use pay-as-you-go billing through Azure.
 10) Enterprise Core (Billed through Azure) - Use pay-as-you-go billing through Azure.

Details about editions can be found at
https://go.microsoft.com/fwlink/?LinkId=2109348&amp;clcid=0x409

Use of PAID editions of this software requires separate licensing through a
Microsoft Volume Licensing program.
By choosing a PAID edition, you are verifying that you have the appropriate
number of licenses in place to install and run this software.
By choosing an edition billed Pay-As-You-Go through Azure, you are verifying 
that the server and SQL Server will be connected to Azure by installing the 
management agent and Azure extension for SQL Server.

Enter your edition(1-10): 2
The license terms for this product can be found in
/usr/share/doc/mssql-server or downloaded from: https://aka.ms/useterms

The privacy statement can be viewed at:
https://go.microsoft.com/fwlink/?LinkId=853010&amp;clcid=0x409

Do you accept the license terms? [Yes/No]:yes

Enter the SQL Server system administrator password: 
Confirm the SQL Server system administrator password: 
Configuring SQL Server...

ForceFlush is enabled for this instance. 
ForceFlush feature is enabled for log durability.
Created symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service → /lib/systemd/system/mssql-server.service.
Setup has completed successfully. SQL Server is now starting.

satria@teddy:~$ sudo /opt/mssql/bin/mssql-conf setup

Choose an edition of SQL Server:

1) Evaluation (free, no production use rights, 180-day limit)

2) Developer (free, no production use rights)

3) Express (free)

4) Web (PAID)

5) Standard (PAID)

6) Enterprise (PAID) - CPU core utilization restricted to 20 physical/40 hyperthreaded

7) Enterprise Core (PAID) - CPU core utilization up to Operating System Maximum

8) I bought a license through a retail sales channel and have a product key to enter.

9) Standard (Billed through Azure) - Use pay-as-you-go billing through Azure.

10) Enterprise Core (Billed through Azure) - Use pay-as-you-go billing through Azure.

Details about editions can be found at

https://go.microsoft.com/fwlink/?LinkId=2109348&clcid=0x409

Use of PAID editions of this software requires separate licensing through a

Microsoft Volume Licensing program.

By choosing a PAID edition, you are verifying that you have the appropriate

number of licenses in place to install and run this software.

By choosing an edition billed Pay-As-You-Go through Azure, you are verifying

that the server and SQL Server will be connected to Azure by installing the

management agent and Azure extension for SQL Server.

Enter your edition(1-10): 2

The license terms for this product can be found in

/usr/share/doc/mssql-server or downloaded from: https://aka.ms/useterms

The privacy statement can be viewed at:

https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409

Do you accept the license terms? [Yes/No]:yes

Enter the SQL Server system administrator password:

Confirm the SQL Server system administrator password:

Configuring SQL Server...

ForceFlush is enabled for this instance.

ForceFlush feature is enabled for log durability.

Created symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service → /lib/systemd/system/mssql-server.service.

Setup has completed successfully. SQL Server is now starting.

[/codesyntax]

6. Once the configuration is done, verify that the service is running:
[codesyntax lang=”bash”]

systemctl status mssql-server --no-pager

1	systemctl status mssql-server --no-pager

[/codesyntax]

Install the SQL Server command-line tools (sqlcmd)

1. Import the public repository GPG keys.
[codesyntax lang=”bash”]

curl https://packages.microsoft.com/keys/microsoft.asc | sudo tee /etc/apt/trusted.gpg.d/microsoft.asc

1	curl https://packages.microsoft.com/keys/microsoft.asc \| sudo tee /etc/apt/trusted.gpg.d/microsoft.asc

[/codesyntax]

2. Register the Microsoft Ubuntu repository. For Ubuntu 22.04, use the following command:
[codesyntax lang=”bash”]

curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list

1	curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list \| sudo tee /etc/apt/sources.list.d/mssql-release.list

[/codesyntax]

3. Update the sources list and run the installation command with the unixODBC developer package.
[codesyntax lang=”bash”]

sudo apt-get update
sudo apt-get install mssql-tools18 unixodbc-dev

1 2	sudo apt-get update sudo apt-get install mssql-tools18 unixodbc-dev

[/codesyntax]

To update to the latest version of mssql-tools, run the following commands:
[codesyntax lang=”bash”]

sudo apt-get update  
sudo apt-get install mssql-tools18

1 2	sudo apt-get update sudo apt-get install mssql-tools18

[/codesyntax]

4. Add /opt/mssql-tools18/bin/ to your PATH environment variable in a bash shell.

To make sqlcmd and bcp accessible from the bash shell for login sessions, modify your PATH in the ~/.bash_profile file with the following command:
[codesyntax lang=”bash”]

echo 'export PATH="$PATH:/opt/mssql-tools18/bin"' &gt;&gt; ~/.bash_profile
source ~/.bash_profile

1 2	echo 'export PATH="$PATH:/opt/mssql-tools18/bin"' >> ~/.bash_profile source ~/.bash_profile

[/codesyntax]

5. Test sqlcmd with ‘sqlcmd -?’
[codesyntax lang=”bash”]

satria@teddy:~$ sqlcmd -?
Microsoft (R) SQL Server Command Line Tool
Version 18.4.0001.1 Linux
Copyright (C) 2017 Microsoft Corporation. All rights reserved.

usage: sqlcmd            [-U login id]          [-P password]
  [-S server or Dsn if -D is provided] 
  [-H hostname]          [-E trusted connection]
  ...
  [-G use Microsoft Entra ID for authentication]
  [-? show syntax summary]

satria@teddy:~$ sqlcmd -?

Microsoft (R) SQL Server Command Line Tool

Version 18.4.0001.1 Linux

usage: sqlcmd [-U login id] [-P password]

[-S server or Dsn if -D is provided]

[-H hostname] [-E trusted connection]

...

[-G use Microsoft Entra ID for authentication]

[-? show syntax summary]

[/codesyntax]

Connect locally. I tried to use : sqlcmd -S localhost -U sa -P your_password
but it showed up this error
[codesyntax lang=”bash”]

satria@teddy:~$ sqlcmd -S localhost -U sa -P your_password
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate].
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Client unable to establish connection. For solutions related to encryption errors, see https://go.microsoft.com/fwlink/?linkid=2226722.

satria@teddy:~$ sqlcmd -S localhost -U sa -P your_password

Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate].

Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Client unable to establish connection. For solutions related to encryption errors, see https://go.microsoft.com/fwlink/?linkid=2226722.

[/codesyntax]

it turned out I need to add -C parameter at the end like this
[codesyntax lang=”bash”]

satria@teddy:~$ sqlcmd -S localhost -U sa -P Teddy@123 -C
1&gt; SELECT Name from sys.databases;
2&gt; GO
Name                                                                                                                            
--------------------------------------------------------------------------------------------------------------------------------
master                                                                                                                          
tempdb                                                                                                                          
model                                                                                                                           
msdb                                                                                                                            

(4 rows affected)
1&gt; quit

satria@teddy:~$ sqlcmd -S localhost -U sa -P Teddy@123 -C

1> SELECT Name from sys.databases;

2> GO

Name

--------------------------------------------------------------------------------------------------------------------------------

master

tempdb

model

msdb

(4 rows affected)

1> quit

[/codesyntax]

Create a new database

For example create a new database TestDB from sqlcmd
[codesyntax lang=”bash”]

1&gt; CREATE DATABASE TestDB;
2&gt; GO

1 2	1> CREATE DATABASE TestDB; 2> GO

[/codesyntax]

Create a new table dbo.Inventory and Insert data
[codesyntax lang=”bash”]

1&gt; USE TestDB;
2&gt; GO
1&gt; CREATE TABLE dbo.Inventory
2&gt; (
3&gt; id INT,
4&gt; name NVARCHAR (50),
5&gt; quantity INT,
6&gt; PRIMARY KEY (id)
7&gt; );
8&gt; GO
1&gt; INSERT INTO dbo.Inventory VALUES (1, 'banana', 150);
2&gt; GO

(1 rows affected)
1&gt; INSERT INTO dbo.Inventory VALUES (2, 'orange', 154);
2&gt; GO

(1 rows affected)
1&gt; SELECT * FROM dbo.Inventory;
2&gt; GO
id          name                                               quantity   
----------- -------------------------------------------------- -----------
          1 banana                                                     150
          2 orange                                                     154

(2 rows affected)
1&gt; SELECT * FROM dbo.Inventory;
2&gt; GO
id          name                                               quantity   
----------- -------------------------------------------------- -----------
          1 banana                                                     150
          2 orange                                                     154

(2 rows affected)
1&gt; quit

1> USE TestDB;

2> GO

1> CREATE TABLE dbo.Inventory

2> (

3> id INT,

4> name NVARCHAR (50),

5> quantity INT,

6> PRIMARY KEY (id)

7> );

8> GO

1> INSERT INTO dbo.Inventory VALUES (1, 'banana', 150);

2> GO

(1 rows affected)

1> INSERT INTO dbo.Inventory VALUES (2, 'orange', 154);

2> GO

(1 rows affected)

1> SELECT * FROM dbo.Inventory;

2> GO

id name quantity

----------- -------------------------------------------------- -----------

1 banana 150

2 orange 154

(2 rows affected)

1> SELECT * FROM dbo.Inventory;

2> GO

id name quantity

----------- -------------------------------------------------- -----------

1 banana 150

2 orange 154

(2 rows affected)

1> quit

[/codesyntax]

Install DBeaver (https://dbeaver.io/)
This is Database GUI for many databases including MS SQL Server

Download it https://dbeaver.io/download/
I used Ubuntu PPA
[codesyntax lang=”bash”]

sudo add-apt-repository ppa:serge-rider/dbeaver-ce
sudo apt-get update
sudo apt-get install dbeaver-ce

sudo add-apt-repository ppa:serge-rider/dbeaver-ce

sudo apt-get update

sudo apt-get install dbeaver-ce

[/codesyntax]

Open DBeaver CE and select to the MS SQL Server

Connect to the MS SQL Server but it needs to use JDBC driver. Install it directly from the DBeaver

If everything is okay, it’ll look like this

on the DBeaver GUI you can add a new row. for example add a new row
ID: 3
Name: Apple
Quantity: 158
Then save

on the sqlcmd should reflect the changes
[codesyntax lang=”bash”]

1&gt; USE TestDB;
2&gt; GO
Changed database context to 'TestDB'.
1&gt; SELECT * FROM dbo.Inventory;
2&gt; GO
id          name                                               quantity   
----------- -------------------------------------------------- -----------
          1 banana                                                     150
          2 orange                                                     154
          3 Apple                                                      158

(3 rows affected)

1> USE TestDB;

2> GO

Changed database context to 'TestDB'.

1> SELECT * FROM dbo.Inventory;

2> GO

id name quantity

----------- -------------------------------------------------- -----------

1 banana 150

2 orange 154

3 Apple 158

(3 rows affected)

[/codesyntax]

Create a Self-Signed SSL Certificate for Apache in Ubuntu 22.04

Ref: https://www.digitalocean.com/community/tutorials/how-to-create-a-self-signed-ssl-certificate-for-apache-in-ubuntu-22-04

1. open up the firewall ufw for the http and https ports:
[codesyntax lang=”bash”]

satria@teddy:~$ sudo ufw allow "Apache Full"
[sudo] password for satria: 
ERROR: Could not find a profile matching 'Apache Full'

satria@teddy:~$ sudo ufw allow "Apache Full"

[sudo] password for satria:

ERROR: Could not find a profile matching 'Apache Full'

[/codesyntax]

2. enable mod_ssl
[codesyntax lang=”bash”]

satria@teddy:~$ sudo a2enmod ssl
Considering dependency mime for ssl:
Module mime already enabled
Considering dependency socache_shmcb for ssl:
Enabling module socache_shmcb.
Enabling module ssl.
See /usr/share/doc/apache2/README.Debian.gz on how to configure SSL and create self-signed certificates.
To activate the new configuration, you need to run:
  systemctl restart apache2

satria@teddy:~$ sudo systemctl restart apache2

satria@teddy:~$ sudo a2enmod ssl

Considering dependency mime for ssl:

Module mime already enabled

Considering dependency socache_shmcb for ssl:

Enabling module socache_shmcb.

Enabling module ssl.

See /usr/share/doc/apache2/README.Debian.gz on how to configure SSL and create self-signed certificates.

To activate the new configuration, you need to run:

systemctl restart apache2

satria@teddy:~$ sudo systemctl restart apache2

[/codesyntax]

3. Creating the TLS Certificate
[codesyntax lang=”bash”]

satria@teddy:~$ sudo openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/ssl/private/apache-selfsigned.key -out /etc/ssl/certs/apache-selfsigned.crt
.+.......+.....+.+........+...................+..+...+...+...+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*..+......+.........+.........+...+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*.....+.......+......+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
..+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*..+..+...+...............+.+.....+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*.+.......+...+......+...+......+.....+....+...+..+...+.......+.....+......+.......+.........+...........+.......+...+...+..+.........+....+..+....+...+..+...+.+..+.......+.....+......+.+......+..............+.+.....+.........+......+.........+....+.........+...+.......................+.......+...+......+...+...+..+.......+.....+....+.................+....+.....+.............+......+..+....+...+.....+......+...................+..+.........................+.....+......+....+.....+....+.........+..+.+..+.+.........+..+...+.......+...+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-----
You are about to be asked to enter information that will be incorporated
into your certificate request.
What you are about to enter is what is called a Distinguished Name or a DN.
There are quite a few fields but you can leave some blank
For some fields there will be a default value,
If you enter '.', the field will be left blank.
-----
Country Name (2 letter code) [AU]:ID
State or Province Name (full name) [Some-State]:My State
Locality Name (eg, city) []:My City
Organization Name (eg, company) [Internet Widgits Pty Ltd]:LimauSoft
Organizational Unit Name (eg, section) []:IT Department
Common Name (e.g. server FQDN or YOUR name) []:satria
Email Address []:xxx@yahoo.com

satria@teddy:~$ sudo openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/ssl/private/apache-selfsigned.key -out /etc/ssl/certs/apache-selfsigned.crt

.+.......+.....+.+........+...................+..+...+...+...+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*..+......+.........+.........+...+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*.....+.......+......+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

..+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*..+..+...+...............+.+.....+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*.+.......+...+......+...+......+.....+....+...+..+...+.......+.....+......+.......+.........+...........+.......+...+...+..+.........+....+..+....+...+..+...+.+..+.......+.....+......+.+......+..............+.+.....+.........+......+.........+....+.........+...+.......................+.......+...+......+...+...+..+.......+.....+....+.................+....+.....+.............+......+..+....+...+.....+......+...................+..+.........................+.....+......+....+.....+....+.........+..+.+..+.+.........+..+...+.......+...+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

-----

You are about to be asked to enter information that will be incorporated

into your certificate request.

What you are about to enter is what is called a Distinguished Name or a DN.

There are quite a few fields but you can leave some blank

For some fields there will be a default value,

If you enter '.', the field will be left blank.

-----

Country Name (2 letter code) [AU]:ID

State or Province Name (full name) [Some-State]:My State

Locality Name (eg, city) []:My City

Organization Name (eg, company) [Internet Widgits Pty Ltd]:LimauSoft

Organizational Unit Name (eg, section) []:IT Department

Common Name (e.g. server FQDN or YOUR name) []:satria

Email Address []:xxx@yahoo.com

[/codesyntax]

4. Configuring Apache to Use TLS
[codesyntax lang=”bash”]

satria@teddy:~$ sudo gedit /etc/apache2/sites-available/mywebsite.test.conf

1	satria@teddy:~$ sudo gedit /etc/apache2/sites-available/mywebsite.test.conf

[/codesyntax]

the config file like this
[codesyntax lang=”php”]

&lt;VirtualHost mywebsite.test:80&gt; 
  ServerName www.mywebsite.test 
  Redirect / https://mywebsite.test/ 
&lt;/VirtualHost&gt;

&lt;VirtualHost mywebsite.test:443&gt; 
  ServerName www.mywebsite.test 
  DocumentRoot "/home/satria/Documents/projects/mywebsite" 
  DirectoryIndex index.php 
  &lt;Directory "/home/satria/Documents/projects/mywebsite"&gt; 
    AllowOverride All 
    Allow from All 
    Require all granted 
  &lt;/Directory&gt; 
  
  SSLEngine on
  SSLCertificateFile /etc/ssl/certs/apache-selfsigned.crt
  SSLCertificateKeyFile /etc/ssl/private/apache-selfsigned.key
   
  ErrorLog /var/log/apache2/mywebsite.error.log 
  CustomLog /var/log/apache2/mywebsite.access.log combined 
&lt;/VirtualHost&gt;

ServerName www.mywebsite.test

Redirect / https://mywebsite.test/

</VirtualHost>

ServerName www.mywebsite.test

DocumentRoot "/home/satria/Documents/projects/mywebsite"

DirectoryIndex index.php

AllowOverride All

Allow from All

Require all granted

</Directory>

SSLEngine on

SSLCertificateFile /etc/ssl/certs/apache-selfsigned.crt

SSLCertificateKeyFile /etc/ssl/private/apache-selfsigned.key

ErrorLog /var/log/apache2/mywebsite.error.log

CustomLog /var/log/apache2/mywebsite.access.log combined

</VirtualHost>

[/codesyntax]
don’t forget to reload/restart apache2 service

5. Now load your site in a browser, being sure to use https:// at the beginning.

You should see an error. This is normal for a self-signed certificate! The browser is warning you that it can’t verify the identity of the server, because our certificate is not signed by any of its known certificate authorities. For testing purposes and personal use this can be fine. You should be able to click through to advanced or more information and choose to proceed.

Install xdebug with PHP 8.2 on Ubuntu 22.04

<OLD>Ref: https://gist.github.com/henryonsoftware/066d8282daaf8c2ae281ce010e3e5404

1. Download xdebug source code from https://github.com/xdebug/xdebug/releases
for example the xdebug 3.3.2 from https://github.com/xdebug/xdebug/archive/refs/tags/3.3.2.tar.gz

2. extract the downloaded file
satria@teddy:~$ cd Downloads/
satria@teddy:~/Downloads$ tar -xvzf xdebug-3.3.2.tar.gz

3. run ‘phpize’
satria@teddy:~/Downloads$ cd xdebug-3.3.2/
satria@teddy:~/Downloads/xdebug-3.3.2$ phpize
Configuring for:
PHP Api Version: 20210902
Zend Module Api No: 20210902
Zend Extension Api No: 420210902
configure.ac:165: warning: The macro `AC_PROG_LIBTOOL’ is obsolete.
configure.ac:165: You should run autoupdate.
build/libtool.m4:99: AC_PROG_LIBTOOL is expanded from…
configure.ac:165: the top level

4. run ‘./configure’
satria@teddy:~/Downloads/xdebug-3.3.2$ ./configure

5. run ‘make’
satria@teddy:~/Downloads/xdebug-3.3.2$ make

6. copy the module xdebug.so to php lib 20210902
</OLD>
<NEW>

Use php from repository ppa:ondrej/php
then install php8.2-dev
[codesyntax lang=”php”]

sudo add-apt-repository ppa:ondrej/php
sudo apt update
sudo apt install php8.2-dev

sudo add-apt-repository ppa:ondrej/php

sudo apt update

sudo apt install php8.2-dev

[/codesyntax]

then install php8.2-xdebug
[codesyntax lang=”php”]

satria@teddy:~$ sudo apt-get install php8.2-xdebug

1	satria@teddy:~$ sudo apt-get install php8.2-xdebug

[/codesyntax]

check the php version
[codesyntax lang=”php”]

satria@teddy:~$ php -v
PHP 8.2.25 (cli) (built: Oct 30 2024 11:25:56) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.2.25, Copyright (c) Zend Technologies
    with Zend OPcache v8.2.25, Copyright (c), by Zend Technologies
    with Xdebug v3.3.2, Copyright (c) 2002-2024, by Derick Rethans

satria@teddy:~$ php -v

PHP 8.2.25 (cli) (built: Oct 30 2024 11:25:56) (NTS)

Zend Engine v4.2.25, Copyright (c) Zend Technologies

with Zend OPcache v8.2.25, Copyright (c), by Zend Technologies

[/codesyntax]

if not php8.2, you can select it by using
[codesyntax lang=”php”]

satria@teddy:~$ sudo update-alternatives --config php

1	satria@teddy:~$ sudo update-alternatives --config php

[/codesyntax]

CONFIG XDEBUG

sudo gedit /etc/php/8.2/apache2/conf.d/20-xdebug.ini

1	sudo gedit /etc/php/8.2/apache2/conf.d/20-xdebug.ini

SETTING

zend_extension=xdebug.so
xdebug.mode= debug 
xdebug.start_with_request = yes 
xdebug.var_display_max_data = 1024
xdebug.var_display_max_children = 512 
xdebug.var_display_max_depth = 6

zend_extension=xdebug.so

xdebug.mode= debug

xdebug.start_with_request = yes

xdebug.var_display_max_data = 1024

xdebug.var_display_max_children = 512

xdebug.var_display_max_depth = 6

Install Flutter and Android Studio on Ubuntu 22.04

Ref: https://docs.flutter.dev/get-started/install/linux/android

Development tools

To develop Flutter on Linux:

1. Verify that you have the following tools installed: bash, file, mkdir, rm, which

satria@teddy:~$ which bash file mkdir rm which
/usr/bin/bash
/usr/bin/file
/usr/bin/mkdir
/usr/bin/rm
/usr/bin/which

satria@teddy:~$ which bash file mkdir rm which

/usr/bin/bash

/usr/bin/file

/usr/bin/mkdir

/usr/bin/rm

/usr/bin/which

2. Install the following packages: curl, git, unzip, xz-utils, zip, libglu1-mesa

satria@teddy:~$ sudo apt-get update -y && sudo apt-get upgrade -y
satria@teddy:~$ sudo apt-get install -y curl git unzip xz-utils zip libglu1-mesa

1 2	satria@teddy:~$ sudo apt-get update -y && sudo apt-get upgrade -y satria@teddy:~$ sudo apt-get install -y curl git unzip xz-utils zip libglu1-mesa

3. To develop Android apps:
a. Install the following prerequisite packages for Android Studio.

satria@teddy:~$ sudo apt-get install \
    libc6:amd64 libstdc++6:amd64 \
    libbz2-1.0:amd64 libncurses5:amd64

satria@teddy:~$ sudo apt-get install \

libc6:amd64 libstdc++6:amd64 \

libbz2-1.0:amd64 libncurses5:amd64

b. Install Android Studio 2023.3.1 (Jellyfish) or later to debug and compile Java or Kotlin code for Android. Flutter requires the full version of Android Studio.
download and install the latest android studio from https://developer.android.com/studio

If you are running a 64-bit version of Ubuntu, you need to install some 32-bit libraries with the following command:

satria@teddy:~$ sudo apt-get install libc6:i386 libncurses5:i386 libstdc++6:i386 lib32z1 libbz2-1.0:i386

1	satria@teddy:~$ sudo apt-get install libc6:i386 libncurses5:i386 libstdc++6:i386 lib32z1 libbz2-1.0:i386

read the installation note on https://developer.android.com/studio/install#linux

Extract the downloaded file:

satria@teddy:~$ cd Downloads/
satria@teddy:~/Downloads$ tar -xvzf android-studio-*-linux.tar.gz

1 2	satria@teddy:~$ cd Downloads/ satria@teddy:~/Downloads$ tar -xvzf android-studio-*-linux.tar.gz

Move to the android-studio directory:

satria@teddy:~/Downloads$ sudo mv android-studio /opt/

1	satria@teddy:~/Downloads$ sudo mv android-studio /opt/

Run Android Studio:
Navigate to the bin directory and run the installer:

satria@teddy:~/Downloads$ cd /opt/android-studio/bin/
satria@teddy:/opt/android-studio/bin$ ./studio.sh

1 2	satria@teddy:~/Downloads$ cd /opt/android-studio/bin/ satria@teddy:/opt/android-studio/bin$ ./studio.sh

Use VS Code to install Flutter

To install Flutter using these instructions, verify that you have installed Visual Studio Code 1.77 or later and the Flutter extension for VS Code.

Prompt VS Code to install Flutter
#
Launch VS Code.
To open the Command Palette, press Control + Shift + P.
In the Command Palette, type flutter.
Select Flutter: New Project.
VS Code prompts you to locate the Flutter SDK on your computer.

If you have the Flutter SDK installed, click Locate SDK.
If you do not have the Flutter SDK installed, click Download SDK.

This option sends you the Flutter install page if you have not installed Git as directed in the development tools prerequisites.
When prompted Which Flutter template?, ignore it. Press Esc. You can create a test project after checking your development setup.

INSTALL CMAKE (ALSO FOR LINUX APP)
sudo apt install cmake

Launching lib/main.dart on Linux in debug mode…

CMake Error: CMake was unable to find a build program corresponding to “Ninja”. CMAKE_MAKE_PROGRAM is not set. You probably need to select a different build tool.

CMake Error: CMAKE_CXX_COMPILER not set, after EnableLanguage

Error: Unable to generate build files

INSTALL NINJA BUILD
sudo apt install ninja-build

Launching lib/main.dart on Linux in debug mode…

CMake Error at /usr/share/cmake-3.22/Modules/CMakeDetermineCXXCompiler.cmake:48 (message):

Could not find compiler set in environment variable CXX:

clang++.

Call Stack (most recent call first):

CMakeLists.txt:3 (project)

CMake Error: CMAKE_CXX_COMPILER not set, after EnableLanguage

Error: Unable to generate build files

ALSO
satria@teddy:/opt/android-studio/bin$ sudo apt-get install \
clang cmake git \
ninja-build pkg-config \
libgtk-3-dev liblzma-dev \
libstdc++-12-dev
BUT GOT

...
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 libcairo2-dev : Depends: libfontconfig1-dev (>= 2.2.95)
                 Depends: libfreetype6-dev (>= 2.1.10)
 libgtk-3-dev : Depends: libfontconfig1-dev
 libharfbuzz-dev : Depends: libfreetype6-dev
 libpango1.0-dev : Depends: libfontconfig-dev (>= 2.13.0) but it is not installable
                   Depends: libfreetype-dev (>= 2.1.7) but it is not installable
 libxft-dev : Depends: libfontconfig1-dev
              Depends: libfreetype6-dev
E: Unable to correct problems, you have held broken packages.

...

Some packages could not be installed. This may mean that you have

requested an impossible situation or if you are using the unstable

distribution that some required packages have not yet been created

or been moved out of Incoming.

The following information may help to resolve the situation:

The following packages have unmet dependencies:

libcairo2-dev : Depends: libfontconfig1-dev (>= 2.2.95)

Depends: libfreetype6-dev (>= 2.1.10)

libgtk-3-dev : Depends: libfontconfig1-dev

libharfbuzz-dev : Depends: libfreetype6-dev

libpango1.0-dev : Depends: libfontconfig-dev (>= 2.13.0) but it is not installable

Depends: libfreetype-dev (>= 2.1.7) but it is not installable

libxft-dev : Depends: libfontconfig1-dev

Depends: libfreetype6-dev

E: Unable to correct problems, you have held broken packages.

libbrotli-dev : Depends: libbrotli1 (= 1.0.9-2build6)
SOLUTION:

sudo apt install libbrotli1=1.0.9-2build6 libfreetype6-dev libfontconfig1-dev libfreetype6-dev libcairo2-dev libgtk-3-dev libharfbuzz-dev libpango1.0-dev libxft-dev

1	sudo apt install libbrotli1=1.0.9-2build6 libfreetype6-dev libfontconfig1-dev libfreetype6-dev libcairo2-dev libgtk-3-dev libharfbuzz-dev libpango1.0-dev libxft-dev

THEN RE-RUN:
satria@teddy:/opt/android-studio/bin$ sudo apt-get install \
clang cmake git \
ninja-build pkg-config \
libgtk-3-dev liblzma-dev \
libstdc++-12-dev

Install Java and Tomcat on Ubuntu 22.04

READ: https://tecadmin.net/how-to-install-tomcat-on-ubuntu-22-04/
ALSO READ: https://myprojects.advchaweb.com/index.php/2021/09/27/install-tomcat-on-ubuntu-20-04/

INSTALL OPENJDK 11

sudo apt install openjdk-11-jdk

1	sudo apt install openjdk-11-jdk

CHECK JAVA VERSION

satria@teddy:~$ java --version
openjdk 11.0.22 2024-01-16
OpenJDK Runtime Environment (build 11.0.22+7-post-Ubuntu-0ubuntu222.04.1)
OpenJDK 64-Bit Server VM (build 11.0.22+7-post-Ubuntu-0ubuntu222.04.1, mixed mode, sharing)

satria@teddy:~$ java --version

openjdk 11.0.22 2024-01-16

OpenJDK Runtime Environment (build 11.0.22+7-post-Ubuntu-0ubuntu222.04.1)

OpenJDK 64-Bit Server VM (build 11.0.22+7-post-Ubuntu-0ubuntu222.04.1, mixed mode, sharing)

CREATE A TOMCAT USER

sudo useradd -r -m -U -d /opt/tomcat -s /bin/false tomcat

1	sudo useradd -r -m -U -d /opt/tomcat -s /bin/false tomcat

DOWNLOAD TOMCAT 10
AT THE TIME, THE LATEST STABLE VERSION IS 10.1.19. DOWNLOAD THE BINARY (https://dlcdn.apache.org/tomcat/tomcat-10/v10.1.19/bin/apache-tomcat-10.1.19.tar.gz)

EXTRACT IT TO /opt/tomcat DIR

satria@teddy:~/Downloads$ sudo tar xzf apache-tomcat-10.1.19.tar.gz -C /opt/tomcat

1	satria@teddy:~/Downloads$ sudo tar xzf apache-tomcat-10.1.19.tar.gz -C /opt/tomcat

SET THE PERMISSION
First, we’ll change the directory ownership to tomcat.

satria@teddy:~/Downloads$ sudo chown -R tomcat: /opt/tomcat

1	satria@teddy:~/Downloads$ sudo chown -R tomcat: /opt/tomcat

Next, make all scripts within the bin directory executable.

satria@teddy:~/Downloads$ sudo sh -c 'chmod +x /opt/tomcat/apache-tomcat-10.1.19/bin/*.sh'

1	satria@teddy:~/Downloads$ sudo sh -c 'chmod +x /opt/tomcat/apache-tomcat-10.1.19/bin/*.sh'

Create Tomcat Application Accounts
Now, configure your tomcat with user accounts to secure access of admin/manager pages. To do this, edit conf/tomcat-users.xml file in your editor and paste the following code inside <tomcat-users> </tomcat-users> tags. We recommend changing the password in the below configuration with high secured password.

sudo gedit /opt/tomcat/apache-tomcat-10.1.19/conf/tomcat-users.xml

1	sudo gedit /opt/tomcat/apache-tomcat-10.1.19/conf/tomcat-users.xml

ADD THE ROLES

<?xml version="1.0" encoding="UTF-8"?>
...
<tomcat-users xmlns="http://tomcat.apache.org/xml"
              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
              xsi:schemaLocation="http://tomcat.apache.org/xml tomcat-users.xsd"
              version="1.0">
  ...
  <!-- user manager can access only the manager section -->
  <role rolename="manager-gui" />
  <user username="manager" password="Admin@123" roles="manager-gui" />
   
  <!-- user admin can access manager and admin section both -->
  <role rolename="admin-gui" />
  <user username="admin" password="Admin@123" roles="manager-gui,admin-gui" />
</tomcat-users>

<?xml version="1.0" encoding="UTF-8"?>

...

<tomcat-users xmlns="http://tomcat.apache.org/xml"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://tomcat.apache.org/xml tomcat-users.xsd"

version="1.0">

...

</tomcat-users>

Allow Remote Hosts to Access Tomcat
The default Tomcat manager and host-manager applications are accessible for localhost only. To allow access to these pages from the remote system, you need to modify the following configuration files.

You can either allow a specific remote system or allow all. Edit the context.xml file for manager and host manager application:

sudo gedit /opt/tomcat/apache-tomcat-10.1.19/conf/tomcat-users.xml

1	sudo gedit /opt/tomcat/apache-tomcat-10.1.19/conf/tomcat-users.xml

Comment out the section added for IP address restriction to allow connections from anywhere.

<?xml version="1.0" encoding="UTF-8"?>
...
<Context antiResourceLocking="false" privileged="true" >
  <CookieProcessor className="org.apache.tomcat.util.http.Rfc6265CookieProcessor"
                   sameSiteCookies="strict" />
  <!--<Valve className="org.apache.catalina.valves.RemoteAddrValve"
         allow="127\.\d+\.\d+\.\d+|::1|0:0:0:0:0:0:0:1" />-->
  <Manager sessionAttributeValueClassNameFilter="java\.lang\.(?:Boolean|Integer|Long|Number|String)|org\.apache\.catalina\.filters\.CsrfPreventionFilter\$LruCache(?:\$1)?|java\.util\.(?:Linked)?HashMap"/>
</Context>

<?xml version="1.0" encoding="UTF-8"?>

...

<CookieProcessor className="org.apache.tomcat.util.http.Rfc6265CookieProcessor"

sameSiteCookies="strict" />

<!--<Valve className="org.apache.catalina.valves.RemoteAddrValve"

allow="127\.\d+\.\d+\.\d+|::1|0:0:0:0:0:0:0:1" />-->

</Context>

Similarly edit context.xml for host manager application in text editor:

sudo gedit /opt/tomcat/apache-tomcat-10.1.19/webapps/manager/META-INF/context.xml

1	sudo gedit /opt/tomcat/apache-tomcat-10.1.19/webapps/manager/META-INF/context.xml

Create a Systemd Service File
We’ll now create a systemd service file to manage the Tomcat service. Open a new service file in a text editor:

sudo gedit /etc/systemd/system/tomcat.service

1	sudo gedit /etc/systemd/system/tomcat.service

Paste in the following configuration:

[Unit]
Description=Apache Tomcat 10 Web Application Server
After=network.target
 
[Service]
Type=forking
 
User=tomcat
Group=tomcat
 
Environment="JAVA_HOME=/usr/lib/jvm/java-11-openjdk-amd64"
Environment="CATALINA_HOME=/opt/tomcat/apache-tomcat-10.1.19"
Environment="CATALINA_BASE=/opt/tomcat/apache-tomcat-10.1.19"
Environment="CATALINA_PID=/opt/tomcat/apache-tomcat-10.1.19/temp/tomcat.pid"
Environment="CATALINA_OPTS=-Xms512M -Xmx1024M -server -XX:+UseParallelGC"
 
ExecStart=/opt/tomcat/apache-tomcat-10.1.19/bin/startup.sh
ExecStop=/opt/tomcat/bin/apache-tomcat-10.1.19/shutdown.sh
 
[Install]
WantedBy=multi-user.target

[Unit]

Description=Apache Tomcat 10 Web Application Server

After=network.target

[Service]

Type=forking

User=tomcat

Group=tomcat

Environment="JAVA_HOME=/usr/lib/jvm/java-11-openjdk-amd64"

Environment="CATALINA_HOME=/opt/tomcat/apache-tomcat-10.1.19"

Environment="CATALINA_BASE=/opt/tomcat/apache-tomcat-10.1.19"

Environment="CATALINA_PID=/opt/tomcat/apache-tomcat-10.1.19/temp/tomcat.pid"

Environment="CATALINA_OPTS=-Xms512M -Xmx1024M -server -XX:+UseParallelGC"

ExecStart=/opt/tomcat/apache-tomcat-10.1.19/bin/startup.sh

ExecStop=/opt/tomcat/bin/apache-tomcat-10.1.19/shutdown.sh

[Install]

WantedBy=multi-user.target

Start and Enable Tomcat
After creating the service file, reload the systemd daemon to read the new file:

sudo systemctl daemon-reload

1	sudo systemctl daemon-reload

Next, start the Tomcat service with:

sudo systemctl start tomcat

1	sudo systemctl start tomcat

CHECK Tomcat service status

sudo systemctl status tomcat
● tomcat.service - Apache Tomcat 10 Web Application Server
     Loaded: loaded (/etc/systemd/system/tomcat.service; disabled; vendor prese>
     Active: active (running) since Tue 2024-02-27 22:00:28 WIB; 12s ago
    Process: 20153 ExecStart=/opt/tomcat/apache-tomcat-10.1.19/bin/startup.sh (>
   Main PID: 20160 (java)
      Tasks: 29 (limit: 57572)
     Memory: 138.3M
        CPU: 3.931s
     CGroup: /system.slice/tomcat.service
             └─20160 /usr/lib/jvm/java-11-openjdk-amd64/bin/java -Djava.util.lo>

Feb 27 22:00:28 teddy systemd[1]: Starting Apache Tomcat 10 Web Application Ser>
Feb 27 22:00:28 teddy startup.sh[20153]: Tomcat started.
Feb 27 22:00:28 teddy systemd[1]: Started Apache Tomcat 10 Web Application Serv>
lines 1-14/14 (END)

sudo systemctl status tomcat

● tomcat.service - Apache Tomcat 10 Web Application Server

Loaded: loaded (/etc/systemd/system/tomcat.service; disabled; vendor prese>

Active: active (running) since Tue 2024-02-27 22:00:28 WIB; 12s ago

Process: 20153 ExecStart=/opt/tomcat/apache-tomcat-10.1.19/bin/startup.sh (>

Main PID: 20160 (java)

Tasks: 29 (limit: 57572)

Memory: 138.3M

CPU: 3.931s

CGroup: /system.slice/tomcat.service

└─20160 /usr/lib/jvm/java-11-openjdk-amd64/bin/java -Djava.util.lo>

Feb 27 22:00:28 teddy systemd[1]: Starting Apache Tomcat 10 Web Application Ser>

Feb 27 22:00:28 teddy startup.sh[20153]: Tomcat started.

Feb 27 22:00:28 teddy systemd[1]: Started Apache Tomcat 10 Web Application Serv>

lines 1-14/14 (END)

If everything went well, enable Tomcat to start on boot:

sudo systemctl enable tomcat

1	sudo systemctl enable tomcat

Open the Firewall
You also need to check if the firewall is not blocking the incoming connections to Tomcat’s port (default is 8080). This depends on what firewall you are using:

For UFW (Uncomplicated Firewall) in Ubuntu:

satria@teddy:~/Downloads$ sudo ufw allow 8080
Rules updated
Rules updated (v6)

satria@teddy:~/Downloads$ sudo ufw allow 8080

Rules updated

Rules updated (v6)

Test the Installation
The default Tomcat server runs on port 8080. As you have configured Tomcat on your system, you can access web interface from your system. You can access tomcat interfaces by entering your server’s IP address or a domain name pointed to that server, followed by port 8080 in your browser:

http://localhost:8080/

Tomcat Manager App is a web application packaged with the Tomcat server application. The Manager interface provides us with the basic functionality we need to manage our deployed web applications.

Click the Manager App button home page or directly type /manager in the browser URL of the main Tomcat server to access it.
http://localhost:8080/manager/html
user: admin
pass: Admin@123

TOMCAT LOG
THE DEFAULT LOG FILE IS IN /opt/tomcat/apache-tomcat-10.1.19/logs/ DIR!
THE LOG FILE IS /opt/tomcat/apache-tomcat-10.1.19/logs/catalina.out
To change the default location of the log file, edit the startup.sh file and locate the entry: