<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Most likely you didn't ckecked the options to create database for
siremis during the installation wizard step 2:<br>
<br>
- <a class="moz-txt-link-freetext" href="http://kb.asipto.com/siremis:install40x:main#step_2">http://kb.asipto.com/siremis:install40x:main#step_2</a><br>
<br>
There are 4 options there, you have to select all of them first
time.<br>
<br>
You should drop siremis database if you created some tables
manually.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<br>
<div class="moz-cite-prefix">On 17/03/14 19:54, malik sherif wrote:<br>
</div>
<blockquote cite="mid:BLU174-W28BE5FBDB11739FFA261B6AE7D0@phx.gbl"
type="cite">
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style>
<div dir="ltr"><br>
<br>
<div>
<hr id="stopSpelling">From: <a class="moz-txt-link-abbreviated" href="mailto:asherif74@hotmail.com">asherif74@hotmail.com</a><br>
To: <a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
Date: Mon, 17 Mar 2014 16:28:46 +0000<br>
Subject: [SR-Users] login to siremis failed 'siremis.user'
doesn't exist<br>
<br>
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style>
<div dir="ltr">When I attempted to login to siremis , i got
the following errors "Base table or view not found: 1146
Table 'siremis.user' doesn't exist"<br>
<br>
<br>
And then I created the table manually using the following
commands<br>
<br>
CREATE TABLE `user` (<br>
<br>
`SYSID` int(11) NOT NULL auto_increment,<br>
<br>
`USERID` varchar(15) NOT NULL,<br>
<br>
`PASSWORD` varchar(15) default NULL,<br>
<br>
PRIMARY KEY (`SYSID`)<br>
<br>
);<br>
<br>
But I still have problem login with the following error
"Column not found: 1054 Unknown column 'T0.id' in 'field
list'".<br>
The I run describe user, i got the following; <br>
mysql> describe user;<br>
+----------+-------------+------+-----+---------+----------------+<br>
| Field | Type | Null | Key | Default |
Extra |<br>
+----------+-------------+------+-----+---------+----------------+<br>
| SYSID | int(11) | NO | PRI | NULL |
auto_increment |<br>
| USERID | varchar(15) | NO | | NULL
| |<br>
| PASSWORD | varchar(15) | YES | | NULL
| |<br>
+----------+-------------+------+-----+---------+----------------+<br>
3 rows in set (0.07 sec)<br>
<br>
Any idea? <br>
Your help is greatly appreciated<br>
Thanks<br>
Abdul<br>
</div>
<br>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a></div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference - April 2-4, 2014, Berlin, Germany
<a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
</body>
</html>