IT Technical Tips & Solutions

Choose between Laravel Sanctum Cookie-Based Vs Token Based and Laravel Sanctum Token Based vs Laravel Passport

2024-11-20T23:40:00.003+08:00

Laravel Sanctum is a package that offers both cookie-based and token-based authentication for Laravel applications:

Cookie-based authentication

This is a good choice for traditional web applications, especially when the front-end and API are on the same domain. Sanctum uses Laravel's built-in cookie-based session authentication services, which provide CSRF protection and session authentication. This approach is ideal for single-page applications (SPAs) that need to communicate with a Laravel API.

Token-based authentication

This is a more secure and scalable option than cookie-based authentication. Sanctum can be used to generate and manage API tokens, authenticate users, and protect API routes. This approach is more suitable for applications that need fast authorization or more interaction between the client and server.

Here are some other considerations when choosing between cookie-based and token-based authentication:

Domain

If the front-end and API are on different domains, cookie-based authentication may not be suitable.

Third-party API consumption

If the application involves third-party API consumption, you'll need to decide between Passport and Sanctum for API token authentication.

OAuth2

If the application requires the full range of OAuth2 features, Passport is the right choice.

Golang: Dynamic Array sample

2022-03-04T18:13:00.002+08:00

sample code of dynamic array in Golang.

// You can edit this code!

// Click here and start typing.

package main

import "fmt"

type Arr struct {

arr []string

}

type SError struct {

code int32

message string

}

