LinuxQuestions.org
Review your favorite Linux distribution.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 08-12-2009, 04:47 AM   #1
happyalways
LQ Newbie
 
Registered: Aug 2009
Posts: 4

Rep: Reputation: 0
why i'm unable to create tables in openser database


Hii all,
I installed mysql-5.0.37, openser-1.5.1 succesfully...
I'm able to connect to softphone also i.e., able to register an username with the sip.
For going to authentication, we need to create database openser first.
I used #kamdbctl create to create the database.
Database is created but core tables are not being created.
I'm facing the below error:

#kamdbctl create
MySQL password for root:
database engine 'mysql' loaded
INFO: test server charset
INFO: creating database openser ...
Creating core table: standard
/usr/local/lib/kamailio/kamctl/kamdbctl.mysql: line 155: ./mysql/standard-create.sql: No such file or directory
ERROR: Creating core tables failed!

Please help me....
Thanks in Advance
 
Old 08-12-2009, 08:51 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,635

Rep: Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965
Quote:
Originally Posted by happyalways View Post
Hii all,
I installed mysql-5.0.37, openser-1.5.1 succesfully...
I'm able to connect to softphone also i.e., able to register an username with the sip.
For going to authentication, we need to create database openser first.
I used #kamdbctl create to create the database.
Database is created but core tables are not being created.
I'm facing the below error:

#kamdbctl create
MySQL password for root:
database engine 'mysql' loaded
INFO: test server charset
INFO: creating database openser ...
Creating core table: standard
/usr/local/lib/kamailio/kamctl/kamdbctl.mysql: line 155: ./mysql/standard-create.sql: No such file or directory
ERROR: Creating core tables failed!

Please help me....
Thanks in Advance
Wow...seems very familiar to the question posted elsewhere, within the past week...exactly the same, but by a different user...what are the odds...

The error message is quite clear. That file can't be found, in the path specified. So open the kamdbctl.mysql file, and look at line 155. Figure out where that "./mysql/standard-create.sql" file is supposed to be, and look for it. Either modify the path, or move the file into the right place.
 
Old 08-13-2009, 11:40 PM   #3
happyalways
LQ Newbie
 
Registered: Aug 2009
Posts: 4

Original Poster
Rep: Reputation: 0
thank u for ur advice....
The file is in the correct location. But the line 155 is

sql_query $1 < $DB_SCHEMA/$TABLE-create.sql
In this line i'm not having ./mysql/standar-create.sql. what is the error?? Please rectify as soon as possible...

Thanks....
 
Old 08-14-2009, 10:07 AM   #4
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,635

Rep: Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965
Quote:
Originally Posted by happyalways View Post
thank u for ur advice....
The file is in the correct location. But the line 155 is

sql_query $1 < $DB_SCHEMA/$TABLE-create.sql
In this line i'm not having ./mysql/standar-create.sql. what is the error?? Please rectify as soon as possible...

Thanks....
Note that we volunteer our time here...don't tell us to hurry and fix your problem. If you need "URGENT" support, get a paid subscription to some version of Linux that has it (RedHat enterprise, SuSE enterprise, etc.), and they'll take your questions 24/7, and answer you quickly.

Other than that...READ THE ERROR MESSAGE. I told you how to fix it in my previous post. Either that file doesn't exist, or isn't where the script is expecting it. Move it there, or change the script. Chances are, those $DB_SCHEMA and $TABLE variables are set SOMEWHERE in that script...find them, and modify them accordingly. And READ THE INSTALL INSTRUCTIONS...again, they make mention of those, and tell you what/how to change it....tdp
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] location of tables in mysql database in linux Buddhike G Linux - Software 1 09-10-2007 05:27 AM
Finding What Tables Exist In A MySQL Database taylor_venable Programming 7 12-19-2005 09:52 PM
Update database tables on different servers securely daveedj Linux - General 0 12-13-2005 12:40 PM
Creating Ora10g database on FC2 gives unable to create shared memory segment.... deanbrown3d Linux - Software 1 10-23-2004 11:40 AM
mysql count tables in a database Longinus Programming 2 04-11-2004 01:22 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 11:44 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration