Hello Michael,
it depend how you format the partition, so if it's ext3 then mount it as
an ext3.
Also when you start the database can you check where it listen ?
(netstat -nlp| grep 3306)
Also can you paste my.cnf and pf.conf, pfconfig.conf ?
Regards
Fabrice
Le 2017-01-26 à 08:13, Campanaro, Michael a écrit :
>
> My OS is CentOS 7 and this is the output of cat /proc/drbd:
>
>
> [root@packetfence]# cat /proc/drbd
> version: 8.4.9-1 (api:1/proto:86-101)
> GIT-hash: 9976da086367a2476503ef7f6b13d4567327a280 build by
> akemi@Build64R7, 2016-12-04 01:08:48
> 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r-----
> ns:0 nr:0 dw:0 dr:31457236 al:8 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:d
> oos:0
>
>
> What I was trying to say is that if I mount /dev/drbd0 as ext4 like
> the guide says then it becomes read-only. But if I mount it as ext3 it
> is read-write. If I move on with ext3 I get more errors in my
> packetfence logs saying it cannot connect to my database.
>
>
> I'm currently interning for a company that wants me to deploy PF
> on our network and I've gotten everything but the clustering figured
> out. It's my last step before I can deploy so any help would be
> appreciated and thank you for your replies already.
>
>
> -Mike
>
> ------------------------------------------------------------------------
> *From:* Durand fabrice <[email protected]>
> *Sent:* Wednesday, January 25, 2017 9:38 PM
> *To:* [email protected]
> *Subject:* Re: [PacketFence-users] Cluster help
>
>
> Hello Michael,
>
> can you do the following command on both and paste the result:
>
>
> cat /proc/drbd
>
>
> If it's "secondary/secondary" then do drbdadmin primary mysql on one
> of them.
>
>
> Regards
>
> Fabrice
>
>
>
>
> Le 2017-01-25 à 14:05, Campanaro, Michael a écrit :
>>
>> I've been trying to cluster together two Packetfence 6.4 servers
>> together and have been getting nothing but trouble in my attempts.
>> I'm following the Clustering guide word for word but can't seem to
>> get it to work. Everything goes fine up until the point of finalizing
>> the DRBD portion. When I create the ext4 filesystem for /dev/drbd0
>> and then try to mount it at /var/lib/mysql as per the guide, it
>> mounts in read only mode. I cannot move my SQL files back into the
>> folder nor can I write anything to it. I've tried remounting the
>> drive as read-write but I get an error saying the drive is write
>> protected.
>>
>>
>> I've found that a way around this problem is to instead make the
>> /dev/drbd0 device as an ext3 filesystem. I can then move my SQL
>> backup files back into the mysql folder and restart the mariadb
>> process. However, at this point everything breaks on me. I can no
>> longer access the admin gui for packetfence and I get fatal errors in
>> the logs saying "ERROR: Could not write namespace resource
>> ::switches_list to L2 cache!" and "ERROR: Couldn't connect to MySQL
>> database to access L2. This is a major problem!"
>>
>>
>> When this first happened I figured it would all be fixed once I
>> finish all the steps in the cluster guide. But I've now done
>> everything I'm supposed to in the guide and it's still not working
>> properly. The PCS cluster is set up, I can see my master and slave
>> server in the cluster and there are no errors when I run "pcs status."
>>
>>
>> However I'm still not able to log into the admin gui anymore, it
>> tells me I'm using the wrong user name and password. I tried
>> restarting the packetfence service and now it won't start at all
>> anymore. I've been working at this for the past few days and have had
>> no progress. Both servers are virtual machines so I can revert to
>> older snapshots and try everything in the guide multiple times but
>> each time I attempt to set up clustering everything goes wrong.
>>
>>
>> I'm convinced it has something to do with DRBD and mounting in the
>> /var/lib/mysql folder because that's the point where the errors start
>> flowing in. Any help would be appreciated.
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>>
>>
>> _______________________________________________
>> PacketFence-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>
>
> _______________________________________________
> PacketFence-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
--
Fabrice Durand
[email protected] :: +1.514.447.4918 (x135) :: www.inverse.ca
Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence
(http://packetfence.org)
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