func main() {

newArr := &Arr{arr: []string{"a", "b", "c", "d", "e", "f", "g"}}

fmt.Println(newArr.size())

str, err := newArr.get(8)

if err != nil {

fmt.Println(err)

} else {

fmt.Printf("item value = %s", str)

}

newArr.set(10, "asssss")

err = newArr.removeAt(10)

if err != nil {

fmt.Println(err)

} else {

fmt.Printf("removed with index : %v", newArr.arr)

}

err = newArr.remove("fasd")

if err != nil {

fmt.Println(err)

} else {

fmt.Printf("remove with string: %v", newArr.arr)

}

func (arr *Arr) get(i int) (string, *SError) {

if i > arr.size()-1 || i < 0 {

return "", &SError{code: 5, message: fmt.Sprintf("Error accesing index %d from array.", i)}

}

return arr.arr[i], nil

}

func (arr *Arr) set(i int, v string) *SError {

if i > arr.size()-1 || i < 0 {

return &SError{code: 4, message: fmt.Sprintf("%d not exists in the array.", i)}

}

arr.arr[i] = v

return nil

}

func (arr *Arr) add(v string) {

arr.arr = append(arr.arr, v)

}

func (arr *Arr) removeAt(i int) *SError {

if i > arr.size()-1 || i < 0 {

return &SError{code: 3, message: fmt.Sprintf("Error removing index %d from array.", i)}

}

arr.arr = append(arr.arr[:i], arr.arr[i+1:arr.size()]...)

return nil

}

func (arr *Arr) remove(v string) *SError {

if arr.size() == 0 {

return &SError{code: 1, message: "Array is empty"}

}

// find the index

for k, val := range arr.arr {

if val == v {

// and removeAt

arr.removeAt(k)

return nil

}

return &SError{code: 2, message: fmt.Sprintf("Error removing %s from array.", v)}

}

func (arr *Arr) size() int {

return len(arr.arr)

}

to copy a file from a docker container to host

2020-10-20T19:34:00.007+08:00

shell> docker cp <containerId>:/file/path/within/container /host/path/target

where to get your docker container id?

shell> docker ps

and you will get to see similar output in your command prompt as following:

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

fff29505492e localstack_redis:latest "docker-entrypoint.s…" 2 weeks ago Up 8 hours 0.0.0.0:6379->6379/tcp gifted_wozniak

2e99dabb5692 localstack_mysql:latest "docker-entrypoint.s…" 2 weeks ago Up 8 hours 0.0.0.0:3306->3306/tcp vibrant_chandrasekhar

7438b2ef7cbb localstack_prom2teams:latest "sh prom2teams_start…" 2 weeks ago Up 8 hours 8089/tcp cranky_merkle

Case : to copy a file in your docker location such as /tmp/target.txt from localstack_mysql:latest.

shell> docker cp 2e99dabb5692:/tmp/target.txt c:/tmp/

To Delete all data from Kafka Topic - in a manual way

2020-06-16T14:44:00.001+08:00

to delete the data inside the topic:

Steps:

stop the Kafka server & zookeeper
go into this folder - > gerrit\backend\docker\zk-single-kafka-single\kafka1\data
and delete all the "XXX" topic folder
start the kafka & zookeeper

Java: To read file from JAR file classpath

2020-05-22T03:18:00.000+08:00

if the *.xml file and .config or even some other file are located in different jars, make sure you use

resource.getInputStream()

NOT

resource.getFile()

when you are loading a file from inside a jar.

Install Maven in Mac OSX

2019-10-06T02:00:00.002+08:00

to install maven in Mac OSX, the easiest way is to use Homebrew

OR using the following steps:

Download maven from https://maven.apache.org
unzip the apache maven zip file into a location when you fix /User/XXX/Desktop/dev/apache-maven-X.X.X
then you would need to add the maven folder into your user's MacOSX path using vi or other text editor tools

shell> vi ~/.bash_profile

file content

export M2_HOME=/path/to/your/maven/folder . (e.g: /User/XXX/Desktop/dev/apache-maven-X.X.X)

export PATH=$PATH:$M2_HOME/bin

save the file by press "ESC" button, then type this command -> ":wq!"
you would need to refresh the system PATH using following command

shell> source ~/.bash_profile

after that, type shell> mvn --version

Spring: Clean up CacheManager Java code

2018-12-12T23:43:00.001+08:00

If you had use @Cacheable for your java method, and would like clear the cache on run time.
AND If you are able to execute a groovy script, following solution is for you

Groovy Script

import org.springframework.cache.CacheManager;
cacheManager = spring.getBean("cacheManager");

for(String name:cacheManager.getCacheNames()){
cacheManager.getCache(name).clear();
}

Best Implementation for hasCode method

2016-06-19T18:28:00.005+08:00

All relevant fields from the object should be included in the hashCode method. Derived fields may be excluded. In general, any field used in the equals method must be used in the hashCode method.

Proposed in Josh Bloch's Effective Java in item 8. The best thing is to look it up there because the author explains there why the approach is good.

A short version

Create a int result and assign a non-zero value.
For every field f tested in the equals() method, calculate a hash code c by:
- If the field f is a boolean: calculate (f ? 0 : 1);
- If the field f is a byte, char, short or int: calculate (int)f;
- If the field f is a long: calculate (int)(f ^ (f >>> 32));
- If the field f is a float: calculate Float.floatToIntBits(f);
- If the field f is a double: calculate Double.doubleToLongBits(f) and handle the return value like every long value;
- If the field f is an object: Use the result of the hashCode() method or 0 if f == null;
- If the field f is an array: see every field as separate element and calculate the hash value in a recursive fashion and combine the values as described next.
Combine the hash value c with result:
```
result = 37 * result + c
```
Return result

This should result in a proper distribution of hash values for most use situations.

@Override 
public int hashCode() {

    // Start with a non-zero constant. Prime is preferred
    int result = 17;

    // Include a hash for each field.

    // Primatives

    result = 31 * result + (booleanField ? 1 : 0);                   // 1 bit   » 32-bit

    result = 31 * result + byteField;                                // 8 bits  » 32-bit 
    result = 31 * result + charField;                                // 16 bits » 32-bit
    result = 31 * result + shortField;                               // 16 bits » 32-bit
    result = 31 * result + intField;                                 // 32 bits » 32-bit

    result = 31 * result + (int)(longField ^ (longField >>> 32));    // 64 bits » 32-bit

    result = 31 * result + Float.floatToIntBits(floatField);         // 32 bits » 32-bit

    long doubleFieldBits = Double.doubleToLongBits(doubleField);     // 64 bits (double) » 64-bit (long) » 32-bit (int)
    result = 31 * result + (int)(doubleFieldBits ^ (doubleFieldBits >>> 32));

    // Objects

    result = 31 * result + Arrays.hashCode(arrayField);              // var bits » 32-bit

    result = 31 * result + referenceField.hashCode();                // var bits » 32-bit (non-nullable)   
    result = 31 * result +                                           // var bits » 32-bit (nullable)   
        (nullableReferenceField == null
            ? 0
            : nullableReferenceField.hashCode());

    return result;

}

@Override
public int hashCode(){
    return Objects.hashCode(this.firstName, this.lastName);
}

public class Person {
String name;
int age;
boolean smoker;
...

public int hashCode() {
// you pick a hard-coded, randomly chosen, non-zero, odd number
// ideally different for each class
return new HashCodeBuilder(17, 37).
append(name).
append(age).
append(smoker).
toHashCode();
}
}

If required, the superclass hashCode() can be added using appendSuper(int).

Import CSV into MSSQL database

2014-12-10T08:36:00.004+08:00

Use the MSSQL command following, to import the CSV file into the Microsoft SQL (MSSQL) table

MSSQL command:

BULK
INSERT [dbo].[TABLE_NAME]FROM 'c:\files.csv'WITH(FIELDTERMINATOR = ',',ROWTERMINATOR = '\n')GO

Windows 2008 R2 can't see the created ODBC connection from ODBC manager

2014-11-24T23:19:00.001+08:00

32-bit ODBC on Windows Server 2008 R2

Heterogeneous data access requires having the right drivers. If you have to use 32-bit ODBC drivers, you won’t find then when you start the Microsoft ODBC Administrator because it is 64-bit.
The 32-bit ODBC Administrator is found here: C:\Windows\SysWOW64\odbcad32.exe

You might want to make a shortcut for it to make it easy to find. You’ll need to use it when make 32-bit ODBC data connections.

[MySQL] Invalid query: Thread stack overrun: 4904 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

2013-01-16T00:20:00.001+08:00

If you happened to get error as following while you are calling the Stored Procedure

ERROR SHOWN:

Query:
CALL detailReport2("admin777f5a4d5b4e1415af6b2761d75d212c", "01/01/2013", "31/01/2013", "ahmad.alias", "");

Invalid query: Thread stack overrun: 4904 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

Solution:

1. Stop your MySQL server

2. edit your my.cnf file, to add a new line or modify the existing line as following:

file my.cnf

thread_stack = 256K

3. Resume your MySQL server, you shall solve the issue/ error now

[Centos Linux] Configure Network interface : eth0/1

2012-11-29T09:42:00.001+08:00

1. to bring a network card up ::

shell> /sbin/ifconfig eth0 up

2. configure the network card from the following location::::

shell> /etc/sysconfig/network-scripts/ifcfg-<interface-name>

IPADDR=10.10.29.66

NETMASK=255.255.255.192

ONBOOT=yes

3. configure network file

shell> vi /etc/sysconfig/network

NETWORKING=yes

HOSTNAME=www1.nixcraft.in

GATEWAY=10.10.29.65

4. Afterward, you may restart the network by execute the following command

shell>/sbin/service network restart

MySQL Replication Error: Error_code: 1205; handler error HA_ERR_LOCK_WAIT_TIMEOUT

2012-09-11T11:28:00.003+08:00

Environment: MySQL Replication Slave Server
Error:
Could not execute Update_rows event on table
; Lock wait timeout exceeded; try restarting transaction, Error_code: 1205; handler error HA_ERR_LOCK_WAIT_TIMEOUT; the event's master log mysql-bin.003169, end_log_pos 1006784578

Solution:
Shall you face any issue as above when you execute mysql>show slave status;
the solution is as simple as following
shell> stop slave;
shell> start slave;

hyperic agent behind firewall

2012-08-22T12:01:00.000+08:00

If a hyperic agent is setup behind a firewall, however the hyperic server is setup not within the firewall.
Please open/allow the "RPC" services in the firewall rules.
The hyperic agent need it to contact to the hyperic server.

uninstall mysql in linux - via RPM

2012-07-10T01:00:00.001+08:00

If you would like to uninstall MySQL server from your redhat/centos linux using RPM, following the below steps:

1. Double confirm if Mysql is install via RPM, command as follow

Shell> rpm -qa | grep -i mysql

Expecting output result as following

Output 1:

Shell> rpm -qa | grep -i mysql

MySQL-devel-x.x.xx-1.rhel5

MySQL-test-x.x.xx-1.rhel5

MySQL-server-x.x.xx-1.rhel5

MySQL-client-x.x.xx-1.rhel5

MySQL-shared-x.x.xx-1.rhel5

MySQL-shared-compat-x.x.xx-1.rhel5

MySQL-embedded-x.x.xx-1.rhel5

2. If you are getting similar OUTPUT 1 as your result from step 1, you may run the following command to completely remove the MYSQL from your redhat/centos linux

shell> rpm -e MySQL-*

3. After your step 2, you are expecting to already removed the MySQL installation.

you may check if your MySQL data directory (datadir) is still there. Normal MySQL data directory (datadir) locate at /var/lib//mysql

apache running services - lt-httpd -k start -DSSL

2012-05-17T15:53:00.001+08:00

a weird case i ever experience today, maybe it sounds weird to me only.

a normal running apache server would have the following output(Output1), when you run linux command shell> ps -ef | grep httpd

Output1:

root 1373 1 0 15:34 ? 00:00:00 /usr/sbin/.libs/lt-httpd -k start -DSSL

apache 1375 1373 0 15:34 ? 00:00:00 /usr/sbin/.libs/lt-httpd -k start -DSSL

apache 1376 1373 0 15:34 ? 00:00:00 /usr/sbin/.libs/lt-httpd -k start -DSSL

apache 1377 1373 0 15:34 ? 00:00:00 /usr/sbin/.libs/lt-httpd -k start -DSSL

apache 1378 1373 0 15:34 ? 00:00:00 /usr/sbin/.libs/lt-httpd -k start -DSSL

apache 1379 1373 0 15:34 ? 00:00:00 /usr/sbin/.libs/lt-httpd -k start -DSSL

root 1387 26065 0 15:34 pts/6 00:00:00 grep httpd

My Case:

However, i only have following output (Output2), when i run linux command shell> ps -ef | grep httpd

Output2:

apache 30008 1 0 Mar27 ? 00:00:00 /usr/sbin/.libs/lt-httpd -k start -DSSL

When i try to restart the apache server via command shell> /sbin/service httpd restart

i get the following error show (Output3),

Output3:

Stopping httpd: [FAILED]

Starting httpd: [Thu May 17 14:47:56 2012]

(98)Address already in use: make_sock: could not bind to address [::]:80

(98)Address already in use: make_sock: could not bind to address 0.0.0.0:80

no listening sockets available, shutting down

Unable to open logs

Solution:

The lt-httpd service is part of the Apache server's service, hence i make up the decision to kill the process shell> kill 30008

After the process being killed, i'm able to start and stop my apache server again.

Explanation:

The reason of why only one and the only "/usr/sbin/.libs/lt-httpd -k start -DSSL" in the services list, if because due to the incomplete startup of the apache server after the physical server restart. Which then had causing the port 80 being hold by the handicapped apache service.

Because the restart features of the apache not able to shutdown the handicapped apache service, hence it always throw exceptions/error when you trying to restart/stop the apache server.

*Welcome any comments to share your point of view. Thanks very much.

how to check in linux if port is occupied?

2012-05-09T02:05:00.001+08:00

shell> netstat -a | grep <portno>

result should be somethings similar as following

_________________________________________________________________________________

unix 3 [ ] STREAM CONNECTED 3821446054 /var/run/dovecot/login/default

unix 3 [ ] STREAM CONNECTED 3821446052

unix 3 [ ] STREAM CONNECTED 3821446037

unix 3 [ ] STREAM CONNECTED 3821446036

unix 3 [ ] STREAM CONNECTED 3821442460 /var/run/dovecot/login/default

unix 3 [ ] STREAM CONNECTED 3821442450

unix 3 [ ] STREAM CONNECTED 3821442430

unix 3 [ ] STREAM CONNECTED 3821442429

________________________________________________________________________________

Linux - login FTP to transfer file to FTP server

2012-02-08T15:47:00.001+08:00

1. change the location of the current working directory into the directory where the files you are ready to upload

shell> cd /home/xxxx/

2. login into ftp server

shell> ftp ftp.xxx.com

3. server will prompt "Name (ftp.xxx.com:user):"

which from here, you would need to type in your FTP username, following with

"Password:" after you pressed Enter.

4. FTP server will show message as following if user successfully login

230 User ee@xxx.com logged in

Remote system type is UNIX.

Using binary mode to transfer files.

5. you are ready to transfer file from local to FTP server now.

6. In case you are transfer MySQL server installation rpm files

ftp> mput MySQL-*.rpm

IF, you are transferring one file, use following instead

ftp> put MySQL-client-5.5.9-1.linux2.6.x86_64.rpm

7. Message will prompt, after Enter from step 6

"mput MySQL-client-5.5.9-1.linux2.6.x86_64.rpm?"

press Enter, and the transfer start

8. to check if the file is exists in the FTP server, do as following

ftp> ls

9. After confirm everythings is ok, disconnect from FTP server

ftp> quit

Safely rename a database command

2012-01-18T10:35:00.001+08:00

 shell> mysqladmin -u root -pXXXX create spm_new
 shell> mysqldump -u root -pXXXXX SPM | mysql -u root -pXXXX spm_new &

 first, create the new database (with no tables)

 secondly, use mysqldump to dump from the original database to the new db. if you connect remotely into the server. Please do allow the mysqldump process to run in background by adding  "&"

MySQL Replication - slave status showing LastSQLError

2012-01-10T12:14:00.001+08:00

If you would need to skip the SQL command from reflect into the slave server, do as following

STEPS:

1. mysql> stop slave;

2. mysql>SET GLOBAL sql_slave_skip_counter = 1;

3. mysql> start slave;

you should be able to see the slave process change into healthy state again.

MySQL - ERROR 13 (HY000): Can't get stat of '/mnt/sharing/success_20111201.csv' (Errcode: 13)

2012-01-09T14:32:00.001+08:00

I was tried to restore the CSV file into one of my table, however i face the following error

ERROR 13 (HY000): Can't get stat of '/mnt/sharing/<file>.csv' (Errcode: 13)

Follow the following solution to solve your issue,

1. move the file into a location where your "mysql" user have the permission to read and write

2. in your mysql shell ( after you had login MySQL server via mysql client )

e.g:

mysql > load data local infile '/tmp/success_20111201.csv' into table `nplay_temp`.`sms_out_message` fields terminated by '\t' optionally enclosed by '"' lines terminated by '\n' (`id`, `nplay_user_id`, `price`, `is_ucs`, `creation_date`, `last_modified`, `wappush_link`, `retry_count`, `msisdn`, `message`, `delivered_time`, `state`, `mcc`, `operator_code`, `service_name`, `action`, `ticket_id`, `scheduled_time`, `short_code`, `charge_msisdn`, `meta_data`)

to repair a corrupted myisam table

2012-01-05T14:39:00.001+08:00

first, to make sure the table not in use.

you may use the mysql client utility ready by mysql server installation "mysqlcheck" to do the repair

sample command as follow:

shell> mysqlcheck -u <user_name> -p<password> --auto-repair <database_name> <table_name> &

undefined symbol: apr_atomic_xchgptr

2011-12-19T10:15:00.001+08:00

When compiling SVN server, and you get this error

undefined symbol: apr_atomic_xchgptr

for my cases, it's due to the SVN library pointing the /usr/lib64 rather than apache's apr, hence you need to recompile your SVN server by pointing your library to where your apache APR located

To find the installed path for a package in Linux

2011-12-16T14:14:00.001+08:00

Try this:
rpm -ql packagename

To find a file anywhere on your system:
locate filename
find / -name filename

Fixing a php.ini configuration file location problem

2011-12-09T11:53:00.001+08:00

to request the server to change the location where it should read the php.ini from?

Just add an entry in httpd.conf (/etc/httpd/conf/httpd.conf) as following:

PHPIniDir  "/etc"

* make sure your php.ini is under /etc/php.ini