Re: [libreoffice-users] Re: LO 5.2.6 crashes when logging in to mysql with Base

Hi,

Don't know if it's going to help you, but I have experienced some
unexplainable crashes in the past which were "cured" by erasing the
user configuration folders/data in ~/.config/libreoffice. Word of
caution: erasing that folder will reset all settings to their default
value. And I do mean all of them. One test you could do is to rename
the folder, launch LO and see if the problem still exists; if it does,
erase the new config folder and rename your previous one back, at least
you will not loose anything.

I hope this helps.

Rémy Gauthier.

Le jeudi 06 juillet 2017 à 13:24 -0700, Girvin Herr a écrit :
> Paul,
>
> > No, I haven't seen that. I filed it away for future reference if I
ever 
> > look at ODBC again, thanks. I looked at ODBC years ago and decided
the 
> > JDBC Connector was better suited for me. It has been working for me
for 
> a long time until now.
>
> I still think my problem lies in the many Slackware packages, both 
> > security and non-security, I installed on my workstation between when
LO 
> was last working on June 19 and the day before I noticed it stopped 
> working, July 4. This morning, I verified LO 5.2.6.2 does work on my 
> Slackware Linux laptop with updates installed up to the beginning of 
> > May. That is about a month before the last time LO worked, so it
should 
> > be a good starting point. My plan is to install the Slackware
updates 
> > one at a time, checking if LO is still functional between each one.
When 
> > and if LO stops working, the package I just installed is most likely
the 
> culprit and I can back it out again, hopefully restoring LO to 
> functionality. I can then try backing out the same package on my 
> > workstation and hopefully get it working again. At least that is my
plan.
> Thanks again.
> Girvin
>
>
> On 07/06/2017 10:57 AM, Paul D. Mirowsky wrote:
> > Nothing specific, but it is an edge case sometimes missed when 
> > updating/adding other linux software.
> >
> > Have you seen 
> > > > https://ask.libreoffice.org/en/question/79135/how-do-i-set-up-a-odb
c-connector-for-mariadb-in-base/
> > On 7/6/2017 1:11 PM, Girvin Herr wrote:
> > > > > > Thanks for your response. groups? In what way? Anything specific
I 
> > > should be aware of from your experience? Does something with LO 
> > > > > > require a special group, like k3b "suggests" a "burner" group,
which 
> > > > > > I would need to be a member of to burn CDs? I just checked the
group 
> > > file and didn't see anything out of the ordinary or any group I 
> > > should be a member of and am not.
> > >
> > > Since this problem seems ubiquitous across many LO versions and 
> > > across other user accounts on my machine that I tested, I am now 
> > > > > > doubting this issue is a LO problem. Although it may be a
problem 
> > > > > > which only LO encounters, since no other apps, including AOO,
are 
> > > > > > having any problems. I am going off to do some troubleshooting
with 
> > > > > > another similar computer which has not been updated yet since the
end 
> > > > > > of March. Hopefully, it will work and I can incrementally install
the 
> > > > > > security updates one at a time while retesting LO for crashing
after 
> > > > > > each installation. Hopefully, the culprit update package will
show 
> > > > > > itself. So, I may be off for a while, but if I discover anything,
I 
> > > > > > will post it here on this thread. I will keep your suggestion in
mind 
> > > as I am troubleshooting.
> > >
> > > Thanks.
> > > Girvin
> > >
> > >
> > > On 07/06/2017 07:54 AM, Paul D. Mirowsky wrote:
> > > > Just a shot in the dark.
> > > >
> > > > May want to look to see all proper groups are set.
> > > >
> > > >
> > > >
> > > > On 7/5/2017 6:56 PM, Girvin Herr wrote:
> > > > > On 07/05/2017 02:14 AM, Alexander Thurgood wrote:
> > > > > > Le 05/07/2017 à 01:20, Girvin Herr a écrit :
> > > > > >
> > > > > > Hi Girvin,
> > > > > >
> > > > > >
> > > > > > > > > > > > > > Now that I upgraded to LO 5.2.6.2 from LO 5.1.6, every
time I try 
> > > > > > > to log
> > > > > > > > > > > > > > in to Mariadb to access my database, LO crashes hard.
This worked 
> > > > > > > fine
> > > > > > > > > > > > > > in 5.1.6 and it still works now in OpenOffice 4.1.3. I
checked 
> > > > > > > the Java
> > > > > > > > > > > > > > config under Options and it is fine. I tried deleting the
profile
> > > > > > > > > > > > > > directory and starting from scratch. It still crashed. LO
also 
> > > > > > > crashes
> > > > > > > when I use the "Test Connection" button in the database 
> > > > > > > configuration
> > > > > > > dialog to try to log in to Mariadb.
> > > > > > >
> > > > > > > Any ideas before I return to 5.1.6?
> > > > > > > > > > > > Could be several things, although off the cuff, LO5.2.x was
known to
> > > > > > crash in certain circumstances with JDKu112, so either:
> > > > > > - revert back to LO5.1.x or else
> > > > > > > > > > > > - try updating your JDK to a much more recent one and see
if that 
> > > > > > makes
> > > > > > a difference with LO5.2.x, or else
> > > > > > - move to LO5.3.x and a current JDK.
> > > > > >
> > > > > >
> > > > > > > > > > > > Why do I mention a Java problem ? Because the devs changed
the 
> > > > > > version
> > > > > > > > > > > > number recognition pattern for JDK/JVM instantiation
somewhere 
> > > > > > between
> > > > > > > > > > > > 5.1 and 5.2, and this is what caused crashing for some.
This was 
> > > > > > fixed
> > > > > > > > > > > > in 5.3. Of course, it could all be specific to your
Slackware 
> > > > > > setup...
> > > > > >
> > > > > > Alex
> > > > > Alex,
> > > > > Thanks for your prompt response. I have been working on this 
> > > > > > > > > > problem all morning. I first upgraded jdk-8u112 with jdk-
8u131 with 
> > > > > > > > > > the same results. I then tried LO 5.2.7.2 with the same
results. I 
> > > > > > > > > > then tried LO 5.3.4.2 with the same results. I then upgraded
the 
> > > > > MySQL Connector from 5.1.40 to 5.1.42 with the same results. 
> > > > > > > > > > Nothing I do seems to affect whatever is causing LO to crash.
I 
> > > > > > > > > > also started LO from a console to see if LO spit out any
pertinent 
> > > > > messages when it crashed - none.
> > > > >
> > > > > > > > > > Whatever is happening here, it is broad. I even tried to use
my 
> > > > > > > > > > OpenOffice Base odb file with the same LO results. Now this
file 
> > > > > works fine in AOO.
> > > > >
> > > > > > > > > > There are two datapoints I had not thought of when I posted
my 
> > > > > > > > > > message yesterday. One is that I successfully edited and
printed a 
> > > > > > > > > > report on 6/19/17 with LO 5.2.6.2. So, it was working at that
time.
> > > > > > > > > > The other is that I upgraded glibc from version 2.23 build 1
to 
> > > > > > > > > > 2.23 build 2 yesterday, before I noticed LO crashing. But I
tried 
> > > > > > > > > > returning to the old glibc version and LO still crashed, so I
doubt 
> > > > > > > > > > glibc was the cause. The other Slackware packages that I
changed 
> > > > > > > > > > yesterday are: bind, irssi, mozilla-firefox, openvpn, sudo,
the 
> > > > > Linux kernel, httpd, libcgroup, libcrypt, mkinitrd, 
> > > > > > > > > > mozilla-thunderbird, nasm, and pkg-config. None of these
should 
> > > > > have affected LO, but...
> > > > >
> > > > > > > > > > There is something else going on besides Base crashing. I
was 
> > > > > > > > > > checking the "Tools" | "Options" with nothing loaded and when
I got 
> > > > > > > > > > to the bottom item, "Internet" | "MediaWiki", LO crashed when
I 
> > > > > > > > > > selected it. I wasn't even close to MySQL or Base at the
time.
> > > > > > > > > > BTW: I am running a Dual-core Athlon CPU, 32-bit ix86 Linux
and 
> > > > > > > > > > Java, 8GB RAM, and 10% of 1TB disk space used. So it
shouldn't be a 
> > > > > > > > > > lack of resources. Besides, as I said, OpenOffice is still
running 
> > > > > > > > > > fine. My problem with using AOO, is that it does not have the
Base 
> > > > > Report Generator I need to print my reports.
> > > > >
> > > > > > > > > > Hope this helps narrow this problem down. I am about to issue
a bug 
> > > > > report on this. It is certainly repeatable, if frustrating.
> > > > > Thanks.
> > > > > Girvin

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted