smsdrc
Hi all, I did the connfiguration with my-sql gammu and try to hit a sms whenever changes happen in database I followed steps from the manual which I got from gammu site. When I give* gammu-smsd-inject +9840411410 TEXT -text msg* it is showing *written message with ID /var/spool/gammu/outbox/somedatasms0.smsbackup* but I am not getting any message to my mobile. How should I move further. thanks in Advance With Regards, Never Say No, Santhosh V.Kumar +919840411410 http://santhoshvkumar.110mb.com/
MySQL - licensing data recovery environments
Hi all, does anybody know where can I find a recent guide/information regarding the licensing of data recovery environments with /MySQL Enterprise Server/? Regards Dimitre -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Policies in the DBSPI MySQL OpenView on linux server
Hi everybody, I would like install the policies in the DBSPI MySQL OpenView on the server Linux. My server is SUSE Linux Enterprise Server 10 SP1 (i586). I know policies for db Oracle and MSSQL, but I don't know the policies MySQL who can be install for monitoring database. For this moment, the monitor is installed only OS /opt/OV/bin # ./ovpolicy -list * List installed policies for host 'localhost'. Type NameStatus Version configsettingsOVO settings enabled1 lePROD-OSSPI-Linux-syslog enabled1 mgrconf OVO authorization enabled1 monitor PROD-OSSPI-CD_Cpu_Load enabled1 monitor PROD-OSSPI-CD_Swap_Res enabled1 monitor PROD-OSSPI-InternalLog enabled1 monitor PROD-OSSPI-Linux-cfgmon enabled1 monitor PROD-OSSPI-genericApplication enabled1 monitor PROD-OSSPI-genericSystem enabled1 monitor PROD-OSSPI-inetdproc enabled1 monitor PROD-OSSPI-localcfgmon enabled1 monitor PROD-OSSPI-syslogproc enabled1 monitor PROD_OSSPI-NP-Filesystem enabled1 msgi PROD-CAPMSG-opcmsgenabled1 msgi PROD-OSSPI-opcmsg enabled1 msgi PROD-OSSPI-procmonMsg enabled1 msgi PROD_OSSPI-FilesystemMsg enabled1 Could you help me Thx and regards Joel This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
efficient use of varchar?
Does it make any difference if I allocate a particular number of bytes for a varchar? I mean, just as an example, maybe its more efficient to use a power of 2 as the field length. Or maybe power of 2 minus 1. I'm guessing not and that anything less than 255 is the same. I'm converting some data in a spreadsheet and I have to create a table with about 150 columns. So I created all the columns varchar(255) and now I'm asking mysql to show me the longest value in each column. SELECT MAX(LENGTH(column99)) FROM TABLE99. Then I've been modifying the CREATE TABLE code to accomodate the longest value plus a little more. So if the longest value in the column is 38 characters, I'd probably make that a VARCHAR(50). But maybe I might as well make that 63 or 64. Or maybe I'm wasting my time and should leave them all 255. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: smsdrc
Hello Martin, I am using the supportable hardware only With Regards, Never Say No, Santhosh V.Kumar +919840411410 http://santhoshvkumar.110mb.com/ I am because we are On Wed, Apr 6, 2011 at 6:18 PM, Martin Gainty mgai...@hotmail.com wrote: Gammu currently supports: majority of Nokia phones from DCT3 generation with Nokia operating system – for example Nokia 3210, 3310, 3315, 3410, 5110, 5130, 6110, 6510, 6610, 7210, 8310 Many AT devices – for example many Siemens, Sony Ericsson, Nokia, Alcatel models, Alcatel from BE5/BF5/BH4 generation – for example 501, 511, 512, also some functions with OBEX and Symbian devices are you testing with one of these devices? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. From: santhosh.vku...@gmail.com Date: Wed, 6 Apr 2011 16:21:16 +0530 Subject: smsdrc To: mysql@lists.mysql.com Hi all, I did the connfiguration with my-sql gammu and try to hit a sms whenever changes happen in database I followed steps from the manual which I got from gammu site. When I give* gammu-smsd-inject +9840411410 TEXT -text msg* it is showing *written message with ID /var/spool/gammu/outbox/somedatasms0.smsbackup* but I am not getting any message to my mobile. How should I move further. thanks in Advance With Regards, Never Say No, Santhosh V.Kumar +919840411410 http://santhoshvkumar.110mb.com/
Re: efficient use of varchar?
Hi, There is difference between varchar(63) and varchar(38). Instead of selecting MAX(LENGTH()) you can do PROCEDURE ANALYZE() on the table, which will tell you about the optimal record type for the data you currently have in the table. When you are using inreasonably large varchar columns, and mysql decides to create an in-memory temporary table with the MEMORY storage engine, practically all varchar(n) fields will be converted to char(n) fields, because memory storage engine doesn't support variable length data. Peter Boros On 04/06/2011 08:28 PM, John G. Heim wrote: Does it make any difference if I allocate a particular number of bytes for a varchar? I mean, just as an example, maybe its more efficient to use a power of 2 as the field length. Or maybe power of 2 minus 1. I'm guessing not and that anything less than 255 is the same. I'm converting some data in a spreadsheet and I have to create a table with about 150 columns. So I created all the columns varchar(255) and now I'm asking mysql to show me the longest value in each column. SELECT MAX(LENGTH(column99)) FROM TABLE99. Then I've been modifying the CREATE TABLE code to accomodate the longest value plus a little more. So if the longest value in the column is 38 characters, I'd probably make that a VARCHAR(50). But maybe I might as well make that 63 or 64. Or maybe I'm wasting my time and should leave them all 255. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: temp table and view/function/procedure dilemma
2011/04/05 20:15 +0200, Bgs I have a temporary table which is a smaller table generated from a rather big one. The full table is too big to make real gimmicks on it, so I do need the temp table. Later I do several queries on the temp table. So my initial setup and needs are: - temporary table to work from - result sets derived from parametric queries - mysql views cannot work from temporary tables so I have to drop a view+select/where approach. - functions cannot return result sets - procedures can do everything but I found no way to handle the result set within mysql (officially not supported) Any ideas how to solve this? Why not fake the temporariness, by DROPping the table as needful? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Highest version of MySQL available for 2.4 kernel (RH/Cent OS 3.5)?
What is the highest version of MySQL available for a 2.4 kernel (Redhat/Cent OS 3.5)? And where can I find it to download? Thanks, -Hank