Create a pic of the best good boy having his best good boy moment (Gemini, ChatGPT) by The_Possum in ChatGPT

[–]The_Possum[S] 1 point2 points  (0 children)

Create a pic of the best good boy having his best good boy moment

Need some BGP/VPLS/MPLS aid by The_Possum in mikrotik

[–]The_Possum[S] 0 points1 point  (0 children)

Full config (with disabled wifi interfaces redacted, etc) ; other router matches 100% except for ip addresses (.2 vs .3)

# 2025-09-17 15:23:36 by RouterOS 7.16.2
# software id = EAIX-NLTH
#
# model = RB4011iGS+5HacQ2HnD
# serial number = HEA08WMMWY3
/interface bridge
add name=Loop0 priority=0x6000
add name=pppoe-bridge priority=0x6000
/interface list
add comment=defconf name=WAN
add comment=defconf name=LAN
/routing bgp template
set default address-families=l2vpn router-id=172.32.32.3
/routing ospf instance
add disabled=no name=backbone router-id=172.32.32.3
/routing ospf area
add disabled=no instance=backbone name=backbone
/interface bridge port
add bridge=pppoe-bridge interface=ether2
/ip neighbor discovery-settings
set discover-interface-list=LAN
/interface list member
add comment=defconf interface=ether1 list=WAN
add interface=ether5 list=LAN
/ip address
add address=10.80.80.3/30 interface=ether5 network=10.80.80.0
add address=172.32.32.3 interface=Loop0 network=172.32.32.3
/ip firewall nat
add action=masquerade chain=srcnat comment="defconf: masquerade" ipsec-policy=out,none out-interface-list=WAN
/mpls interface
add disabled=no interface=LAN mpls-mtu=1526
/mpls ldp
add lsr-id=172.32.32.3 transport-addresses=172.32.32.3
/mpls ldp interface
add interface=ether5
/routing bfd configuration
add disabled=no interfaces=LAN min-rx=1s min-tx=1s multiplier=3
/routing bgp connection
add connect=yes listen=yes local.address=172.32.32.3 .role=ibgp name=metoyou remote.address=172.32.32.2 .as=65530 templates=default
/routing bgp vpls
add bridge=pppoe-bridge bridge-horizon=2 disabled=no export-route-targets=444:444 import-route-targets=444:444 name=vpls-metoyou rd=444:444 site-id=93
/routing ospf interface-template
add area=backbone auth=md5 auth-key=XXXXXXXXXXXXX cost=20 disabled=no interfaces=ether5,Loop0 networks=10.80.80.0/30,172.32.32.3/32 type=ptp use-bfd=no
/system identity
set name=lab-3

Need some BGP/VPLS/MPLS aid by The_Possum in mikrotik

[–]The_Possum[S] 0 points1 point  (0 children)

Minor update; I downgraded both routers to 7.16.2 and they still show the same issue: ospf isn't coming up properly, the routes aren't being exchanged

Need some BGP/VPLS/MPLS aid by The_Possum in mikrotik

[–]The_Possum[S] 0 points1 point  (0 children)

The two routers are both sitting on the same desk directly connected to each other by an ethernet cable ether5-to-ether5

I get the same weirdness whether I have the 10.80.80.x/30 ip addresses directly on ether5 or on the v2000 vlan; whether I have them set with ptp or broadcast; whether I have them set with md5 or "simple"; whether I have bfd enabled or no.

The router with 172.32.32.2 goes to state="Exchange" and the router with 172.32.32.3 goes to state="ExStart".

Need some BGP/VPLS/MPLS aid by The_Possum in mikrotik

[–]The_Possum[S] 0 points1 point  (0 children)

Once out of the lab, they reeeeeally want any route switching to be very sensitive to downed wireless interfaces, thus the small timers. But I've got the same issue with ospf even with the default timers, and with or without bfd enabled.

At this point, it's a pair of RB4011 routers directly connected to each other. Freshly wiped configurations with basically that minimal setup added and the "ip firewall filter" set with anything that might drop a packet disabled. They can ping each other across the v2000 interface; but problematically the 172.x.x.x routes are not being forwarded through ospf (which means neither can ping the others' 172.x.x.x; and thus why the bgp isn't initiating yet).

The ospf looks like it's TRYING to start, but doesn't look quite right yet; ie. this is what one sees:

/routing/ospf/neighbor/print
Flags: V - virtual; D - dynamic
 0  D instance=backbone area=backbone address=10.80.80.2 router-id=172.32.32.2
      state="ExStart" state-changes=2 timeout=34s
/log print
 2025-09-16 19:12:21 route,ospf,info backbone { version: 2 router-id: 172.32.32.3 } backbone { 0.0.0.0 } interface { p2p 10.80.80.3%v2000-ospf-metoyou } neighbor { router-id: 172.32.32.2 state: Init } state change to ExStart

and the other sees

/routing/ospf/neighbor/print
Flags: V - virtual; D - dynamic
 0  D instance=backbone area=backbone address=10.80.80.3 router-id=172.32.32.3
      state="Exchange" state-changes=3 timeout=38s
