Jump to content

Recommended Posts

Posted

Hello, I’ve been having issues with the server installation on a Linux vps server, so am interested in having someone to make the installation and also explain the process. 

Posted

Database installation -> Restore a backup
JDK Installation
Upload server files
Fix your server configs
Configure your .sh scripts to launch server
Use a client to connect in game


Ask Google for help for steps 1, 2.

If you can't do 3, 4 or 6 I'm going to cry.

 

Linux scripts are executed like: "./someScript.sh" without the quotes ofc

 

You don't really have to pay anyone to teach you this, Google is your guide.

Posted

My issue is with the database. I can’t connect remotely. I’ve googled it for solutions but any solution I tried didn’t work. I tried to install phpmyadmin, it doesn’t work, MySQL enterprise didn’t work and also tried to connect via ssh from mariadb. I’ve also tried Debian and Ubuntu. 

Posted

what db are you using ? 

 

use

sudo netstat -tulpn | grep 2106

 

post a screenshot here

 

first step is to allow mariadb server to bind on 0.0.0.0 not 127.0.0.1

 

this is done by changing the .conf files usually found in /var/etc (depends on your distro)

 

change the value of bind-address (you can google this)

 

after that's done use

systemctl restart mariadb

 

you should be good,

 

fyi by default remote root is forbidden, create a user @ "%" and give him grant

Posted (edited)

Seamless#7044 add me i can help you with your server installation

You have to 

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

 

And Find the line where 127.0.0.1 and change it to 0.0.0.0.

restart db 

systemctl restart mariadb

After that create new user 

CREATE USER 'test'@'%' IDENTIFIED BY 'test';

 

Create new Database 

CREATE DATABASE l2test; 

if exist just 

USE l2test;

and grand access to user

GRANT ALL PRIVILEGES ON l2test.* TO 'test'@'%' IDENTIFIED BY 'test';

sudo flush privileges;

 

also be sure that port 3306 is open 

Edited by Seamless
Posted

I have changed the bind address and also made a new user with privileges. The port seems to be fine since I get to the point where I have to add password while establishing the connection. I will post more info when I have the time. I contacted also hetzener( my vps provider) but they refused to provide any assistance. 

Posted
4 hours ago, Seamless said:

GRANT ALL PRIVILEGES ON l2test.* TO 'test'@'%' IDENTIFIED BY 'test';

sudo flush privileges;

 

This is what you have to do now if connection establishes, nothing more than that.


btw there are no providers blocking ports by default since he connects and gets error codes the connection is established

Posted
6 minutes ago, xdem said:

 

This is what you have to do now if connection establishes, nothing more than that.


btw there are no providers blocking ports by default since he connects and gets error codes the connection is established

I have already done that.

 

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 0.0.0.0:33060           0.0.0.0:*               LISTEN      915/mysqld          
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      915/mysqld          
tcp        0      0 127.0.0.53:53           0.0.0.0:*               LISTEN      511/systemd-resolve 
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      586/sshd: /usr/sbin 
tcp6       0      0 :::22                   :::*                    LISTEN      586/sshd: /usr/sbin 
udp        0      0 127.0.0.53:53           0.0.0.0:*                           511/systemd-resolve 
udp        0      0 (vps ip):68       0.0.0.0:*                           509/systemd-network 
 

Posted
5 minutes ago, @echo said:

I have already done that.

 

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 0.0.0.0:33060           0.0.0.0:*               LISTEN      915/mysqld          
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      915/mysqld          
tcp        0      0 127.0.0.53:53           0.0.0.0:*               LISTEN      511/systemd-resolve 
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      586/sshd: /usr/sbin 
tcp6       0      0 :::22                   :::*                    LISTEN      586/sshd: /usr/sbin 
udp        0      0 127.0.0.53:53           0.0.0.0:*                           511/systemd-resolve 
udp        0      0 (vps ip):68       0.0.0.0:*                           509/systemd-network 
 

 

this just shows that you are correctly listening to all your network interfaces, we already know that since your sql client gets error codes, your problem now is that you also have to allow the user to be able to login from any ip through @"%"

