Failed To Run Smsd Unknown Error
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Database structure is from newer Gammu version up vote -1 down vote favorite i get error when run gammu-smsd Log filename is "/var/log/gammu-smsd" gammu-smsd[11271]: Database structure is from newer Gammu version gammu-smsd[11271]: Initialisation failed, stopping Gammu smsd: Unknown error. (UNKNOWN[27]) Failed to run SMSD: Unknown error. my gammu in version 1.31.90 and database structure in version 1.34.0. i try upgrade gammu version apt-get upgrade gammu but gammu version stil in version 1.31.90 can you help me solve this problem? thank you upgrade postgresql-9.1 sms-gateway gamma-function gammu share|improve this question asked Nov 21 '14 at 3:20 user3040085 91110 Well, how'd you get data from a newer version there in the first place? Did you load this database from another server? Something else? –Craig Ringer Nov 21 '14 at 5:17 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote There is a sql file to setup the postgres DB in docs/sql/pgsql.sql. It can be found online here: http://wammu.eu/docs/manual/smsd/pgsql.html This line is causing trouble: INSERT INTO gammu ("Version") VALUES (14); Change '14' to '13' and rerun the script to build your smsd database. This worked for me... All the best, Sebastian share|improve this answer answered Dec 21 '14 at 20:37 Sebastian Schutte 11 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged upgrade postgresql-9.1 sms-gateway gamma-function gammu or ask your own question. asked 1 year ago viewed 1237 times active 1 year ago Related 1need help in Gammu smsd file configuration0gammu SMSD service Error 270Permission denied for relation table outbox0Cannot sending sms with gammu1Gammu Cannot Start Service Due to SQL Syntax Error1import gammu class - getting error no module named0Gammu incoming messages not stored in “Inbox” table0
server.Because of driver issues, I'm running in Windows instead of Linux for the timebeing. I sincerely hope to transition to Linux soon.Still, I figured I would familiarize myself with gammu in the Windows environment.Windows recognizes the phone and I can send messages through the phone using theCLI.I created my MySQL tables from the "mysql.sql" file in"share\doc\gammu\examples\sql".Now I'm interested in setting up the SMS server.When I issue the following command:C:\>gammu-smsd.exe -c c:\gammu\bin\smsdrcI get the following error:Log filename is "smsdlog"gammu-smsd[4244]: Error code: 1064, Error: http://stackoverflow.com/questions/27053564/database-structure-is-from-newer-gammu-version You have an error in your SQLsyntax; check the manual that corresponds to your MySQL server version for theright syntax to use near 'Signal) VALUES ('352509007925211', '', 'yes', 'yes',NOW(), (NOW() + INTERVAL 10' at line 1From what I can tell, as soon as "gammu-smsd" starts, it tries to insert arecord of my phone into the "phone" table. http://gammu-users.narkive.com/2RAuzfrS/sql-error-when-running-gammu-smsd Yet it fails 9 times with the errorabove and then exits with this error:"Failed to run SMSD: Unknown error."So I logged into mysql and tried inserting my phone manually with this command:INSERT INTO phones (IMEI, ID, Send, Receive, InsertIntoDB, TimeOut, Client,Battery, Signal)VALUES("352509007925212", "T-Mobile", "yes", "yes", "NOW()", "(NOW() + INTERVAL 10SECOND) + 0", "Gammu 1.12.3", "-1", "-1")and, surprisingly, I get the same error.But if I don't try to insert the "Signal" field into the record, then the"insert" command works:mysql> INSERT INTO phones (IMEI, ID, Send, Receive, InsertIntoDB, TimeOut,Client, Battery)-> VALUES-> ("352509007925212", "T-Mobile", "yes", "yes", "NOW()", "(NOW() + INTERVAL10 SECOND) + 0", "Gammu 1.12.3", "-1");Query OK, 1 row affected, 2 warnings (0.00 sec)So I appear to be stuck. I can't run the smsd service unless I can modify theinitial command gammu-smsd is trying to run when it initializes.Can anyone think of a work-around?I'm running Gammu-1.29.0 for windows.I'm using Xampp-win32-1.7.4-VC6 for my LAMPP environment.Xampp uses MySQL 5.5.8, Apache/2.2.17 (Win32) and PHP 5.3.5Thanks.Kinney Kinney Baughman 2011-04-20 20:12:01 UTC PermalinkRaw Message Post by b*
Sign in Pricing Blog Support Search GitHub This repository Watch 22 Star 99 Fork https://github.com/back2arie/Kalkun/issues/134 82 back2arie/Kalkun Code Issues 49 Pull requests 3 Projects 0 http://sp2hari.com/setting-up-a-sms-server-using-gnokii/ Wiki Pulse Graphs New issue Sqlite and Kalkun #134 Closed N3bTcx opened this Issue Dec 6, 2013 · 3 comments Projects None yet Labels None yet Milestone No milestone Assignees No one assigned 3 participants N3bTcx failed to commented Dec 6, 2013 Hello I've tried to follow : http://back2arie.wordpress.com/2011/02/28/using-kalkun-and-gammu-smsd-with-sqlite3/ But i'm getting few issues. Libdbi has been install but I don't see any mention of libdi on ./configure of gammu. No infos on gammu's website When i try a gammu-smsd-inect apparently libdi is install. I don't understand how failed to run can i know that gammu-smsd-inject[29057]: DBI error 14: 14: could not open database gammu-smsd-inject[29057]: DBI error -3: -3: libdbi could not establish a connection gammu-smsd-inject[29057]: DBI failed to connect! Failed to inject message: Unknon error. I did everything on the blog but I'm getting a blank page after login on kelkun, no error messages. Owner back2arie commented Dec 7, 2013 Any error when running gammu-smsd? You can enable error log on index.php file. N3bTcx commented Dec 9, 2013 For gammu-smsd $ gammu-smsd gammu-smsd[19198]: DBI error 14: 14: could not open database gammu-smsd[19198]: DBI error -3: -3: libdbi could not establish a connection gammu-smsd[19198]: DBI failed to connect! gammu-smsd[19198]: Initialisation failed, stopping Gammu smsd: Unknown error. (UNKNOWN[27]) Failed to run SMSD: Unknown error. And finaly apache2 Mon Dec 09 15:45:57 2013] [error] [client 185.3.135.146] PHP Fatal error: Call to undefined function sqlite_escape_string() in /var/www/kalkun/system/database/drivers/pdo/pdo_driver.php on line 216, referer: https://server.com/kalkun/index.php/
VirtualHostsSzasz-Fabian Jozsef on Apache Fix : NameVirtualHost *:80 has no VirtualHostsludovic on Apache Fix : NameVirtualHost *:80 has no VirtualHostsRachel on Setting up a SMS server using Gnokiitng on Best Google Talk Status Awards :) :) :) hari@weblog I see, learn and rediscover… everyday! Setting up a SMS server using Gnokii I've used gnokii to set up a SMS server in our college as a part of Spider Project. Though I didn't actually believe that a computer and a mobile phone can be connected when Manas suggested the idea, I coded much for this SMS server later. So here is the short manual about how to configure gnokii in a system. Let us assume that we have a basic Fedora or Ubuntu installed machine, a Nokia 7250i mobile and an USB data cable. Gnokii Installation : This can be done in two ways like any other open source software. Installing from binary. Installing from binary is very easy if you have yum (Fedora) or apt (Ubuntu) configured for your system. All you need to do is to execute the following command as root or as sudo In Ubuntu the command is hari@spider:~$ sudo apt-get install gnokii gnokii-smsd gnokii-smsd-mysql In fedora the command is root@spider:~# yum install gnokii gnokii-smsd gnokii-smsd-mysql The above packages have lots of dependencies like libgnokii3, liblockfile1, timeout, dialog, mysql-common, libmysqlclient15off. So it is better to install gnokii using yum (Fedora) or apt (Ubuntu) instead of rpm (Fedora )or dpkg (Ubuntu). Installing from Source: This will be useful if you don't have a yum or apt configured. Download the source package from http://www.gnokii.org/download/gnokii/. Then execute the following. I have used gnokii-0.6.9 for example. It might differ in your case.[root@spider ~]# tar -zxvf gnokii-0.6.9.tar.gz
[root@spider ~]# cd gnokii-0.6.9/
[root@spider gnokii-0.6.9]# ./configure
[root@spider gnokii-0.6.9]# make
[root@spider gnokii-0.6.9]# make install
Gnokii Configuration : Once gnokii is installed, we need to change the configuration file (gnokiirc) and check whether the computer can identify the mobile phone. The configuration file can be located at two places. One in your home folder and the another in /etc. If there is no file in your home folder, then gnokii uses the configuration file present in /etc. The mobile phone i use is Nokia, model 7250i, type NHL-4JX. For the example below, let us assume that you have permissions to edit the configuration file in /etc. Else copy the file from /etc and