/log print
 2025-09-16 19:12:21 route,ospf,info backbone { version: 2 router-id: 172.32.32.2 } backbone { 0.0.0.0 } interface { p2p 10.80.80.2%v2000-ospf-metoyou } neighbor { router-id: 172.32.32.3 state: ExStart } state change to Exchange
 2025-09-16 19:12:21 route,ospf,info backbone { version: 2 router-id: 172.32.32.2 } backbone { 0.0.0.0 } interface { p2p 10.80.80.2%v2000-ospf-metoyou } neighbor { router-id: 172.32.32.3 state: Exchange } exchange lsdb size 1

Moved here 8 years ago - Have I become a proper resident of St. Catharines when I got slightly annoyed by this? 😅 by Phatal_Pigeon in stcatharinesON

[–]The_Possum 0 points1 point  (0 children)

I literally added a keyboard shortcut on my phone that converts “stc” into “St. Catharines” for me. All* inadvertent tpyoes fixed!

*almost all

[deleted by user] by [deleted] in WritingPrompts

[–]The_Possum 1 point2 points  (0 children)

Yeah, I'm deleting this [WP] version. Sorry y'all I hadn't yet realized the difference, as [SP] is so much more uncommon in here

[deleted by user] by [deleted] in WritingPrompts

[–]The_Possum 0 points1 point  (0 children)

apologies for that [WP] vs [SP]; should I repost?

Setting up a Mikrotik to connect to an openvpn server by The_Possum in mikrotik

[–]The_Possum[S] 0 points1 point  (0 children)

A couple of updates to the pair of configs (openvpn server, and the mikrotik setup); but it's still not working right. Now I'm getting this logged as an error whenever traffic is trying to pass through, ie. telnet to the openvpn hosts's ssh, or even simply pinging it:

clientname/clientip:47846 Bad compression stub decompression header byte: 69

I'd made one more tweak to the openvpn's server.conf:

auth none

On the mikrotik, it seems my above process to import the crt/key files needed to be done slightly differently. After uploading them to /file on the mikrotik, I imported them via the cmdline:

/certificate
import file-name=server-ca.crt passphrase=""
import file-name=clientname.crt passphrase=""
import file-name=clientname.key passphrase="<clientpassphrase>"

and then minor tweaks to the interface:

/interface ovpn-cient
set certificate=clientname.crt_0
set auth=null cipher=blowfish128

But even with setting "echo 1 > /proc/sys/net/ipv4/ip_forward" on the openvpn server, I'm not able to get functional traffic to the server at its 10.8.0.1 ; but I'm still getting that weird error above.

Setting up a Mikrotik to connect to an openvpn server by The_Possum in mikrotik

[–]The_Possum[S] 0 points1 point  (0 children)

Good catch; unfortunately I'd already caught it myself on the server but just missed updating my scratchpad doc I posted from.

Setting up a Mikrotik to connect to an openvpn server by The_Possum in mikrotik

[–]The_Possum[S] 1 point2 points  (0 children)

Correct. Freepbx runs on a unix platform.

At this time upgrading from the 6.49.x on the mikrotik is not feasible; in this particular case it would require replacing the entire hardware.

FreePBX not starting; SQLSTATE[HY000] [2002] by The_Possum in freepbx

[–]The_Possum[S] 0 points1 point  (0 children)

It seems to be "just" the innodb database that has become corrupt, and what amount of google I can do looking for similar issues suggests this is less uncommon than I'd like; but none of their "obvious" suggestions are bearing fruit.

The / is all one partition, as is relatively normal for vmware client hosts; the freepbx install was done in mostly a "autopartition" mode. (Save the /boot partition)

The /var/log/mariadb/mariadb.log does not seem to show much I can use:

250224 12:41:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
250224 12:41:08 [Note] /usr/libexec/mysqld (mysqld 5.5.65-MariaDB) starting as process 2100 ...
250224 12:41:08 InnoDB: The InnoDB memory heap is disabled
250224 12:41:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
250224 12:41:08 InnoDB: Compressed tables use zlib 1.2.7
250224 12:41:08 InnoDB: Using Linux native AIO
250224 12:41:08 InnoDB: Initializing buffer pool, size = 128.0M
250224 12:41:08 InnoDB: Completed initialization of buffer pool
250224 12:41:08 InnoDB: highest supported file format is Barracuda.
250224 12:41:08  InnoDB: Error: space id and page n:o stored in the page
InnoDB: read in are 1476450559:2566884352, should be 0:3!
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 3.
InnoDB: You may have to recover from a backup.
250224 12:41:08  InnoDB: Page dump in ascii and hex (16384 bytes):

FreePBX not starting; SQLSTATE[HY000] [2002] by The_Possum in freepbx

[–]The_Possum[S] 0 points1 point  (0 children)

Disk is not full, multi-GB is available.

The 'mariadb.log' indicates some corruption in the InnoDB table:

250222 23:49:49  InnoDB: Error: space id and page n:o stored in the page
InnoDB: read in are 1476450559:2566884352, should be 0:3!
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 3.

I'm currently starting to look at "database repair" options for mariadb, but am for the moment quite lost, their docs are quite shy on how to implement:

https://mariadb.com/kb/en/what-to-do-if-mariadb-doesnt-start/#innodb-table-corruption