Re: [libreoffice-users] MySQL on a network
On Sun, 17 Feb 2013 03:31:22 +0100, Girvin R. Herr girvin.h...@sbcglobal.net wrote: Dan Lewis wrote: On 02/16/2013 06:44 PM, Heinrich Stoellinger wrote: On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis elderdanle...@gmail.com wrote: I can connect to the MySQL server (5.5) on the same computer using localhost. But how do I connect to a MySQL server on another computer on the same network? I can not find it in the MySQL manual, or I don't know where to look in it. I use MySQL Workbench for administrative purposes. --Dan Hi Dan, When you define your MySQL-database under LO-Base, specify the hostname (or the IP-address) of the server as well as the port (usually 3306) instead of localhost. I am actually using a MySQL-server over the internet. It works o.k Regards H More information: My laptop is 192.168.2.101 and the MySQL server is on 192.168.2.100. The database I want to access is Budget. I entered Budget as the database name, Server as 192.168.2.100, port is 3306. I then test the connection, enter the user name and password. The error message I get is Host '192.168.2.101' is not allowed to connect to this MySQL server. I am using the MySQL JDBC driver, and when I click the Test Class button, I get the message The JDBC Driver was loaded successfully. Any suggestions as to what I might be doing wrong? --Dan Sounds like the server is not configured to allow you access. Since the IP addresses for the server and your computer are on the same LAN, I can assume the MySQL server is on another computer on the same LAN. You don't say if you did this in mysql: GRANT ALL PRIVILEGES ON *.* TO username@hostname IDENTIFIED BY `password` WITH GRANT OPTION; Note that the hostname should be the IP address of your laptop, or 192.168.2.101 . Note that the IP address may need around it due to the periods and numbers. If not, the server will not allow you access. The laptop is not registered as a trusted computer. You must have done this for your other computer, but you need to do it for all computers you need access for. Or, if you are brave, you can use % for any host: username@%. Or, better yet, you can limit access to your LAN: username@192.168.2.% For further information, this can be found in the MySQL reference manual under Access Control, Stage 1: Connection Verification. Hope this helps. Girvin Herr Hello again, The IP-address has to be that of the SERVER, and - of course as Girvin says - access has to be granted to you on the server as mentioned. By the way - I tend to use single apostrophies (') instead of , if necessary on the GRANT statements. Regards and good luck -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Link Base to External Spreadsheet
Le 17/02/2013 02:38, Mark LaPierre a écrit : Hi Mark, Now how do I create non-linked tables inside the same DB? How do I link to another external spreadsheet using the same DB? You would be better off using an external HSQLDB instance to link directly to text tables (note that these would not be Excel files). See the HSQLDB manual for how to do this. http://hsqldb.sourceforge.net/doc/guide/guide.html#texttables-chapter Can I link to only one spreadsheet at a time? In a single ODB file with the embedded hsqldb engine, AFAIK yes. From your email I gather that all tables must be tabs on the one spreadsheet that is linked. Is that a true statement? Seems pretty inconvenient. It is, fairly. But LO Base is not Access, nor FMPro. If you need to work comfortably with and edit multiple separate data sources, using the embedded hsqldb is probably not the best choice. Alex -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: MySQL-Connector
Le 16/02/2013 22:40, Heinrich Stoellinger a écrit : Looks like it, Alex! As I said before, I don't really want to use the Java version, it I had an afterthought question for you : do you have libmysqlclient or libmysqlcppconn installed on your Nadia box ? These might well be necessary for the connector to work. As far as I can tell, when one builds the connector it references the libraries on the system, but does not copy them into the connector itself. If you have them already, and it still isn't working, then it will be dependent on building for each OS version and bit arch. So, it seems to me that the way to go MUST be a native connector. Do you know whether MariaDB is doing anything in this direction? Regards The way to go, from what I have gathered, is : - the Linux distribs will provide the connector for their respective distrib versions of LO - since most don't ship the latest version of LO, then you won't get one that will work until they move on to the next version of LO ; - on Mac and Windows, it is entirely up to the individual to try and build the conenctor, independently of the official version of LO that is released ; - the LO dev team are waiting for the MariaDB team to get involved in providing a connector in line with Monty Widenius' statement to help out - from what I have seen recently, there is now actually a libmariadbclient library - this is a requirement to building a functional connector. No-one that I know of is working on providing a mariadb connector for the LO project at the moment, but I am not following the MariaDB project. Personally, I am starting to learn postgresql administration and maintenance, because it looks like the future of mysql connectivity in LO is going nowhere fast. I feel like where I was when I first started working with mysql 10 years ago, i.e. lost in a jungle of very technical information ;-) Alex -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: page down in word processors - find next
On 2/16/2013 8:05 AM, Dan Lewis wrote: On 02/16/2013 07:41 AM, william drescher wrote: On 2/15/2013 5:24 PM, Jean-Francois Nifenecker wrote: Le 15/02/2013 22:59, bill a écrit : I am keeping the same thread as it is closely related. The one thing that I really don't like is that as soon as you do a search the page down button becomes continue search forward and the page up becomes continue search backwards. That is fine while you are searching, but how does one return it to page up and page down ? You'll notice that then the page buttons are changing colours: by default, they turn blue in search mode while they are black in scroll mode. To get back from the search mode to the scroll mode, just click the center button (whatitsname?) and select the page icon. HTH, It would seem that as LO has evolved, changing the meaning of the page down/up screen buttons to search down/up is no longer needed as the find box (at the bottom of the screen) has search up/down arrows right next to it. If folk agree, I will file an enhancement request (If someone will give me the buglist address again) bill For some time, this has been used for navigation. PageUp/PageDown and SearchUp/SearchDown are only 2 of 20 functions. What about the other 18 functions? I think we can even give this a name: Navigation tool. --Dan I'm not talking about the center button (which opens the navigation menu), but about the up and down buttons. bill -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] MySQL on a network
Heinrich , fine, in the past there where some issues about remote connections, but how do you manage the security of your connection greetz Fernand On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis elderdanle...@gmail.com wrote: I can connect to the MySQL server (5.5) on the same computer using localhost. But how do I connect to a MySQL server on another computer on the same network? I can not find it in the MySQL manual, or I don't know where to look in it. I use MySQL Workbench for administrative purposes. --Dan Hi Dan, When you define your MySQL-database under LO-Base, specify the hostname (or the IP-address) of the server as well as the port (usually 3306) instead of localhost. I am actually using a MySQL-server over the internet. It works o.k Regards H -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: MySQL-Connector
Thanks, Alex, for your very informative message! As I mentioned before, I have set up my DB-connection to use ODBC in the meantime. Time will show whether this will be good alternative. At the moment it seems to be o.k. By the way - in spite of my remarks regarding Java/LO I have also downloaded and set up the JDBC-connector under LO 4, just to see whether it still is buggy... Regarding MariaDB: I have been kind of interested in whether it would stay around after the original euphoria. This seems to be the case, looking at statistics I saw a short while ago. I am quite prepared to migrate to it when I can spare a couple of hours, since I do have my reservations regarding proprietarily controlled software. Just as an asid - I come from lots of years with IBM and have seen what M$, Oracle and others have contributed to IT. I did get to know Ed Codd and Chris Date (inventors of SQL), got DB2 going at a large customer here as a kind of first within the German language area for an application system based on a couple of millions of records. Database has been a passion for me for a long time. After all, it is one of the essential pillars of any serious DP-system. Regards H. S. On Sun, 17 Feb 2013 12:34:17 +0100, Alex Thurgood alex.thurg...@gmail.com wrote: Le 16/02/2013 22:40, Heinrich Stoellinger a écrit : Looks like it, Alex! As I said before, I don't really want to use the Java version, it I had an afterthought question for you : do you have libmysqlclient or libmysqlcppconn installed on your Nadia box ? These might well be necessary for the connector to work. As far as I can tell, when one builds the connector it references the libraries on the system, but does not copy them into the connector itself. If you have them already, and it still isn't working, then it will be dependent on building for each OS version and bit arch. So, it seems to me that the way to go MUST be a native connector. Do you know whether MariaDB is doing anything in this direction? Regards The way to go, from what I have gathered, is : - the Linux distribs will provide the connector for their respective distrib versions of LO - since most don't ship the latest version of LO, then you won't get one that will work until they move on to the next version of LO ; - on Mac and Windows, it is entirely up to the individual to try and build the conenctor, independently of the official version of LO that is released ; - the LO dev team are waiting for the MariaDB team to get involved in providing a connector in line with Monty Widenius' statement to help out - from what I have seen recently, there is now actually a libmariadbclient library - this is a requirement to building a functional connector. No-one that I know of is working on providing a mariadb connector for the LO project at the moment, but I am not following the MariaDB project. Personally, I am starting to learn postgresql administration and maintenance, because it looks like the future of mysql connectivity in LO is going nowhere fast. I feel like where I was when I first started working with mysql 10 years ago, i.e. lost in a jungle of very technical information ;-) Alex -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Moving Templates from 3.5.5 to 4.0
Hi :) Have you had any luck with this? Sorry you haven't had any answers so far but hopefully someone here might be able to figure it out. Apols and regards from Tom :) From: Karen DInse kdi...@rrwrd.dst.il.us To: users@global.libreoffice.org Sent: Friday, 15 February 2013, 17:40 Subject: [libreoffice-users] Moving Templates from 3.5.5 to 4.0 Windows XP, SP3 I created numerous templates in LO 3.5.5. I created the letter/template and inserted input fields that would stop and ask the user to input the appropriate data. Worked real well in LO 3.5.5. We are hoping to upgrade to version 4.0.0.3, but when we try to copy or import the templates, they don't stop at the input fields to prompt the user to input the data. We have tried to retype the letters/templates, inserting input fields, to no avail. Is there a way to get the template to stop and prompt the user for each input box? -- View this message in context: http://nabble.documentfoundation.org/Moving-Templates-from-3-5-5-to-4-0-tp4037782.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Ubuntu PPAs for 4.0.x Stable?
2013/2/17 Sajan Parikh sa...@noppix.com Anybody know when the PPA for 4.0.x will be populated? I'm in no rush and can obviously download the .deb files. However, would make deploying to 30 computers a tad easier. The following PPA is empty. https://launchpad.net/~**libreoffice/+archive/**libreoffice-4-0https://launchpad.net/~libreoffice/+archive/libreoffice-4-0 Thanks. -- Sajan Parikh ... I'm with Sajan on this one (even if I fortunately don't have to deploy to quite as many as 30 computers) - any idea when packages will start being uploaded to the PPA above ?... Henri -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Irregularities with footnote numbering when switching to MSW
I am working on a series of documents, chapters of a book, en every time I set up footnotes with regular arabic numbers, 1/2/3/4/5 etc, but when I send the file to a colleague, and she opens it up in MSW, it shows up as arabic numbers. I am at a loss any more as to how to change that, without doing it manually for each and every reference??? -- *Rogier Fentener van Vlissingen http://viz.me/vliscony/t/7* *About Me* http://about.me/vliscony -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Calc scale formula conundrum/ logic confusion
Hi Tom, On 14/02/13 16:41, Tom wrote: Hi :) Yes, of course you can ask different questions. I just thought it was exactly the same question again in which case my answer wouldn't have been so wrong. Thanks , I was hoping so. snip I wonder if there is a really good Maths forum for getting help with this sort of thing. It's a bit sideways from our normal ways of thinking so we might not be much good at it. A Maths forum like that might even be good place for students or kids to get unusual but real-life questions to figure out. A chance for teachers to escape irrelevant ancient dusty text-books and get real. Whilst I agree a good Maths/Calc forum wouldn't be a bad idea, I think considering the software in use on LibreOffice Calc, then the users should mostly be able to find a resolution to their problem regarding formula syntax and entry. This problem is complex but hopefully once solved will help others with scale calculations. Given the subscribers to the list are the folk who would be most likely to use the formula, its correct usage and syntax is imperative or perhaps it might indicate a problem with a formula in Calc's repertoire. Of course an obvious answer is to avoid using a spreadsheet for this initially and just use the back of an envelope or scrap of paper from elsewhere. When the question states the amount of unit i have left that suggests an upper limit that can't be exceeded such that Total amount of units allowed = Used + amount left So i think i need to know which of these 2 following statements are true and which isn't (or am i completely off-track?) G2= Total amount allowed, the limit or G2 = amount left In the question it seems to be being used in both ways at different times. Well, to me anyway. Scraps of paper are sometimes a handy quickie solution but if the results need graphing over a few readings, a spreadsheet really is better as I am sure you'll agree :) , mind you that said a database would be the best, but that gets REALLY complicated. :) G2 in this example is the total electricity unit reading taken at the end of the month that indicated how many units are left or available. What I am aiming to work out is the currency value of those units(H2) using the same scale that is used to purchase the units. Using my Purchase scale and changing the purchase value in c22 for e.g., I can see that I would need to layout ZAR574.61 to be allocated 150 units on the first scale and 282.99 on the second scale totalling R574.60,5 - vat= R504.05 to give me the value of 433 units. The question is to work out the value obtained in c22 auto-magically for H2, without using C22 to give the ZAR value of G2 or 432.9 units. The formula in H2 incorporates the first two scales i.e. `=IF(G2=$G$18,$H$18,G2*$F$18)+IF(G2-$G$18=$J$18,$K$18,(G2-$G$18)*$I$18)' Provided G2 is 433 the correct answer for H2 of R504.05 is received. HOWEVER using the same formula, if you make G2 =1. The answer in H2 should be R1.13 yet shows an answer of R -174.85? As the above formula only incorporates 2 of the 3 scales, the full formula is `=IF(G2=$G$18,$H$18,(G2*$F$18))+IF(G2-$G$18)=$J$18,$K$18,(G2-$G$18)*$I$18)+IF(G2-$G$18-$J$18)=$M$18,$N$18+(G2-$G$18-$J$18-$M$18)*$L$19,(G2-$G$18-$J$18-$M$18)*$L$19)' yet for some reason I am getting a 508 error yet I have checked the number of brackets and all is OK? zr1hpc wrote Using Calc 3.4.5 on openSuse 11.2 I am trying to work out the currency value of the amount of electricity units I have left at the end of the month (G2). This same formula will be used for the other 11 months of the year with only the G2 reference changing to G3, G4...etc. For those who wish to stretch their grey matter as mine just ain't stretching any more. The pricing scale the energy supplier has given me is: Unit Range Value per unit 0-150 1.1320 150.01 - 6001.1811 600.01 -1.4018 Therefore the first 150 units are priced at 1.132 ea. any units still available need to be calculated at the next rate of 1.1811, but only up to 449.90 units at the second rate. Anything more than that must be at the highest rate of 1.4018. Assuming my unit balance of G2 = 433 I can work out the currency value of G2 by following the following logic, and using the scale above: 433 150 therefore the initial 150 units need to be priced at 1.1320 i.e. 150* 1.132= ZAR169.80. To this the balance of the units over 150 need to be multiplied by the next rate of 1.1811 i.e. 433-150= 283. Since 283 is below the max of 449.9 units allowed for this scale, therefore 283*1.1811= ZAR334.25. The third scale is not needed as all the units have been accounted for, however it must be available should G2 exceed 600 units e.g. taking 601 units; the first 150 would be costed at 1.132, the next 449.9 costed at 1.1811 and the balance of 1.1 units costed at 1.4018 per unit. Therefore total value of 433 units is: 150*1.1320 = 169.80 + 283*1.1811 =
Re: [libreoffice-users] Irregularities with footnote numbering when switching to MSW
On 02/17/2013 12:34 PM, webmaster-Kracked_P_P wrote: On 02/17/2013 11:59 AM, Rogier F. van Vlissingen wrote: I am working on a series of documents, chapters of a book, en every time I set up footnotes with regular arabic numbers, 1/2/3/4/5 etc, but when I send the file to a colleague, and she opens it up in MSW, it shows up as arabic numbers. I am at a loss any more as to how to change that, without doing it manually for each and every reference??? You state setup in arabic and she see it as arabic. Your statement does not make sense. You are using standard English numbering? Are you wanting Serif or San Serif style - Times Roman vs Arial? Did you define the font style of the footnote, or did you use the defaults? Which fonts are you using? Does the receiver have those fonts? Could you sent to me a clip of your screen showing the numbering style used? Then I might be able to give you some better ideas. Perhaps what was meant: the document created in LO use Hindu-Arabic numbers. However, it is very possible that someone whose native language is Arabic uses different characters to write their numbers. Perhaps MSW is using the latter way to write numbers. Evenso, this does seem very strange. --Dan -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: MySQL on a network
On 17-02-2013 20:03, Dan Lewis wrote: On 02/17/2013 01:19 PM, Luuk wrote: On 16-02-2013 23:44, Dan Lewis wrote: I can connect to the MySQL server (5.5) on the same computer using localhost. But how do I connect to a MySQL server on another computer on the same network? I can not find it in the MySQL manual, or I don't know where to look in it. I use MySQL Workbench for administrative purposes. --Dan Here is the link to the manual: http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_skip-networking Thanks for the link, but I already have it in ePUB format. My problem is trying to determine what the manual means. It is very verbose! --Dan It might be 'skip-networking' in your config (read:my.cnf) means that MySQL will not listen to any network interface. Yuou will still be able to connect to localhost, because its something 'sepecial' http://en.wikipedia.org/wiki/Localhost The public releases of the MySQL database differentiate between localhost and 127.0.0.1. When using localhost from a client program, say a PHP application, then MySQL connects to the database using a Unix domain socket rather than making a direct TCP connection[7][8]. To ensure a TCP connection to the database in IPv4 then use 127.0.0.1. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Reptile Skin design for a 4.0.0 Persona / 33+ designs for LO 4.0.0 Persona/Themes
I really like how my LibreOffice Reptile Skin 1 Persona design works out on LibreOffice 4.0.0. http://libreoffice-na.us/libreoffice-reptile-skin-1--lo40-clip.jpg Here are the current Firefox Persona/Themes with the key word of LibreOffice. https://www.getpersonas.com/en-US/gallery/All/search?p=libreofficesearch.x=0search.y=0 I like patterns and other things. So I am working on those right now. If I had some good graphics and photos that might work well as design for LO themes, I might do them as well. I could use some constructive comments though. We all could. Designing a Persona/Theme for Firefox is one thing, but making one that was created for LiberOffice is a different thing. Do we want it to have LibreOffice show as a text image there or just some nice graphics or images? I would be nice to know what our users like for color schemes or background ideas. There are Green, Blue, Orange, Purple, and Yellow colors specified in the Branding Wiki. I am working on green ideas, since I choose a green themed desktop. But if there are others who would prefer Blues or other branded colors, I could work on them. Since LibreOffice does not have any Mascot, but there were ideas on that a while back, I may try my had at that type of image. But it really is up to the users of LO 4.0 to decide what they would like. Actually having you Firefox browser have an LO themed background image for its menu system, would be a form of advertising, it may not be for every one. Let all of us, who want to create these Persona/Themes for LibreOffice [and Firefox], know what you would like to see from use as themes and artwork. -- By the way, it would be easier for people to design these themes, if there was a way to test them like you can do on the Firefox browser. Just a thought. Right now we have to design them and submit them to Firefox for approval. It the new design it too close to one of your other designs or someones else's, it will be rejected. My green rough paper with the LO text was approved, but to just have that background and not text was not since it was too much like the text version. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: MySQL on a network
Luuk wrote: On 17-02-2013 20:03, Dan Lewis wrote: On 02/17/2013 01:19 PM, Luuk wrote: On 16-02-2013 23:44, Dan Lewis wrote: I can connect to the MySQL server (5.5) on the same computer using localhost. But how do I connect to a MySQL server on another computer on the same network? I can not find it in the MySQL manual, or I don't know where to look in it. I use MySQL Workbench for administrative purposes. --Dan Here is the link to the manual: http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_skip-networking Thanks for the link, but I already have it in ePUB format. My problem is trying to determine what the manual means. It is very verbose! --Dan It might be 'skip-networking' in your config (read:my.cnf) means that MySQL will not listen to any network interface. Yuou will still be able to connect to localhost, because its something 'sepecial' http://en.wikipedia.org/wiki/Localhost The public releases of the MySQL database differentiate between localhost and 127.0.0.1. When using localhost from a client program, say a PHP application, then MySQL connects to the database using a Unix domain socket rather than making a direct TCP connection[7][8]. To ensure a TCP connection to the database in IPv4 then use 127.0.0.1. Umm. Are you sure about that? I am not an expert, but it has been my experience that if skip-networking is enabled, then localhost will not work either. As you say, there are two ways to access the server: the network or the Unix socket. The MySQL programs generally use the socket. However, LO Base and, more specifically, the connector driver, use the network interface. When users complain about not being able to connect to MySQL, I suggest commenting out the skip-networking directive and when they do, they are able to connect. That implies that localhost is controlled by skip-networking. localhost may indeed be something special, but I think in this respect, it isn't. If you do an ifconfig while root (Linux), you will see that the lo (loopback) interface, which is 127.0.0.1, is listed along with the hardware LAN Ethernet interface(s). So it is treated at the same level as the Ethernet interface in the IP (Internet Protocol) stack. BTW, the last sentence of the wiki you quote doesn't make sense. Under *nix, the name localhost is defined as 127.0.0.1 (the lo interface) in the /etc/hosts file. Therefor, when localhost is requested, it gets translated to 127.0.0.1 by the computer, not passed on to MySQL as a special case. MySQL should have nothing to do with this translation, so it would never see the name localhost. That said, it seems that the connector driver could make that translation for MySQL. I don't know the interior details of the connector, but It could get the localhost name from Base and then process it. It could make a special case of localhost and vector subsequent requests to the socket. However, as I said, that has not been my experience. Just my 2-cents. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: MySQL on a network
On 02/17/2013 04:53 PM, Girvin R. Herr wrote: Luuk wrote: On 17-02-2013 20:03, Dan Lewis wrote: On 02/17/2013 01:19 PM, Luuk wrote: On 16-02-2013 23:44, Dan Lewis wrote: I can connect to the MySQL server (5.5) on the same computer using localhost. But how do I connect to a MySQL server on another computer on the same network? I can not find it in the MySQL manual, or I don't know where to look in it. I use MySQL Workbench for administrative purposes. --Dan Here is the link to the manual: http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_skip-networking Thanks for the link, but I already have it in ePUB format. My problem is trying to determine what the manual means. It is very verbose! --Dan It might be 'skip-networking' in your config (read:my.cnf) means that MySQL will not listen to any network interface. Yuou will still be able to connect to localhost, because its something 'sepecial' http://en.wikipedia.org/wiki/Localhost The public releases of the MySQL database differentiate between localhost and 127.0.0.1. When using localhost from a client program, say a PHP application, then MySQL connects to the database using a Unix domain socket rather than making a direct TCP connection[7][8]. To ensure a TCP connection to the database in IPv4 then use 127.0.0.1. Umm. Are you sure about that? I am not an expert, but it has been my experience that if skip-networking is enabled, then localhost will not work either. As you say, there are two ways to access the server: the network or the Unix socket. The MySQL programs generally use the socket. However, LO Base and, more specifically, the connector driver, use the network interface. When users complain about not being able to connect to MySQL, I suggest commenting out the skip-networking directive and when they do, they are able to connect. That implies that localhost is controlled by skip-networking. localhost may indeed be something special, but I think in this respect, it isn't. If you do an ifconfig while root (Linux), you will see that the lo (loopback) interface, which is 127.0.0.1, is listed along with the hardware LAN Ethernet interface(s). So it is treated at the same level as the Ethernet interface in the IP (Internet Protocol) stack. BTW, the last sentence of the wiki you quote doesn't make sense. Under *nix, the name localhost is defined as 127.0.0.1 (the lo interface) in the /etc/hosts file. Therefor, when localhost is requested, it gets translated to 127.0.0.1 by the computer, not passed on to MySQL as a special case. MySQL should have nothing to do with this translation, so it would never see the name localhost. That said, it seems that the connector driver could make that translation for MySQL. I don't know the interior details of the connector, but It could get the localhost name from Base and then process it. It could make a special case of localhost and vector subsequent requests to the socket. However, as I said, that has not been my experience. Just my 2-cents. Girvin Herr MySQL server 5.1 has a skip network section. This has been modified in Server 5.5 to this: # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address= 127.0.0.1 The reference in the MySQL Reference Manual ( Access Control, Stage 1: Connection Verification) states what to put in place of 127.0.0.1 for using MySQL over a network. In my case, I can use 192.168.2.% or 192.168.2.0/255.255.255.0. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: MySQL on a network
Dan Lewis wrote: On 02/17/2013 04:53 PM, Girvin R. Herr wrote: snip MySQL server 5.1 has a skip network section. This has been modified in Server 5.5 to this: # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address= 127.0.0.1 The reference in the MySQL Reference Manual ( Access Control, Stage 1: Connection Verification) states what to put in place of 127.0.0.1 for using MySQL over a network. In my case, I can use 192.168.2.% or 192.168.2.0/255.255.255.0. That's interesting. I am using MySQL 5.0.67, so this does not yet apply to me. However, I will have to make note of this for future reference. How did you make out? Did you get your laptop talking to the server? Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Ubuntu PPAs for 4.0.x Stable?
Hi :) I think it's an Ubuntu Team rather than a Libreoffice Team that provides the PPA. There are links from that page to help you contact the team. Apols and regards from Tom :) From: M Henri Day mhenri...@gmail.com To: Sajan Parikh sa...@noppix.com Cc: LibreOffice, users users@global.libreoffice.org Sent: Sunday, 17 February 2013, 14:26 Subject: Re: [libreoffice-users] Ubuntu PPAs for 4.0.x Stable? 2013/2/17 Sajan Parikh sa...@noppix.com Anybody know when the PPA for 4.0.x will be populated? I'm in no rush and can obviously download the .deb files. However, would make deploying to 30 computers a tad easier. The following PPA is empty. https://launchpad.net/~**libreoffice/+archive/**libreoffice-4-0https://launchpad.net/~libreoffice/+archive/libreoffice-4-0 Thanks. -- Sajan Parikh ... I'm with Sajan on this one (even if I fortunately don't have to deploy to quite as many as 30 computers) - any idea when packages will start being uploaded to the PPA above ?... Henri -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Calc scale formula conundrum/ logic confusion
On 2013-02-18 07:31, Hylton Conacher (ZR1HPC) wrote: Hi Tom, On 14/02/13 16:41, Tom wrote: Hi :) Yes, of course you can ask different questions. I just thought it was exactly the same question again in which case my answer wouldn't have been so wrong. Thanks , I was hoping so. snip I wonder if there is a really good Maths forum for getting help with this sort of thing. It's a bit sideways from our normal ways of thinking so we might not be much good at it. A Maths forum like that might even be good place for students or kids to get unusual but real-life questions to figure out. A chance for teachers to escape irrelevant ancient dusty text-books and get real. Whilst I agree a good Maths/Calc forum wouldn't be a bad idea, I think considering the software in use on LibreOffice Calc, then the users should mostly be able to find a resolution to their problem regarding formula syntax and entry. This problem is complex but hopefully once solved will help others with scale calculations. Given the subscribers to the list are the folk who would be most likely to use the formula, its correct usage and syntax is imperative or perhaps it might indicate a problem with a formula in Calc's repertoire. Of course an obvious answer is to avoid using a spreadsheet for this initially and just use the back of an envelope or scrap of paper from elsewhere. When the question states the amount of unit i have left that suggests an upper limit that can't be exceeded such that Total amount of units allowed = Used + amount left So i think i need to know which of these 2 following statements are true and which isn't (or am i completely off-track?) G2= Total amount allowed, the limit or G2 = amount left In the question it seems to be being used in both ways at different times. Well, to me anyway. Scraps of paper are sometimes a handy quickie solution but if the results need graphing over a few readings, a spreadsheet really is better as I am sure you'll agree :) , mind you that said a database would be the best, but that gets REALLY complicated. :) G2 in this example is the total electricity unit reading taken at the end of the month that indicated how many units are left or available. What I am aiming to work out is the currency value of those units(H2) using the same scale that is used to purchase the units. Using my Purchase scale and changing the purchase value in c22 for e.g., I can see that I would need to layout ZAR574.61 to be allocated 150 units on the first scale and 282.99 on the second scale totalling R574.60,5 - vat= R504.05 to give me the value of 433 units. The question is to work out the value obtained in c22 auto-magically for H2, without using C22 to give the ZAR value of G2 or 432.9 units. The formula in H2 incorporates the first two scales i.e. `=IF(G2=$G$18,$H$18,G2*$F$18)+IF(G2-$G$18=$J$18,$K$18,(G2-$G$18)*$I$18)' Provided G2 is 433 the correct answer for H2 of R504.05 is received. HOWEVER using the same formula, if you make G2 =1. The answer in H2 should be R1.13 yet shows an answer of R -174.85? As the above formula only incorporates 2 of the 3 scales, the full formula is `=IF(G2=$G$18,$H$18,(G2*$F$18))+IF(G2-$G$18)=$J$18,$K$18,(G2-$G$18)*$I$18)+IF(G2-$G$18-$J$18)=$M$18,$N$18+(G2-$G$18-$J$18-$M$18)*$L$19,(G2-$G$18-$J$18-$M$18)*$L$19)' yet for some reason I am getting a 508 error yet I have checked the number of brackets and all is OK? zr1hpc wrote Using Calc 3.4.5 on openSuse 11.2 I am trying to work out the currency value of the amount of electricity units I have left at the end of the month (G2). This same formula will be used for the other 11 months of the year with only the G2 reference changing to G3, G4...etc. For those who wish to stretch their grey matter as mine just ain't stretching any more. The pricing scale the energy supplier has given me is: Unit RangeValue per unit 0-1501.1320 150.01 - 6001.1811 600.01 -1.4018 Therefore the first 150 units are priced at 1.132 ea. any units still available need to be calculated at the next rate of 1.1811, but only up to 449.90 units at the second rate. Anything more than that must be at the highest rate of 1.4018. Assuming my unit balance of G2 = 433 I can work out the currency value of G2 by following the following logic, and using the scale above: 433 150 therefore the initial 150 units need to be priced at 1.1320 i.e. 150* 1.132= ZAR169.80. To this the balance of the units over 150 need to be multiplied by the next rate of 1.1811 i.e. 433-150= 283. Since 283 is below the max of 449.9 units allowed for this scale, therefore 283*1.1811= ZAR334.25. The third scale is not needed as all the units have been accounted for, however it must be available should G2 exceed 600 units e.g. taking 601 units; the first 150 would be costed at 1.132, the next 449.9 costed at 1.1811 and the balance of 1.1 units costed at 1.4018 per unit. Therefore total
[libreoffice-users] Re: Reptile Skin design for a 4.0.0 Persona / 33+ designs for LO 4.0.0Persona/Themes
I really like how my LibreOffice Reptile Skin 1 Persona design works out on LibreOffice 4.0.0. Seriously? It's so bright that it's unusable. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] head format does not change
In a document is a Head 1 preformated and in Arial font Now I come across a Head 1 in Verbena. So I do change the Head 1 into an other format and than back to Head 1 Now I expect this Head 1 to be in Arial (because that is the way Head 1 in this doc is preformatted) But nothing has changed. How come, what to do? -- vriendelijke groeten Jaap Bosman -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] head format does not change
Maybe it use direct formatting (when you select some text and choose text/paragraph attribute from menu/toolbars instead of styles). You can remove direct formatting with the adequate option in the format menu while selecting the problematic part of the document. -- Cley Faye http://cleyfaye.net 2013/2/18 Jaap Bosman j...@xs4all.nl In a document is a Head 1 preformated and in Arial font Now I come across a Head 1 in Verbena. So I do change the Head 1 into an other format and than back to Head 1 Now I expect this Head 1 to be in Arial (because that is the way Head 1 in this doc is preformatted) But nothing has changed. How come, what to do? -- vriendelijke groeten Jaap Bosman -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] styles
I do have a documnent with a lot of (12) styles. My job is to make it a nice doc with only 4 styles In the list of used styles : Head Head 1 Head 3 Head Article These 4 styles I want to change to Head 1 Do I have to crawl the doc for every style or could I use some automated function? -- vriendelijke groeten Jaap Bosman -- For unsubscribe instructions e-mail to: users+h...@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