Guest
This topic is now closed to further replies.


  • Posts

    • Really nice work and another great idea from you Nick. Fermata keeps getting more impressive with every release. The latest work with lighting, world objects, effects and overall scene customization shows how much potential this project really has. It’s not just about making Interlude look better, but about giving an old client modern possibilities while still keeping the original Lineage 2 feeling.   Great work once again, definitely an exciting project to follow!
    • ⚡ Weekend Stock Refresh! Fast order fulfillment is active. Get Gemini Pro Advanced + Google One cloud storage activated on your own personal email within minutes.
    • New Release World & atmosphere A complete dynamic weather system has arrived, with Clear, Light Rain, Rain, Heavy Rain, Storm, Snow, and Windy presets. Rain and snow react to roofs, wind moves foliage, lightning illuminates storms, exposed ground becomes wet and develops puddles, and snow builds up and melts over time. Weather includes Low to Ultra quality levels and advanced controls for precipitation, wind, cloud cover, lightning, surface wetness, puddles, and snow. The game server can also select or restore the current weather while local quality settings continue to control rendering cost. The weather can be controlled from the server with custom packets. For more details use Shift+Alt+P. Enhanced lighting now allows authored lamps, fires, and other light sources to illuminate towns and interiors. Lights can pulse, flicker, blink, and strobe, flames produce warm dynamic light, and lamps display depth-aware halos. Remastered emissive surfaces are now supported, beginning with illuminated windows in Giran that glow and cast light into their surroundings. Broadcasting Towers now use their correct original scale and animated rings and glow effects. Map, quests & navigation A complete quest journal has been added, with active and completed quests, expandable stages, descriptions, requirements, item progress, quest inventory integration, location controls, and quest cancellation. Quest objectives now appear through flashing minimap and world-map markers, an overhead directional guide, a notification button beside chat, and rotating quest symbols above eligible NPCs. Server-directed radar markers now work across the live minimap and world map, including the original overhead guidance effect and arrival behavior. The original tutorial system now works, including scrollable tutorial pages, animated illustrations, the flashing question button, tutorial links, and movement, camera, pickup, and sit/rest progression events. Server-opened town maps now display their original artwork and the supplied player marker. Shops, storage & items Personal, clan, castle, and freight warehouses now work, including deposits, withdrawals, stack quantities, fees, weight and capacity previews, tooltips, and the original warning and empty-storage dialogs. Account freight now works through the original recipient picker and delivery window, allowing items to be sent to another character on the same account. Multisell exchanges now work, with paged recipe lists, product details, required materials, quantity selection, warnings, and server-backed completion. Manor seed purchasing is now supported through the shop interface, including availability and pricing. Inventory items can now be dragged to the trash button and destroyed after the appropriate warning or quantity prompt. The original in-game calculator now works with mouse and keyboard input. Community The Community Board is now available from the system menu or Alt+B, with Home, Favorites, Region, Clan, Memo, Mail, and Friends sections, retained navigation, forms, scrolling, minimization, and server-provided pages. Characters, cameras & events Striders and Wyverns now render as fully animated mounts with the rider attached correctly. Striders remain ground-based, while Wyverns support three-dimensional flight. Characters now enter a proper falling state after high drops or airborne dismounts, with falling animations and server-authoritative landing and fall-damage handling. Players can now sit on authored world chairs using the correct sit, wait, and stand animations. Server-driven special camera sequences now work, including target tracking, interpolation, duration, widescreen bars, and restoration to the normal camera. GM camera mode and server-authorized ///fly movement are now supported. The original 102-second Kamael teaser sequence has been restored with its complete slideshow, transitions, panning artwork, localized subtitles, and narration. Hats, masks, circlets, and other hair accessories now use their authored head placement and correctly adjust the character's hairstyle. Timed server confirmation dialogs, short-duration status effects, regeneration previews, and the seasonal Christmas Seal presentation are now supported. Interface & performance Character creation has been refined with corrected description wrapping, clipping, layout, and name-entry presentation. Tutorial and NPC dialog windows now use polished proportional scrollbars, improved HTML layout, and correctly sized illustrations and controls. A new independent 3D render-resolution setting offers Native, 720p, 900p, 1080p, 1440p, and 4K choices while keeping the window, HUD, text, and FermaUI at native resolution. Major rendering optimizations reduce unnecessary work in local lighting, shadows, visibility, exposure, bloom, post-processing, and GPU diagnostics. Download from the launcher you have installed, or at https://updates.fermata.gg/ if you don't have the launcher. Fermata Light Engine Preview All lights can be baked in the client, shipped to the users, and exported and imported as .femlight files.
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..